A00-212 Exam Questions

The following SAS program is submitted: data sasuser.history; set sasuser.history(keep = State x y rename = (State = St)); total = sum(x, y); run; The SAS data set SASUSER.HISTORY...

The following SAS program is submitted: %macro one(input); %two %mend; %macro two; data _null_; call symputx('date', '12SEP2008', 'G'); run; %put the value is &date; %mend; %let da...

Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?

When reading a SAS data file, what does the NOBS=option on the SET statement represent?

The following SAS program is submitted: %macro check(num = 4); %let result = %eval(&num gt 5); %put result is &result; %mend; %check(num = 10) What is the written to the SAS log?

The following SAS program is submitted: %macro check(num = 4); %let result = %eval(&num gt 5); %put result is &result; %mend; %check(num = 10) What is written to the SAS log?

Given the SAS data sets ONE and TWO: The following SAS program is submitted: proc sql; select two.*, budget from one <insert JOIN operator here> two on one.year = two.year; quit; T...

Given the SAS data set SAUSER.HIGWAY: SASUSER.HIGHWAY STEERING SEATBELT SPEED STATUS COUNT ------- ----------- -------- ----------- ------- absent No 0-29 serious 31 absent No 0-29...

The following SAS program is submitted: %let dept = prod; %let prod = merchandise; The following message is written to the SAS log: the value is "merchandise" Which SAS System opti...

The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and LABEL and it consists of 10 observations. The following SAS program is submitted: Proc format cntlin=wor.te...

The following SAS program is submitted: data view = sasuser.ranch; describe; run; What is the result?

Which SET statement option names a variable that contains the number of the observation to read during the current iteration of the DATA step?

The following SAS program is submitted: %macro check(num = 4); %let result = %sysevalf(&num + 0.5); %put result is &result; %mend; %check(num=10) What is the written to the SAS log...

Given the SAS data set ONE: ONE DIVISION SALES ----------- ---------- A 1234 A 3654 B 5678 The following SAS program is submitted: data _null_; set one; by division; if first.divis...

Which SQL procedure program deletes rows from the data set CLASS?

The following SAS program is submitted: %let lib = %upcase(sasuser); proc sql; select nvar from dictionary.tables where libname = "&lib"; quit; Several SAS data sets exist in the S...

The following SAS program is submitted: %macro loop; data one; %do I = 1 %to 3; var&I = &i; % end; run; %mend; %loop After this program executes; the following is written to the SA...

Given the SAS data sets ONE and TWO: The following SAS program is submitted: data combine; merge one two; by id; run; Which SQL procedure program procedures the same results?

The following SAS program is submitted: proc contents data = testdata.one; run; Which SQL procedure program produces similar information about the column attributes of the dataset...

The following SAS program is submitted: data temp; array points{2,3} (10, 15, 20, 25, 30, 35); run; What impact does the ARRAY statement have in the Program Data Vector(PDV)?

Given the SAS data set ONE: ONE NUM VAR ------ ----- 1 A 2 B 3 C Which SQL procedure program deletes the data set ONE?

What is the purpose of the SASFILE statement?

Given the SAS date sets CLASS1 and CLASS2: CLASS1 CLASS2 NAME COURSE NAME COURSE ------- ----------- ------- ------------ Lauren MATH1 Smith MATH2 Patel MATH1 Farmer MATH2 Chang MA...

The following SAS program is submitted: data new (bufno = 4); set old(bufno = 4); run; Why are the BUFNO options used?

The following SAS program is submitted: options reuse = YES; data sasuser.RealEstate(compress = CHAR); set sasuser.houses; run; What is the effect of the REUSE=YES SAS system optio...

Given the SAS data sets ONE and TWO: ONE TWO YEAR QTR BUDGET YEAR QTR SALES ------- ------- ----------- ------- ----- -------- 2001 3 500 2001 4 300 2001 4 400 2002 1 600 2003 1 35...

