QUESTION NO: 1
data work.new;
mon = 3;
day = 23;
year = 2000;
date = mdy(mon,day,year);
run;
data work.new;
mon = 3;
day = 23;
year = 2000;
date = mdy(mon,day,year);
run;
Correct Answer: A
Vote an answer
QUESTION NO: 2
2 data gt100;
3 set ia.airplanes
4 if mpg gt 100 then output;
22 202
ERROR: File WORK.IF.DATA does not exist.
ERROR: File WORK.MPG.DATA does not exist.
ERROR: File WORK.GT.DATA does not exist.
ERROR: File WORK.THEN.DATA does not exist.
ERROR: File WORK.OUTPUT.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name,
a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
5 run;
2 data gt100;
3 set ia.airplanes
4 if mpg gt 100 then output;
22 202
ERROR: File WORK.IF.DATA does not exist.
ERROR: File WORK.MPG.DATA does not exist.
ERROR: File WORK.GT.DATA does not exist.
ERROR: File WORK.THEN.DATA does not exist.
ERROR: File WORK.OUTPUT.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name,
a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
5 run;
Correct Answer: B
Vote an answer
QUESTION NO: 3
data work.test;
Author = 'Christie, Agatha';
First = substr(scan(author,2,' ,'),1,1);
run;
data work.test;
Author = 'Christie, Agatha';
First = substr(scan(author,2,' ,'),1,1);
run;
Correct Answer: C
Vote an answer
QUESTION NO: 4
--------10-------20-------30
01012000
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
run;
--------10-------20-------30
01012000
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
run;
Correct Answer: D
Vote an answer
QUESTION NO: 6
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Correct Answer: D
Vote an answer
QUESTION NO: 7
data test;
infile 'file specification';
input name $ amount@@;
run;
data test;
infile 'file specification';
input name $ amount@@;
run;
Correct Answer: A
Vote an answer
QUESTION NO: 9
SASDATA TWO XY
52
31
56
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
SASDATA TWO XY
52
31
56
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
Correct Answer: D
Vote an answer
QUESTION NO: 10
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;
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;
Correct Answer: D
Vote an answer
QUESTION NO: 11
proc contents data = sashelp.class varnum; quit;
proc contents data = sashelp.class varnum; quit;
Correct Answer: D
Vote an answer
QUESTION NO: 12
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Correct Answer: C
Vote an answer