Advance SAS CertifIcation Exam Question 13

Given the following raw data record:

----I----10---I----20---I----30

son Travis,

The following output is desired:

Obs relation firstname

1 son Travis

Which SAS program correctly reads in the raw data?

A - data family ( dIm = ‘,’); infile ‘tile specification’; input relation $ firstname $; run;

B - options dIm = ‘,’; data family; infile ‘file specification’; input relation $ firstname $; run;

C - data family; infile ‘file specification’ dIm = ‘,’; input relation $ firstname $; run;

D - data family; infile ‘file specification’; input relation $ firstname $ / dim = ‘,’; run;

 Contact Details :

K.Naveen SAS Trainer 
+91-9177856619 (INDIA) 
001-214-347-4655 (USA)
Knaveen.sas@gmail.com 
goodonlinetrainings@gmail.com  
For further details:
www.sasonlinetraining.training

Advance SAS CertifIcation Exam Question 12

The following SAS program Is submittad:

data work.sales;

do year = 1 to 5;

do month=1 to 12;

x+1;

output

end;

end;

run;

How many observations are written the WORK SALES data set?

A - 0

B - 1

C - 5

D - 60

 Contact Details :

K.Naveen SAS Trainer 
+91-9177856619 (INDIA) 
001-214-347-4655 (USA)
Knaveen.sas@gmail.com 
goodonlinetrainings@gmail.com  
For further details:
www.sasonlinetraining.training

Advance SAS CertifIcation Exam Question 11

The following SAS program is submitted:

proc sort data = work.employee;

by descending fname;

proc sort data = work.salary;

by descending fname;

data work.empdata;

merge work.employee

work.salary;

by fname;

run;

Why does the program rail to execute?

A - The SORT procedures contain invalid syntax.

B - The merged data sets are not permanent SAS data sets.

C - The RUN statement was omitted alter each or the SORT procedures.

D - The data sets were not merged in the order by which they were sorted.

 Contact Details :

K.Naveen SAS Trainer 
+91-9177856619 (INDIA) 
001-214-347-4655 (USA)
Knaveen.sas@gmail.com 
goodonlinetrainings@gmail.com  
For further details:
www.sasonlinetraining.training

Advance SAS CertifIcation Exam Question 10

Which program displays a listing of all data sets in the SASUSER library?

A - proc contents lib = sasuser.all; run;

B - proc contents data = sasuser.all; run;

C - proc contents lib = sasuser._alI_; run;

D - proc contents data = sasuser._all_; run;

 Contact Details :

K.Naveen SAS Trainer 
+91-9177856619 (INDIA) 
001-214-347-4655 (USA)
Knaveen.sas@gmail.com 
goodonlinetrainings@gmail.com  
For further details:
www.sasonlinetraining.training