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 has an index on the variable STATE.
Which describes the result of submitting the SAS program?
- A . The index on STATE is deleted and an index on ST is created
- B . The index on STATE is recreated as an index on ST
- C . The index on STATE is deleted
- D . The index on STATE is updated as an index on ST
The following SAS program is submitted:
%macro one (input);
%two;
%put the value is &date;
%mend;
%macro two;
data _null_;
call symput(‘date’,’12SEP2008′);
run;
%mend;
%let date=31DEC2006;
%one(&date)
What is the result when the %PUT statement executes?
- A . A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the ONE macro
- B . A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the TWO macro
- C . A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table
- D . A macro variable DATE with the value 31DEC2006 is retrieved from the global symbol table
Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?
- A . OBS=pointobs
- B . POINT=pointobs
- C . KEY=pointobs
- D . NOBS=pointobs
When reading a SAS data file, what does the NOBS=option on the SET statement represent?
- A . A variable that represents the total number of observation in the output data set(s)
- B . A variable that represents a flag indicating the end of the file
- C . A variable that represents the total number of observations in the input data set(s)
- D . A variable that represents the current observation number
CORRECT TEXT
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?
- A . result is
- B . result is 10
- C . result is 10.5
- D . result is 10+0.5
The following SAS program is submitted:
%micro test(var);
%let jobs=BLACKSMITH WORDSMITH SWORDSMITH;
%let type=%index(&jobs, &var);
%put type = &type;
%mend;
%test(SMITH)
What is the value of the macro variable TYPE when the %PUT statement executes?
- A . 0
- B . Null
- C . 6
- D . 3
The following SAS program is submitted:
%macro check(num=4);
%let result=%eval(&nm gt 5);
%put result is &result;
%mend;
%check (num=10)
What is written to the SAS log?
- A . result is true
- B . result is 10 gt 5
- C . result is 1
- D . result is 0
The following SAS program is submitted:
data temp;
length 1 b 3 x;
infile ‘file reference’;
input a b x;
run;
What is the result?
- A . The data set TEMP is not created because variables A and B have invalid lengths
- B . The data set TEMP is created, but variable X is not created
- C . The data set TEMP is not created because variable A has an invalid length
- D . The data set TEMP is created and variable X has a length of 8
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;
The following output is desired:
Which JOIN operator completes the program and generates the desired output?
- A . FULL JOIN
- B . INNER JOIN
- C . LEFT JOIN
- D . RIGHT JOIN
Given the SAS data set SAUSER.HIGWAY:
SASUSER.HIGHWAY
The following SAS program is submitted:
%macro highway;
proc sql nonprint;
%let numgrp=6;
select distinct status into: group1-: group&numgrp from sasuser.highway;
quit;
%do i=1 %to &numgrp;
proc print data =sasuser.highway;
where status ="&&group&I";
run;
%end;
%mend;
%highway
How many reports are produced?
- A . 2
- B . 6
- C . 0
- D . 5
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 option writes this message to the SAS log?
- A . %put the value is "&&&dept";
- B . %put the value is "&&&dept";
- C . %put the value is "&&&dept";
- D . %put the value is %quote (&&&dept);
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.tempdata;
Run;
What is the result of submitting the FORMAT procedure step?
- A . It uses the WORK.TEMPDATA SAS data set as input to create the format
- B . All formats created will be stored in two WORK.TEMPDATA SAS data set
- C . An ERROR message is written to the SAS log because the program is incomplete
- D . NO formats are created in this step
The following SAS program is submitted:
date view=sauser.ranch;
describe;
run;
What is the result?
- A . The program creates a DATA step view called SASUSER.RANCH and places the program cod in the current editor window
- B . The program retrieves the SAS source code that creates the view and places it in the output window
- C . The program creates a DATA step view called SASUSER.RANCH and places it in the SAS log
- D . the program retrieves the SAS source code that creates the view and places it in the SAS log
Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?
- A . DATASETS
- B . MODIFY
- C . FORMAT
- D . REGISTRY
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 divition;
If first.division then
Do;
%let mfirst=sales;
end;
run;
What is the value of the macro variable MFRIST when the program finishes execution?
- A . 1234
- B . sales
- C . 5678
- D . null
The following SAS program is submitted:
%let first=yourname;
%let last=first;
%put &&&last;
What is written to the SAS Log?
- A . First
- B . Yourname
- C . &&First
- D . &yourname
The following SAS program is submitted:
%let a=cat;
%macro animal(a=frog);
%let a=bird;
%mend;
%animal(a=pig)
%put a is &a;
What is written to the SAS log?
- A . a is pig
- B . a set cat
- C . a is frog
- D . a is bird
Which SQL procedure program deletes rows from the data set CLASS?
- A . proc sql;
Select * from class
Where age<(select stop_age from threshold);
Quit; - B . proc sql;
Modify table class
Delete where age<(select stop_age from threshold);
Quit - C . proc sql;
Delete from class
Where age<(select stop_age from threshold);
Quit; - D . proc sql;
Alter from class
Delete where age<(select stop_age from threshold);
Quit;
The following SAS program is submitted:
%let lib=%upcase(sauser); proc sql;
select nvar form dictionary.tables where libname=’&lib"; quit;
Several SAS data sets exist in the SAUSER library.
What is generated as output?
- A . A report showing the names of the columns in each table in SASUSER
- B . A report showing the number of columns in each table in SASUSER
- C . A report showing the numeric columns in each table in SASUSER
- D . A report showing the number of numeric columns in each table in SASUSER
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 SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
Which SAS system option displays the notes in the SAS log?
- A . SYMBOLGEN
- B . MLOGIC
- C . MACRO
- D . MPRINT
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?
- A . proc sql;
Create table combine as
Select coalesce (one.id, two.id) as id,
Name,salary from one, two where one.id=two.id;
Quit; - B . proc sql;
Create table combine as
Select one.id,
Name, salary from one full join two where one.id=two.id;
Quit - C . proc sql;
Create table combine as
Select one.id,name,salary from one inner join two on one.id=two.id
Quit - D . proc sql;
Create table combine as
Select coalesce (one id, two id) as id,
Name,salary from one full join two on one.id=two.id;
Quit;
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 TESTDATA.ONE?
- A . proc sql;
Contents table testdata.one;
Quit; - B . proc sql;
Describe table testdata.one;
Quit; - C . proc sql;
describe testdata.one;
Quit; - D . proc sql;
Contents testdata.one;
Quit;
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)?
- A . No variable are created in the PDV
- B . The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
- C . The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV
- D . The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the 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?
- A . proc sql;
Drop table one;
Quit; - B . proc sql;
Remove table one;
Quit; - C . proc sql;
Delete table one;
Quit; - D . proc sql;
Delete from one;
Quit;
The following SAS program is submitted:
%macro location;
data _null_;
call symput (‘dept’,’sales’);
run;
%let country=Germany;
%put_global_;
%mend;
%let company = ABC;
%location;
Which macro variables are written to the SAS log?
- A . COMPANY and DEPT only
- B . COMPANY, COUNTRY and DEPT
- C . COMPANY Only
- D . COMPANY and COUNTRY only
What is the purpose of the SASFILE statement?
- A . It requests that SAS data set be opened and loaded into SAS memory one page at a time
- B . It requests that a SAS data set the opened and loaded into SAS memory one variable at a time
- C . It requests that a SAS data set be opened and loaded into SAS memory one observation at a time
- D . It requests that a SAS data set be opened and loaded into SAS memory in its entirety
Given the SAS date sets CLASS1 and CLASS2
CLASS1 CLASS2
NAME COURSE NAME COURSE
Lauren MATH1 Smith MATH2
Patel MATH1 Farmer MATH2
Chang MATH1 Patel MATH2
Chang MATH3 Hiller MATH2
The following SAS program is submitted:
Proc sql;
Select name from CLASS1
<insert SQL set operator here>
select name from CLASS;
quit;
The following output is desired
NAME
Chang
Chang
Lauren
Which SQL set operator completes the program and generates the desired output?
- A . UNION ALL
- B . EXCEPT ALL
- C . INTERSECT ALL
- D . OUTER UNION ALL
The following SAS program is submitted:
data new (bufnp=4);
set old(bufno=4);
run;
Why are the BUFNO options used?
- A . To reduce the number I/O operations
- B . To reduce network traffic
- C . To reduce memory usage
- D . To reduce the amount of data read
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 option?
- A . It tracks and recycles free space
- B . It allows a permanently stored SAS data set to be replaced
- C . It allows users to access the same SAS data set concurrently
- D . It allows updates in place
The SAS data set ONE contains fifty million observations and contains the variable PRICE, QUANTITY, FIXED and VARIABLE.
Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?
- A . data two;
Set one;
Where totrev>1000;
Totrev=sum(price*quantity);
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run; - B . data two;
Set one;
totrev=sum(price*quantity);
where totrev>1000;
totcost=sum(fixed,variable);
profit=sum(totrev,-totcost);
run; - C . data two;
Set one;
Totrev=sum(price*quantity);
If totrev>1000;
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run; - D . data two;
Set one;
Totrev = sum(price*quantity);
Totcost= sum(fixed,variable);
If totrev>1000;
Profit=sum(totrev,-totcost);
Run;
The following SAS program is submitted:
data temp;
set sasuser.history(kep=date);
format date qtr
<insert BY statement here>
if first.date then total=0;
total+1;
if last.date;
run;
proc print data=temp;
run
SASUSER.HISTORY is sorted by the SAS date variable DATE.
The following output is required:
Date Total
1 13
3 15
4 25
Which By statement completes the data step and successfully generates the required output?
- A . by groupformat date;
- B . by formateed date;
- C . by notsorted date;
- D . by date qtr
Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?
- A . MODIFY and CHANGE statements
- B . RENAME statement only
- C . CHANGE statement only
- D . MODIFY and RENAME statements
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 completes the program and generates the desired output?
- A . Select salary, salary*.10 var=BONUS
- B . Select salary, salary*.10 label=’BONUS’
- C . Select salary, salary *.10 column=’BONUS’
- D . Select salary, salary*.10 name=’BONUS’
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 BY statement completes the program, creates a listing report that is grouped by X and completes without errors?
- A . By X notsorted;
- B . By X grouped;
- C . By Descending X;
- D . By X;
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 data =sashelp.class;
<insert Where statement here>
run;
Which WHERE statement successfully completes the program and produces a report?
- A . Where upcase(name)="upcase(&value)";
- B . Where upcase(name)="%upcase(&value)";
- C . Where upcase(name)=upcase(&value);
- D . Where upcase(name)=%upcase(&value);
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 variable X.
Which option specifies how the data in the SAS data set TEMP will be sorted?
- A . ORDEREDBY=X
- B . GROUPBY=X
- C . SORTEDBY=X
- D . SORTSYNC=X
Given the following partial SAS log:
NOTE: SQL table SASHELP.CLASS was created line
Create table SASHELP.CLASS(bufsize=4096)
(
Name char(8);
Gender Char(1);
Age num;
Height num;
Weight num
);
Which SQL procedure statement generated this output?
- A . DESCRIBE TABLE
- B . LIST TABLE
- C . VALIDATE TABLE
- D . CREATE TABLE
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?
- A . It has no effect in this example
- B . It writes the original program code inside the marco definition to the SAS log
- C . It writes macro execution messages to the SAS.log
- D . It echoes the text sent to the SAS compiler as a result of macro execution in the SAS log
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) as AVERAGE
From one
Group by rep
<insert SQL procedure clause here>
quit;
The following output is desired:
Which SQL procedure clause completes the program and generates the desired output?
- A . having avg(cost) < select avg(cost) from one);
- B . Having avg(cost)>(select avg(cost) from one);
- C . Where avg(cost)>(select avg(cost) from one);
- D . Where calculated average > (select avg(cost) from one);
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 data = sashelp.class;
<insert WHERE statement here>
run;
Which WHERE statement successfully completes the program and procedures a report?
- A . Where upcase(name)=%upcase(&value);
- B . Where upcase(name)="upcase(&value)";
- C . Where upcase(name)=upcase(&value);
- D . Where upcase(name)="%upcase(&value)";
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 following output is desired:
SALARY
200
205
523
Which WHERE expression completes the program and generates the desired output?
- A . Where salary is not
- B . Where salary ne null
- C . Where salary is not missing
- D . Where salary ne missing
At the start of a new SAS session; the following program is submitted:
%macro one;
data _null_;
call symput(‘proc’,’measn);
run;
proc &proc data=sashelp.class;
run;
%mend;
%one()
What is the result?
- A . The marco variable PRCO is stored in the SAS catalog WORK.SASMACR
- B . The program fails to execute because PROC is a reserved word
- C . The macro variable PROC is stored in the local symbol table
- D . The macro variable PROC is stored in the global symbol table
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?
- A . null
- B . 2
- C . 1
- D . 1.8
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 by statement completes the program, create a listing report that is grouped by X and completes without errors?
- A . X;
- B . By X groupd;
- C . By X notsorted;
- D . By descending X;
Which of the following is true about the COMPRESS=YES data set option?
- A . It is most effective with numeric data that represents large numeric values
- B . It is most effective with character data that contains patterns, rather than simple repetitions
- C . It uses the Ross Data Compression method to compress numeric data
- D . It is most effective with character data that contains repeated characters
The following SAS program is submitted:
data new;
do i=1,2,3
nextfile=compress(‘March’ || |);
infile abc filevar=nextfile
end=eof;
do until (eof);
input dept $sales;
end;
run;
What is the purpose of the FILEVAR=option on the INFILE statement?
- A . It names the variable NEXTFILE, whose value is output to the SAS data set NEW
- B . It names the variable NEXTFILE, whose values point to an aggregate storage location
- C . It names the variable NEXTFILE, whose value is a SAS file reference
- D . It names the variable NEXTFILE, whose change in value causes in INFILE statement to open a new input file
The following SAS program is submitted:
%micro cols1;
name age;
%mend;
%macro cols2;
height weight
%mend
proc print data=sashelp.class;
<insert VAR statement here>
Run
Which VAR statement successfully completes the program and produces a report?
- A . var heigh %cols1;
- B . var %cols1 %cols2 height;
- C . var %cols1 height;
- D . var %cols2 %cols1;
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?
- A . BUFSIZE=specifies the size of the output buffer in kilobytes; BUFNO=specifies the number of output buffers
- B . BUFSIZE= specifies the size of the input buffer in bytes; BUFFNO= specifies the number of input buffers
- C . BUFSIZE= specifies the size of the input buffer in kilobytes; BUFNO=specifies the number of input buffers
- D . BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers
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 names of all of the columns created by the TRANSPOSE procedure?
- A . new, X, Y and _COL1_
- B . new, X and COL1 only
- C . new, Y and COL1 only
- D . new, X and Y only
Which SAS integrity constraint type ensures that a specific set or range of values are the only values in a variable?
- A . CHECK
- B . NOT NULL
- C . PRIMARY KEY
- D . UNIQUE
The following SAS program is submitted:
%let test=one;
%let one=two;
%let two=three;
%let three=last;
%put what displays is &&&&&test;
What is the written to the SAS log?
- A . What displays is three
- B . What displays is two
- C . What displays is one
- D . What displays is last
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)?
- A . The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
- B . No variables are created in the PDV
- C . The variables named POINTS1, POINTS2, POINTS4, POINTS5, POINTS6 are created in the PDV
- D . The variables named POINTS11, POINTS12, POINTS13, POINTS21, POINTS22, POINTS23 are created in the PDV
Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?
- A . DICTIONARY.COLUMNS
- B . DICTIONARY.VARIABLES
- C . DICTIONARY.MEMBERS
- D . DICTIONARY.TABLES
What is generated as a result of submitting the RANUNI function with a seed of 123?
- A . A missing value because 123 is an invalid argument for the RANUNI function
- B . A different sequence of random numbers with each program execution
- C . A random number between 0 and 123
- D . A consistent sequence of random numbers with each program execution
What is an advantage of using a hash object in a SAS DATA step?
- A . The hash object persists after the DATA step has executed
- B . The hash object key values can be multiple numeric and character data values
- C . The hash object automatically sorts the data
- D . The hash object does not require unique keys
Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?
- A . RENAME statement only
- B . CHANGE statement only
- C . MODIFY and RENAME statements
- D . MODIFY and CHANGE statements
The following SAS program is submitted:
<insert statement here>;
%let development = ontime;
proc print data = sasuser.highway;
title "For &dept";
title2 "This project was completed &development";
run;
Which one of the following statements completes the above and resolves title1 to "For research&development"?
- A . %let dept = %str(research&development);
- B . %let dept = %str(research%&development);
- C . %let dept = %nrstr(research&development);
- D . %let dept = %nrstr(research%&development);
Which one of the following options controls the pagesize of a SAS data set?
- A . SIZE=
- B . BUFNO=
- C . BUFSIZE=
- D . PAGESIZE=
Given the following SAS data set ONE:
ONE
REP COST
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
JONES 200
JONES 400
SMITH 800
JONES 100
JONES 300
The following SAS program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE
from one
group by rep
having avg(cost) > (select avg(cost) from one);
quit;
Which one of the following reports is generated?
- A . REP AVERAGE JONES 200
- B . REP AVERAGE JONES 320
- C . REP AVERAGE SMITH 320
- D . REP AVERAGE SMITH 500
The following SAS program is submitted:
proc sort data = sales tagsort;
by month year;
run;
Which of the following resource(s) is the TAGSORT option reducing?
- A . I/O usage only
- B . CPU usage only
- C . I/O and CPU usage
- D . temporary disk usage
The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;
The SAS data set TEMP contains 2,500,000 observations.
Which one of the following represents the possible values for PTOBS?
- A . any integer between 1 and 10
- B . any real number between 0 and 1
- C . any integer between 1 and 2,500,000
- D . any real number between 1 and 2,500,000
Which one of the following programs contains a syntax error?
- A . proc sql;
select product.*, cost.unitcost, sales.quantity
from product p, cost c, sales s
where p.item = c.item and
p.item = s.item;
quit; - B . proc sql;
select product.*, cost.unitcost, sales.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit; - C . proc sql;
select p.*, c.unitcost, s.quantity
from product as p, cost as c, sales as s
where p.item = c.item and
p.item = s.item;
quit; - D . proc sql;
select p.*, c.unitcost, s.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;
The following SAS code is submitted:
%macro houses(dsn = houses,sub = RANCH);
data &dsn;
set sasuser.houses;
if style = "¬";
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)
Which one of the following is the value of the automatic macro variable SYSLAST?
- A . work.ranch
- B . work.houses
- C . WORK.RANCH
- D . WORK.HOUSES
Given the following SAS data sets ONE and TWO:
ONE TWO
NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
The following SAS program is submitted:
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;
Which one of the following reports is generated?
- A . COUNTRY
GERMANY
JAPAN - B . COUNTRY
FRANCE
BELGIUM - C . COUNTRY
CANADA
FRANCE
BELGIUM - D . COUNTRY
CANADA
FRANCE
GERMANY
Which one of the following statements is true?
- A . The WHERE statement can be executed conditionally as part of an IF statement.
- B . The WHERE statement selects observations before they are brought into the PDV.
- C . The subsetting IF statement works on observations before they are read into the PDV.
- D . The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.
The variable attributes of SAS data sets ONE and TWO are shown below:
ONE TWO
# Variable Type Len Pos # Variable Type Len Pos
2 sales Num 8 8 2 budget Num 8 8
1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0
Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.
The following SAS program is submitted:
data three;
merge one two;
by year;
run;
Which one of the following is the result of the program execution?
- A . No messages are written to the SAS log.
- B . ERROR and WARNING messages are written to the SAS log.
- C . Data set THREE is created with two variables and 50 observations.
- D . Data set THREE is created with three variables and 100 observations.
Given the following SAS statement:
%let idcode = Prod567;
Which one of the following statements stores the value 567 in the macro variable CODENUM?
- A . %let codenum = substr(&idcode,length(&idcode)-2);
- B . %let codenum = substr(&idcode,length(&idcode)-3);
- C . %let codenum = %substr(&idcode,%length(&idcode)-2);
- D . %let codenum = %substr(&idcode,%length(&idcode)-3);
The following SAS program is submitted:
data new (bufsize = 6144 bufno = 4);
set old;
run;
Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?
- A . BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.
- B . BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.
- C . BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.
- D . BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.
Consider the following SAS log:
229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;
230 set sasuser.houses;
231 if style = ‘RANCH’ then output sasuser.ranch;
232 else if style = ‘CONDO’ then output sasuser.condo;
233 run;
NOTE: DATA STEP view saved on file SASUSER.RANCH.
NOTE: A stored DATA STEP view cannot run under a different operating system.
234
235 proc print data = sasuser.condo;
ERROR: File SASUSER.CONDO.DATA does not exist.
236 run;
NOTE: The SAS System stopped processing this step because of errors.
Which one of the following explains why the PRINT procedure fails?
- A . SASUSER.CONDO is a stored DATA step program.
- B . A SAS data file and SAS data view cannot be created in the same DATA step.
- C . A second VIEW=SASUSER.CONDO option was omitted on the DATA statement.
- D . The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.
Which one of the following is an advantage of creating and using a SAS DATA step view?
- A . It can store an index.
- B . It always accesses the most current data.
- C . It works quickly through multiple passes of the data.
- D . It is useful when the underlying data file structure changes.
Given the following 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
2002 1 700
The following SAS program is submitted:
proc sql;
select one.*, sales
from one, two;
quit;
Which one of the following reports is generated?
- A . YEAR QTR BUDGET SALES 2001 4 400 300 2002 1 700 600
- B . YEAR QTR BUDGET SALES 2001 3 500 2001 4 400 300 2002 1 700 600
- C . YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600
- D . YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600
Given the following SAS data set ONE:
ONE
NUM VAR
1 A
2 B
3 C
Which one of the following SQL programs deletes the SAS data set ONE?
- A . proc sql; delete table one; quit;
- B . proc sql; alter table one drop num, var; quit;
- C . proc sql; drop table one; quit;
- D . proc sql; delete from one; quit;
The SAS data set TEMP has the following distribution of values for variable A:
A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?
- A . data new;
set temp;
if a = 8 then
b = ‘Small ‘;
else if a in(1, 2) then
b = ‘Medium’;
else if a = 6 then
b = ‘Large’;
run; - B . data new;
set temp;
if a in (1, 2) then
b = ‘Medium’;
else if a = 8 then
b = ‘Small’;
else if a = 6 then
b = ‘Large’;
run; - C . data new;
set temp;
if a = 6 then
b = ‘Large ‘;
else if a in (1, 2) then
b = ‘Medium’;
else if a = 8 then
b = ‘Small’; - D . data new;
set temp;
if a = 6 then
b = ‘Large ‘;
if a in (1, 2) then
b = ‘Small’;
run;