問題1
You need to generate a report showing the median and standard deviation of a variable 'Weight' for different age groups (under 18, 18-30, 30-50, 50+). Which of the following PROC MEANS statements would you use?
You need to generate a report showing the median and standard deviation of a variable 'Weight' for different age groups (under 18, 18-30, 30-50, 50+). Which of the following PROC MEANS statements would you use?
正確答案: B
說明：（僅 NewDumps 成員可見）
問題2
You have a SAS dataset named 'CustomerData' located in the '/home/datasets/' directory, and you want to create a new library called 'CUSTOMER' to access it. You also want to specify that the dataset is located on a Unix server using the 'SERVER' option. Additionally, you want to use a specific SAS session user, 'adminuser', and password, 'password 1 23', for accessing the dataset. Which LIBNAME statement is correct for this scenario?
You have a SAS dataset named 'CustomerData' located in the '/home/datasets/' directory, and you want to create a new library called 'CUSTOMER' to access it. You also want to specify that the dataset is located on a Unix server using the 'SERVER' option. Additionally, you want to use a specific SAS session user, 'adminuser', and password, 'password 1 23', for accessing the dataset. Which LIBNAME statement is correct for this scenario?
正確答案: B
說明：（僅 NewDumps 成員可見）
問題3
You have a dataset with a variable 'AMOUNT' containing numeric values with decimals. You need to create a new variable 'ROUNDED AMOUNT' by rounding the 'AMOUNT' values to the nearest hundredth using the ROUND function. Which code snippet achieves this correctly?
You have a dataset with a variable 'AMOUNT' containing numeric values with decimals. You need to create a new variable 'ROUNDED AMOUNT' by rounding the 'AMOUNT' values to the nearest hundredth using the ROUND function. Which code snippet achieves this correctly?
正確答案: D
說明：（僅 NewDumps 成員可見）
問題4
You have a dataset with a variable 'DATE VAR' storing dates in SAS date format. You need to calculate the number of days between 'DATE VAR' and a constant date '01JAN2023'd. Which code snippet correctly performs this calculation?
You have a dataset with a variable 'DATE VAR' storing dates in SAS date format. You need to calculate the number of days between 'DATE VAR' and a constant date '01JAN2023'd. Which code snippet correctly performs this calculation?
正確答案: C
說明：（僅 NewDumps 成員可見）
問題5
You have a SAS data set called 'CUSTOMERS' stored in a library named 'CUSTOMERS LIB'. You need to read the data set 'CUSTOMERS' into another data set called 'NEW CUSTOMERS', selecting only the 'CUSTOMER ID' and 'NAME' variables. Which of the following SAS code snippets achieves this?
You have a SAS data set called 'CUSTOMERS' stored in a library named 'CUSTOMERS LIB'. You need to read the data set 'CUSTOMERS' into another data set called 'NEW CUSTOMERS', selecting only the 'CUSTOMER ID' and 'NAME' variables. Which of the following SAS code snippets achieves this?
正確答案: C
說明：（僅 NewDumps 成員可見）
問題6
You have a dataset with a variable named 'REGION' containing numeric values representing different geographical regions. You need to display these regions in a report using meaningful labels like 'North America', 'Europe', etc. Which code snippet correctly defines a custom format using PROC FORMAT to achieve this?
You have a dataset with a variable named 'REGION' containing numeric values representing different geographical regions. You need to display these regions in a report using meaningful labels like 'North America', 'Europe', etc. Which code snippet correctly defines a custom format using PROC FORMAT to achieve this?
正確答案: D
說明：（僅 NewDumps 成員可見）
問題7
You have a dataset 'Employees' with a 'Hire_Date' variable in the format 'YYMMDDIO.'. You need to categorize employees based on their tenure (time employed) into three groups: 'New Hire' (less than 1 year), 'Experienced' (1 to 5 years), and 'Veteran' (more than 5 years). Which code snippet correctly performs this categorization?
You have a dataset 'Employees' with a 'Hire_Date' variable in the format 'YYMMDDIO.'. You need to categorize employees based on their tenure (time employed) into three groups: 'New Hire' (less than 1 year), 'Experienced' (1 to 5 years), and 'Veteran' (more than 5 years). Which code snippet correctly performs this categorization?
正確答案: A
說明：（僅 NewDumps 成員可見）
問題8
You have a SAS dataset named 'CUSTOMERS' with variables 'CUSTOMER ID', 'NAME', 'AGE', 'CITY', 'STATE', 'ZIPCODE'. You want to create a new dataset named 'CUSTOMERS SELECTED' containing only the 'CUSTOMER ID', 'NAME', and 'CITY' variables from 'CUSTOMERS'. Which code snippet correctly achieves this using the KEEP= option?
You have a SAS dataset named 'CUSTOMERS' with variables 'CUSTOMER ID', 'NAME', 'AGE', 'CITY', 'STATE', 'ZIPCODE'. You want to create a new dataset named 'CUSTOMERS SELECTED' containing only the 'CUSTOMER ID', 'NAME', and 'CITY' variables from 'CUSTOMERS'. Which code snippet correctly achieves this using the KEEP= option?
正確答案: A,C,D
說明：（僅 NewDumps 成員可見）
問題9
You need to create a SAS dataset called 'WORK.CUSTOMER SALES' that combines data from two existing datasets: 'WORK.CUSTOMERS' and 'WORK.SALES'. The 'WORK.CUSTOMERS' dataset contains customer information (CustomerlD, Name, City), while 'WORK.SALES' contains sales data (CustomerlD, Product, SalesAmount). You want to merge the data based on the 'CustomerlD' variable and include all customers, even those without sales records. Which of the following code snippets will achieve this objective correctly? Choose all that apply.
You need to create a SAS dataset called 'WORK.CUSTOMER SALES' that combines data from two existing datasets: 'WORK.CUSTOMERS' and 'WORK.SALES'. The 'WORK.CUSTOMERS' dataset contains customer information (CustomerlD, Name, City), while 'WORK.SALES' contains sales data (CustomerlD, Product, SalesAmount). You want to merge the data based on the 'CustomerlD' variable and include all customers, even those without sales records. Which of the following code snippets will achieve this objective correctly? Choose all that apply.
正確答案: D,E
說明：（僅 NewDumps 成員可見）