Free SAS 9.4 Base Programming – Performance-Based Exam A00-231 Exam Practice Test

SIMULATIONScenario:This project will use data set cert.input13. At any time, you may save your program as program13 in cert\programs.This data set contains 1001 observations and 2 variables:Date1, a numeric variable representing an unformatted SAS date value. Example: 12001.Charnum, a character variable representing a monetary amount. Example: $50,000.Write a SAS program that will:Save the new data set as results.output13.Create a new variable Chdate that convertsthe datel variable to a character variable that is in the format ddmonyyyy, such as 11NOV1992.Create a new variable num1 that converts the Charnum variable to a numeric variable.What is the value ofChdatefor observation 52?

SIMULATIONScenario:This project will use data set cert.input12. At any time, you may save your program as program12 in cert\programs.cert.input12 contains a single observation with two variables:o salaryo yearWrite a SAS program that will:Create an output data set results.output12.Read cert.input12 as input.Increase the salary variable by 5.65% annually until it is greater than $500,000.Increment the year variable by 1 with each annual increase.Create an output data set results.output12 that has one observation for each value of year. Each observation should have a year and salary variable.What is the value of year when the above salary occurs? Enter your numeric answer in the space below.

SIMULATIONScenario:This project will use data set cert.input13. At any time, you may save your program as program13 in cert\programs.This data set contains 1001 observations and 2 variables:Date1, a numeric variable representing an unformatted SAS date value. Example: 12001.Charnum, a character variable representing a monetaryamount. Example: $50,000. Write a SAS program that will:Save the new data set as results.output13.Create a new variable Chdate that convertsthe datel variable to a character variable that is in the format ddmonyyyy, such as 11NOV1992.Create a new variable num1 that converts the Charnum variable to a numeric variable.What is the average (mean) of the num1 variable for the entire data set?Enter your numeric answer in the space below (Round your answer to the nearest integer).

SIMULATIONScenario:This project will use data setcert.input04. At any time, you may save your program asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.In this program, complete the following mathematical actions, in the following order: Round VAR1 and VAR2 to the nearest integer values.Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3.Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.For observation 16, what is the value ofVAR20? Enter your numeric answer in the space below. Round your answer to the nearest whole number. Save your program asprogram04.sasincert\programs before continuing with the next project

SIMULATIONScenario:This project will use data set cert.input27. At any time, you may save your program as program27 in cert\programs. You will use this program in the next project.Write a SAS program that will:Create output data set results.output27a as a subset of cert.input27 where the country variable's value is "US" (any variation of case, such as US or us).Sort results.output27a:" first by the variable state in ascending order " then by Postal_Code in descending order" and finally by employee_ID in ascending order.Run the program and use the results to answer the question below.What is the value of Employee_ID for observation 100 in results.output27a?

SIMULATIONScenario:This project will use data set cert.input08a and cert.input08b. At any time, you may save your programas program08 in cert\programs.Both data sets contain a common numeric variable named ID. Write a program that will use a SAS DATA Step to:Combine data sets cert.input08a and cert.input08b by matching values of the ID variable.Write only observations that are in both data sets to a new data set named results.match08.Write all other non-matching observations from either data set to a new data set named results.nomatch08.Exclude all variables that begin with "ex" from results.nomatch08.How many variables (columns) are in results.match08

The following SAS program is submitted:data work.test; type='SQL';if type='SAS' then description='SAS Program'; else description='other'; length description 8; run;What occurs when the program is submitted? Select one:

• The variable Description is created as an 11-byte character variable and is assigned the value 'SAS program' in the DATA step.
• The variable Description is created as a 5-byte character variable and is assigned the value 'SAS P' in the DATA step.
• The variable Description is created as an 8-byte character variable and is assigned the value 'SAS Prog' in the DATA step.
• The variable Description is created as an 11-byte character variable and the DATA step fails due to errors.

SIMULATIONScenario:This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:Step 1:create a temporary data set, cleandata36. In this data set, convert all case.Then keep only observations with group equal to 'A' or 'B'.Step 2:Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.Step 3:Create results.output36 from cleandata36Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respectivegroup(A,B) calculated in step 2How many observations are inresults.output36?

Which of the following SAS programs creates a variable named City with a value ofChicago? Select one:

• data work.airport; AirportCode='ord';if (AirportCode='ord') City='Chicago'; run;
• data work.airport; AirportCode='ORD';if AirportCode='ORD' then City=Chicago; run;
• data work.airport; AirportCode='ORD'; if AirportCode='ORD'; then City='Chicago'; run;
• data work.airport; AirportCode='ORD';
• if AirportCode='ORD' then City='Chicago'; run;

Given the following SAS data set WORK.CLASS:Name Gender Age Anna F 23Ben M 25Bob M 21Brian M 27Edward M 26Emma F 32Joe M 34Sam F 32Tom M 24The following program is submitted: data WORK.MALES WORK.FEMALES(drop=age); set WORK.CLASS; drop gender; if Gender="M" then output WORK.MALES; else if Gender="F" then output WORK.FEMALES; run; How many variables are in the data set WORK.MALES?Select one:

• The program does not execute due to a syntax error.
• 1
• 2
• 3