최신SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 - A00-215무료샘플문제
문제1
Your SAS program generates the following messages in the log:
Which of the following statements are true about this situation? Select all that apply.
Your SAS program generates the following messages in the log:
Which of the following statements are true about this situation? Select all that apply.
정답: A,D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제2
Consider a dataset named 'CUSTOMERS' with variables 'CUSTOMER D', 'NAME', 'CITY', 'STATE', and 'ZIP'. You want to generate a report that displays only the 'CUSTOMER ID', 'NAME', and 'CITY' variables, but you want to sort the report by 'STATE' in ascending order and then by 'CITY' in descending order. Which PROC PRINT statement accomplishes this?
Consider a dataset named 'CUSTOMERS' with variables 'CUSTOMER D', 'NAME', 'CITY', 'STATE', and 'ZIP'. You want to generate a report that displays only the 'CUSTOMER ID', 'NAME', and 'CITY' variables, but you want to sort the report by 'STATE' in ascending order and then by 'CITY' in descending order. Which PROC PRINT statement accomplishes this?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제3
Consider the following SAS code snippet. What type of error, if any, does the code contain?
Consider the following SAS code snippet. What type of error, if any, does the code contain?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제4
You are analyzing a SAS dataset with a variable 'Age' defined as a numeric variable. A record has a missing value for 'Age'. How is this missing value represented in the SAS dataset?
You are analyzing a SAS dataset with a variable 'Age' defined as a numeric variable. A record has a missing value for 'Age'. How is this missing value represented in the SAS dataset?
정답: E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
You have a dataset 'CUSTOMERS' with a variable 'CITY containing city names and a variable ZIP CODE'. You want to create a sorted dataset 'CUSTOMERS SORTED' where the city names are sorted alphabetically, but within each city, the ZIP codes are sorted in descending order. How would you achieve this?
You have a dataset 'CUSTOMERS' with a variable 'CITY containing city names and a variable ZIP CODE'. You want to create a sorted dataset 'CUSTOMERS SORTED' where the city names are sorted alphabetically, but within each city, the ZIP codes are sorted in descending order. How would you achieve this?
정답: E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제6
You have a dataset with a variable 'DATE STR' storing dates in the format 'YYYY-MM-DD'. You want to create a new variable 'DATE NUM' storing the date in numeric format (YYYYMMDD). Which code snippet correctly achieves this transformation?
You have a dataset with a variable 'DATE STR' storing dates in the format 'YYYY-MM-DD'. You want to create a new variable 'DATE NUM' storing the date in numeric format (YYYYMMDD). Which code snippet correctly achieves this transformation?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제7
You need to import a CSV file with dates formatted as YYYY-MM-DD. However, the file has an additional column containing time data formatted as HH:MM:SS. You want to import the date column as a SAS date value, but the time column should be a SAS time value. How would you achieve this in PROC IMPORT?
You need to import a CSV file with dates formatted as YYYY-MM-DD. However, the file has an additional column containing time data formatted as HH:MM:SS. You want to import the date column as a SAS date value, but the time column should be a SAS time value. How would you achieve this in PROC IMPORT?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
You have a SAS dataset named 'CUSTOMERS' with variables 'CustomerlD', 'Name', 'City', 'State', and 'Zipcode'. You want to create a report that displays only the 'CustomerlD', 'Name', and 'City' variables for customers residing in 'California' and 'Texas' but not in 'Los Angeles' city. Which PROC PRINT statement achieves this?
You have a SAS dataset named 'CUSTOMERS' with variables 'CustomerlD', 'Name', 'City', 'State', and 'Zipcode'. You want to create a report that displays only the 'CustomerlD', 'Name', and 'City' variables for customers residing in 'California' and 'Texas' but not in 'Los Angeles' city. Which PROC PRINT statement achieves this?
정답: B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제9
You have a CSV file named 'sales_data.csv' with the following structure: Product,Region,Sales Product A,North,1000 Product Product C,East,800 Product D,West, 1200 You need to import this data into a SAS dataset named 'SALES' with the following requirements: 1. The 'Sales' column should be converted to a numeric variable. 2. The 'Region' column should be treated as a character variable. 3. The 'Product' column should be the primary key. Which of the following PROC IMPORT statements would achieve this correctly?
You have a CSV file named 'sales_data.csv' with the following structure: Product,Region,Sales Product A,North,1000 Product Product C,East,800 Product D,West, 1200 You need to import this data into a SAS dataset named 'SALES' with the following requirements: 1. The 'Sales' column should be converted to a numeric variable. 2. The 'Region' column should be treated as a character variable. 3. The 'Product' column should be the primary key. Which of the following PROC IMPORT statements would achieve this correctly?
정답: B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제10
A dataset has a variable 'AGE' containing values like 25.3, 31.7, 42.1. You need to truncate these values to the nearest whole number, discarding any fractional part. Which SAS code snippet accomplishes this correctly?
A dataset has a variable 'AGE' containing values like 25.3, 31.7, 42.1. You need to truncate these values to the nearest whole number, discarding any fractional part. Which SAS code snippet accomplishes this correctly?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제11
You are working with a SAS dataset 'PRODUCTS' with variables 'PRODUCT ID', 'PRODUCT NAME', and 'PRICE'. You want to create a new variable 'DISCOUNT PRICE' that calculates a 10% discount on the 'PRICE' if 'PRODUCT NAME' is 'Laptop' and the 'PRICE' is not missing, otherwise set it to missing. Which code snippet correctly achieves this?
You are working with a SAS dataset 'PRODUCTS' with variables 'PRODUCT ID', 'PRODUCT NAME', and 'PRICE'. You want to create a new variable 'DISCOUNT PRICE' that calculates a 10% discount on the 'PRICE' if 'PRODUCT NAME' is 'Laptop' and the 'PRICE' is not missing, otherwise set it to missing. Which code snippet correctly achieves this?
정답: C,E
설명: (ITDumpsKR 회원만 볼 수 있음)