The SAS data set ONE contains fifty million observations and contains the variables PRICE, QUANTITY, FIXED, and VARIABLE. Which SAS program successfully creates three new variables...

The following SAS program is submitted: data temp; set sasuser.history(keep = date); format date qtr.; <insert BY statement here> if first.date then total = 0; total + 1; if last.d...

Given has SAS dataset ONE: The following SAS program is submitted: proc sql; <insert SQL clause here> from one; quit; The following output is desired: Which SQL procedure clause co...

The SAS data set WORK.TEMPDATA contains the variable FMTNAME, START and LABEL and it consists of 10 observations. The following SAS program is submitted: proc format cntlin = work....

Given the non-indexed SAS data set TEMP: TEMP X Y -- -- P 52 P 45 A 13 A 56 R 34 R 12 R 78 The following SAS program is submitted: proc print data = temp; <insert BY statement here...

Given the data set SASHELP.CLASS SASHELP.CLASS NAME AGE ------- ------ Mary 15 Philip 16 Robert 12 Ronald 15 The following SAS program is submitted: %let value = Philip; proc print...

Following SAS program is submitted: data temp(<insert option here>); infile 'rawdata'; input x $ y z; run; RAWDATA is a file reference to an external file that is ordered by the va...

Given the following partial SAS log: NOTE: SQL table SASHELP.CLASS was created like: create table SASHELP.CLASS( bufsize=4096 ) ( Name char(8), Gender char(1), Age num, Height num,...

The following SAS program is submitted: options mprint; %macro test(parm); proc &parm data = sashelp.prdsale; run; %mend; %test(print) What is the result of the MPRINT options?

Given the SAS data set ONE: ONE REP COST -------- ------- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 The following SAS program is submitted: proc sql; select rep, avg(cost)...

Given the data set SASHELP.CLASS: SASHELP.CLASS NAME AGE ------- ------ Mary 15 Philip 16 Robert 12 Ronald 15 The following SAS program is submitted: %let value = Philip; proc prin...

Given the SAS dataset ONE ONE SALARY ----------- 200 205 . 523 The following SAS program is submitted proc sql; select * from one <insert WHERE expression here>; quit; The followin...

The following SAS program is submitted: %let var = chicago, 1; data a; var = 'new york, 2'; newvar = %scan(&var,2,%str()); run; Which one of the following explains why the program...

At the start of a new SAS session; the following program is submitted: %macro one; data _null_; call symput('proc', 'means'); run; proc &proc data = sashelp.class; run; %mend; %one...

The following SAS program is submitted: %let value=9; %let add=5; %let newval=%eval(&value/&add); What is the value of the macro variable NEWVAL?

Given the non-indexed SAS data set TEMP: TEMP X Y P 52 P 45 A 13 A 56 R 34 R 12 R 78 The following SAS program is submitted: proc print data = temp; <insert BY statement here> run;...

Which of the following is true about the COMPRESS=YES data set option?

The following SAS program is submitted: data new; do I = 1, 2, 3; nextfile = compress('March' || I ); infile abc filevar = nextfile end = eof; do until (eof); input dept $ sales; e...

The following SAS program is submitted: %macro cols1; name age; %mend; %macro cols2; height weight; %mend; proc print data = sashelp.class; <insert VAR statement here> run; Which V...

The following SAS program is submitted: data new(bufsize = 6144 bufno = 4); set old; run; What is the difference between the usage of BUFFSIZE= and BUFNO= options?

The SAS data set ONE contains the variables X,Y,Z and W. The following SAS program is submitted: proc transpose data = one out = trans name = new; by x; var y; run; What are the na...

The following SAS program is submitted: data view=sasuser ranch; describe; run; What is the result?

The following SAS program is submitted: data temp; length a 1 b 3 x; infile 'file reference'; input a b x; run; What is the result?

Which SAS integrity constraint type ensures that a specific set or range of values are the only values in a variable?