SAS EXAM ADVANCED QUESTIONS AND ANSWERS

SAS EXAM ADVANCED QUESTIONS AND ANSWERS #6 Open a new programming window to create MAC in certprograms. This project uses 100 data sets, 1 through 100. The data sets all contain the same variables. Write a SAS program that will: Define a macro named combo03. This macro should append the data sets to each other, in numeric order (data1, then data2, then data3, etc) into one data set named ned03. Call your combo03 macro. Run your program and troubleshoot as necessary. When you are finished with the project, answer the next two questions. - answer- %macro combo03; data ned03; set %do i=1 %to 100; &i %end; ; run; %mend combo03; %combo03 #6 How many observations are in the output data set? Enter your numeric answer in the space below: - answer- 5189 #6 What is the value of variable VAR4 in observation 2000? Enter your numeric answer in the space below: - answer- 386 #8 Write a SAS program that will: Use macro debugging system options to answer the following 2 questions. Call the compiled macro cars18 with two positional parameter values: · Asia · Europe - answer- options mprint; %cars18(Asia, Europe) #8 What is the value of the OBS= option in the SET statement? Enter your numeric answer in the space below: - answer- 1000 #10 Open a new programming window to create ACT in certprograms. Write a SAS program to load the ion22 data set into a HASH object. Use the following guidelines: DIV is the key component containing the Division code League and Division are the data components and should be defined with a character variable length of 10 bytes. Perform a lookup on the 22 data set to combine the Division codes with their description. Store the results in the work.ACT22 data set. Run your program and troubleshoot as necessary. When you are finished with the project, answer the next 2 questions. - answer- data work.ACT22; length League Division $ 10; if _n_=1 then do; call missing(League); call missing(Division); declare hash D(dataset: 'cert.Division22'); D.definekey('Div'); D.definedata('League', 'Division'); D.definedone(); end; set 22; D.find(); run; #10 How many rows are in the output data set? Enter your numeric answer in the space below: - answer- 26 #10 What is the value of variable DIV for the observation that has variable team = Boston ? - answer- AE #13 Open a new programming window to create ACT in certprograms. Write a SAS program that will: Create 09 from the d09 data set. Use pearl regular expression functions to output only observations with valid national ID numbers (variable National_ID). A valid national ID number is in the form: nnn-nn-nnnn where n is any digit 0-9. Run your program and troubleshoot as necessary. When you are finished with the project, answer the next 2 questions. - answer- data 09(drop=chk pattern); set d09; pattern=prxparse('/ddd-dd-dddd/'); chk=prxmatch(pattern,national_ID); if chk then output; #10 How many observations are in 09? - answer- 394 #10 What is the value of variable CustomerID for observation 100 in 09? - answer- CST49860 #16 Given the following SAS program: proc sql ; select nt_ID, Height, Weight from work.StudentHeight H inner join work.StudentWeight W on nt_ID= nt_ID order by height desc, weight; quit; See #16 practice exam study 1 - answer- A #23 This question will ask you to provide a segment of missing code. The following SAS program is submitted to create and use a macro function: %macro nextpayment(mydate,rentdue) / minoperator; insert code here %mend; data WORK.RENTUPDATE; length overdue $8; set SASHELP.RENT; if