Online Access Free A00-215 Exam Questions

You have a CSV file 'customer_data.csv' with columns 'customer_id', 'name', 'city', 'state', 'zip_code'. You want to import this data into a SAS dataset called 'CUSTOMERS' using PROC IMPORT. However, the 'zip_code' column in the CSV file contains leading zeros. You want to import 'zip_code' as a character variable while preserving the leading zeros. How would you modify the PROC IMPORT statement to accomplish this?

• A.
• B.
• C.
• D.
• E.

You are analyzing a dataset containing customer feedback on a new product. You want to generate a two-way frequency table displaying the relationship between customer age (categorized as 'Young', 'Middle-Aged', and 'Senior') and feedback rating (categorized as 'Excellent', 'Good', 'Fair', 'Poor'). You want to control the layout of the table to have customer age on the rows and feedback rating on the columns, and also include both row and column percentages. Which of the following PROC FREQ statements would achieve this? (Select all that apply.)

• A.
• B.
• C.
• D.
• E.

You have a dataset called 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You want to sort the data in ascending order by 'REGION' and then in descending order by 'SALES AMOUNT' within each region. Which PROC SORT statement achieves this?

• A.PROC SORT DATA=SALES OUT-SORTED SALES; BY REGION, SALES AMOUNT DESCENDING; RUN,
• B.PROC SORT DATA=SALES, BY SALES AMOUNT DESCENDING, REGION ASCENDING; RUN,
• C.PROC SORT DATA=SALES, BY REGION ASCENDING, SALES AMOUNT DESCENDING; RUN,
• D.PROC SORT DATA=SALES, BY REGION, SALES AMOUNT; RUN,
• E.PROC SORT DATA=SALES; BY REGION DESCENDING; RUN,

You are working with a dataset containing customer demographics. You want to create a custom format that labels missing values for the 'Age' variable as 'Unknown'. Which PROC FORMAT code snippet correctly defines the custom format using the keyword 'OTHER' for this scenario?

• A.
• B.
• C.
• D.
• E.

You have a dataset with customer purchase data, including 'CustomerlD', 'PurchaseDate', and 'AmountSpent'. You want to create a new variable 'LoyaltyStatus' based on the following criteria: - If a customer has made more than 5 purchases within the last 3 months, assign 'Loyal'. - If a customer has made between 2 and 5 purchases within the last 3 months, assign 'Regular'. - Otherwise, assign 'New'. Which of the following code snippets would correctly implement this logic within a DATA step?

• A.
• B.
• C.
• D.
• E.