A00-215 試験問題を無料オンラインアクセス

You are tasked with importing a CSV file containing financial dat
a. The file has a header row, but some columns have missing values represented by empty strings. You want to import these missing values as SAS missing values (.) rather than empty strings. Which PROC IMPORT option would you use to achieve this?

• A.REPLACE-YES
• B.OUT=dataset
• C.MISSING-YES
• D.DBMS=CSV
• E.GUESSINGROWS=MAX

You have a SAS dataset 'work.sales' with variables 'sales_amt', and 'product id'. You want to create a new dataset that summarizes total sales by 'product id'. Which of the following PROC steps would achieve this?

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

You are analyzing a dataset containing customer information. You want to create a report that summarizes the average age of customers by their 'IncomeGroup' variable, but you want to display the IncomeGroup values with more descriptive labels. For example, instead of 'High', 'Medium', 'Low', you want to display 'High Income', 'Medium Income', 'Low Income'. How would you use the LABEL statement and PROC MEANS to achieve this?

• A.PROC MEANS DATA=YourDataset; VAR Age; CLASS IncomeGroup, LABEL IncomeGroup = 'High Income' / IncomeGroup = 'Medium Income' / IncomeGroup = 'Low Income'; RUN,
• B.PROC MEANS DATA=YourDataset; VAR Age; CLASS IncomeGroup; LABEL IncomeGroup = 'High Income' / IncomeGroup = 'Medium Income'; RUN,
• C.PROC MEANS DATA=YourDataset; VAR Age; CLASS IncomeGroup; LABEL 'High Income' = IncomeGroup / 'Medium Income' = IncomeGroup / 'Low Income' = IncomeGroup; RUN;
• D.PROC MEANS DATA=YourDataset; VAR Age; CLASS IncomeGroup, LABEL IncomeGroup = 'High Income' / 'Medium Income' / 'Low Income', RUN,
• E.PROC MEANS DATA=YourDataset; VAR Age; CLASS IncomeGroup; LABEL IncomeGroup = 'High Income' / IncomeGroup = 'Medium Income' / IncomeGroup = 'Low Income'; OUTPUT OUT=Summary; RUN;

You have a dataset 'sales_data' with variables 'Region', 'Product', and 'Sales'. You want to create a frequencyreport that displays the frequency counts for each region and product combination, but you only want to see the counts for those combinations where the sales value is greater than $10,000. How would you modify the PROC FREQ statement to achieve this?

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

Which of the following statements about global SAS statements are true? (Select all that apply)

• A.Global statements are specific to the current SAS program and are not accessible from other programs within the same SAS session.
• B.Global statements are executed before any other SAS program code.
• C.Global statements can be used to set options, define macro variables, and declare formats.
• D.Global statements are defined using the 'global' keyword.
• E.Global statements are processed only once, regardless of how many times they are encountered in a SAS sessiom