The following the problem from the free model test paper of Base SAS certification exam and the code I wrote.The answer I get is not tallying with the right answer given: 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: o 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). o 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. 1.What is the value of Employee_ID for observation 100 in results.output27a? Right Answer given is : 120781  My answer is 121030. I checked for the employee_id 120781. It is not  there in the input27 dataset.  can you kindly explain. The code I wrote : Proc sort data = cert.input27 out= output27; where upcase(country)='US'; by state descending postal_code employee_id; run; proc print data=output27 (firstobs=100 obs=100); var employee_id; run; ... View more

I used the following procedure to create a library using xlsx engine. there are twenty worksheets in the excel file. But in proc contents I am not able to see why?   libname xyz xlsx 'C:\Users\Mallik\Desktop\94basepe\input\SDTM_METADATA.xlsx'; run; proc contents data =xyz._all_ ; run; proc datasets lib=xyz; quit;   Log: libname xyz xlsxl'C:\Users\Mallik\Desktop\94basepe\input\SDTM_METADATA.xlsx'; NOTE: Libref XYZ was successfully assigned as follows: Engine: EXCEL Physical Name: C:\Users\Mallik\Desktop\94basepe\input\SDTM_METADATA.xlsx 19626 run;   when I use proc contents or proc datasets I am only able to see the following without the list of the sheets in the workbook. The library when verified by opening also had no files. Why did this happen???   ... View more

How do I achieve to get a dataset with first.dot make in the following example.     data cars; set sashelp.cars; run; proc sort data=cars out=carrs; by make descending type; run;   data carstype; set carrs; by type; if first.type; run;   Error in the log: data carstype; 19621 set carrs; 19622 by type; 19623 if first.type; 19624 run; ERROR: BY variables are not properly sorted on data set WORK.CARRS. Make=Acura Model=NSX coupe 2dr manual S Type=Sports Origin=Asia DriveTrain=Rear MSRP=$89,765 Invoice=$79,978 EngineSize=3.2 Cylinders=6 Horsepower=290 MPG_City=17 MPG_Highway=24 Weight=3153 Wheelbase=100 Length=174 FIRST.Type=1 LAST.Type=1 _ERROR_=1 _N_=1 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 2 observations read from the data set WORK.CARRS. ... View more