SAS Base Programming for SAS 9 A00-211 Exam Dumps

1. The following SAS program is submitted:

2. Given the SAS data sets EMPLOYEE and SALARY:
EMPLOYEESALARYname agename salaryBruce 30Bruce 40000Dan 35Bruce 35000Dan 37000Dan.


How many observations will the data set WORK.EMPSALARY contain?

3. The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7;
The following SAS program is submitted:
Data WORK.FEE_STRUCTURE;
Format LocalFee CountryFee precent7.2;
Set WORK.REALESTATE;
LocalFee= LocalFee/100;
CountryFee= CountryFee/100;
Run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

4. The following SAS program is submitted:
data work .sets;
do until (prod gt 6);
prod +1 ;
end ;
run;
what is the value of the variable PROD in the output data set?

5. Given the SAS data sets EMPLOYEE and SALARY:
EMPLOYEESALARYname agename salaryBruce 30Bruce 25000Dan 40Bruce 35000Dan 25000.


Which MERGE statement ly completes the program?

6. Given the following raw data record:
07 jan 2005
Which INFOPMAT reads this data and stores it as SAS date value?

7. Given the contents of the SAS data set PERM.JAN_SALES:
PERM.JAN _ SALES
VARIABLE NAMETYPE
Idnum character variable
Sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set .the SALES_DATE values need to be in a MMDDYY10 from.
Which SAS program corretly creates this raw data file?

8. The following SAS program is submitted:
data _ null_;
set old ;
put sales 1 sales
2;
run;
where is the output written?

9. The following SAS program is submitted:


How many boservation are processed by each procedure?

10. Give the following raw data file:


What is the result?

11. Give the SAS data set WORK.AWARDS:FNAME POINTS MONTH


How are the observations sorted?

12. Given the SAS data set OTR1_REVENUE:


What is the first observation in the output data set ?

13. The following SAS program is submitted:


what are the values of the AMOUNT and WORD variables in SAS dataset work new?

14. The following SAS program is submitted :


What is the result?

15. The following SAS program is submitted:


What is the valueof the variable JOBCATEGORY IN the output data set ?

16. The following SAS program is submitted:


What is the value of the TOTALPASSENGERS variable in the output data set ?

17. The following SAS program is submitted:


What is the result?

18. The following SAS program is submitted:


The WORKDEPATMENT data set contains a character variable neamed JOBCODE with a length of 5
What is the result?

19. The following SAS program is submitted:


A character variable named JOBCODE is contained in both the WOTk.DEPT1 and WORK.DEPT2 SAS data sets.
The variable JOBCODE has a length of 5 in the WORK .DEPT1 data set and a length of 7 in the WOFK.DEPT2 data set.
What is the length of the variable JLBCODE in the output data set ?

20. The following SAS program is submitted:


The SAS data set WORK.SALARY, currently ordered by DEPARTMENT ,contains 100 observations for each of 5 departments.
What is the result?