SAS advance 63

Por favor espera - en proceso…

Pregunta 1 de 103

1. When attempting to minimize memory usage, the most efficient way to do group processing when using the MEANS procedure is to use:

Selecciona una de las siguientes respuestas posibles:

A. the BY statement.
B. GROUPBY with the NOTSORTED specification.
C. the CLASS statement.
D. multiple WHERE statements.

Explicación

Pregunta 2 de 103

2. The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

Selecciona una de las siguientes respuestas posibles:

A. create index Id_Code on WORK.CHECK;
B. create index(Id_Code) on WORK.CHECK;
C. make index=Id_Code from WORK.CHECK;
D. define index(Id_Code) in WORK.CHECK;

Explicación

Pregunta 3 de 103

3. Given the SAS data sets:

What would allow the program to successfully execute without errors?

Selecciona una de las siguientes respuestas posibles:

A. Replace the where clause with:
where EMPLOYEE.Name=(select Names delimited with ','
from WORK.NEWEMPLOYEE
where Salary > 40000);
B. Replace line 104 with:
where EMPLOYEE.Name =ANY (select Names separated with ','
from WORK.NEWEMPLOYEE
where Salary > 40000);
C. Replace the equal sign with the IN operator.
D. Qualify the column names with the table names.

Explicación

Pregunta 4 de 103

4. Given the SAS data set SASUSER.HIGHWAY:

Which SQL clause stores the text 0-29, 30-49, 50+ in the macro variable GROUPS?

Selecciona una de las siguientes respuestas posibles:

A. into &GROUPS
B. into :GROUPS
C. into :GROUPS separated by ','
D. into &GROUPS separated by ','

Explicación

Pregunta 5 de 103

5. The SAS data set WORK.CHECK has an index on the variable Code and the following SAS program is submitted.
proc sort data=WORK.CHECK;
by Code;
run;

Which describes the result of submitting the SAS program?

Selecciona una de las siguientes respuestas posibles:

A. The index on Code is deleted.
B. The index on Code is updated.
C. The index on Code is uneffected.
D. The sort does not execute.

Explicación

Pregunta 6 de 103

6. The table WORK.PILOTS contains the following data:

Which SQL statement could NOT generate this result?

Selecciona una de las siguientes respuestas posibles:

A. select
Jobcode,
Salary,
avg(Salary) label='Avg'
from WORK.PILOTS group by Jobcode
order by Id
;
B. select
Jobcode,
Salary,
(select avg(Salary)
from WORK.PILOTS as P1
where P1.Jobcode=P2.Jobcode) as Avg
from WORK.PILOTS as P2
order by Id
;
C. select
Jobcode,
Salary,
(select avg(Salary)
from WORK.PILOTS
group by Jobcode) as Avg
from WORK.PILOTS
order by Id
;
D. select
Jobcode,
Salary,
Avg
from
WORK.PILOTS,
(select
Jobcode as Jc,
avg(Salary) as Avg
from WORK.PILOTS
group by 1)
where Jobcode=Jc
order by Id
;
(define variable Avg in subquery in from clause.)

Explicación

Pregunta 7 de 103

7. A quick rule of thumb for the space required to run PROC SORT is:

Selecciona una de las siguientes respuestas posibles:

A. two times the size of the SAS data set being sorted.
B. three times the size of the SAS data set being sorted.
C. four times the size of the SAS data set being sorted.
D. five times the size of the SAS data set being sorted.

Explicación

Pregunta 8 de 103

8. Multi-threaded processing for PROC SORT will affect which of these system resources?

Selecciona una de las siguientes respuestas posibles:

A. CPU time will decrease, wall clock time will decrease
B. CPU time will increase, wall clock time will decrease
C. CPU time will decrease, wall clock time will increase
D. CPU time will increase, wall clock time will increase

Explicación

Pregunta 9 de 103

9. Given the SAS data set WORK.TRANSACT:

Which SQL statement was used?

Selecciona una de las siguientes respuestas posibles:

A. select
rep,
min(Cost+Ship)
from WORK.TRANSACT
order by Rep
;
select
Rep,
min(Cost,Ship) as Min
from WORK.TRANSACT
summary by Rep
order by Rep
;
C.
select
Rep,
min(Cost,Ship)
from WORK.TRANSACT
group by Rep
order by Rep
;
D.
select
Rep,
min(Cost+Ship)
from WORK.TRANSACT
group by Rep
order by Rep
;

Explicación

Pregunta 10 de 103

10. (%EVAL) The following SAS program is submitted:
%let Value=9;
%let Add=5;
%let Newval=%eval(&Value/&Add); %put &Newval;

What is the value of the macro variable Newval when the %PUT statement executes?

Selecciona una de las siguientes respuestas posibles:

A. 0.555
B. 2
C. 1.8
D. 1

Explicación

Pregunta 11 de 103

11. The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
infile RAWDATA;
input Xa Xb Xc;
if Xa=. then output WORK.ERRORS;
else output WORK.TEMP;
run;

Which of the following is true of the WORK.ERRORS data set?

Selecciona una de las siguientes respuestas posibles:

A. The data set is created when the DATA step is submitted.
B. The data set is created when the view TEMP is used in another SAS step.
C. The data set is not created because the DATA statement contains a syntax error.
D. The descriptor portion of WORK.ERRORS is created when the DATA step is submitted.

Explicación

Pregunta 12 de 103

12. Which title statement would always display the current date?

Selecciona una de las siguientes respuestas posibles:

A. title "Today is: &sysdate.";
B. title "Today is: &sysdate9.";
C. title "Today is: &today.";
D. title "Today is: %sysfunc(today(),worddate.)";

Explicación

Pregunta 13 de 103

13. Given the SAS data sets:

Which SQL procedure statement produces the same results?

Selecciona una de las siguientes respuestas posibles:

A.
create table WORK.COMBINE as
select Id,
Name,
Salary from
WORK.ONE
full join
WORK.TWO
on ONE.Id=TWO.Id
;
B.
create table WORK.COMBINE as
select
coalesce(ONE.Id, TWO.Id) as Id,
Name,
Salary
from
WORK.ONE,
WORK.TWO
where ONE.Id=TWO.Id
;
C.
create table WORK.COMBINE as
select
coalesce(ONE.Id, TWO.Id) as Id,
Name,
Salary
from
WORK.ONE
full join
WORK.TWO
on ONE.Id=TWO.Id
order by Id
;
D.
create table WORK.COMBINE as
select
coalesce(ONE.Id, TWO.Id) as Id,
Name,
Salary
from
WORK.ONE,
WORK.TWO
where ONE.Id=TWO.Id
order by ONE.Id
;

Explicación

Pregunta 14 de 103

14. The following SAS program is submitted:
proc contents data=TESTDATA.ONE;
run;

Which SQL procedure step produces similar information about the column attributes of TESTDATA.ONE?

Selecciona una de las siguientes respuestas posibles:

A. proc sql;
contents from TESTDATA.ONE;
quit;
B. proc sql;
describe from TESTDATA.ONE;
quit;
C. proc sql;
contents table TESTDATA.ONE;
quit;
D. proc sql;
describe table TESTDATA.ONE;

Explicación

Pregunta 15 de 103

15. Given the SAS data set WORK.ONE:

Which result set would be generated?

Selecciona una de las siguientes respuestas posibles:

A. JONES 280
JONES 280
SMITH 280
SMITH 280
SMITH 280
B.
JONES 600
SMITH 100
C.
JONES 280
SMITH 280
D.
JONES 100
JONES 100
SMITH 600
SMITH 600
SMITH 600

Explicación

Pregunta 16 de 103

16. Given the SAS data sets:

The following output is desired:

Name Fi
------- --
Lauren L
Patel A
Chang Z
Hillier R
Smith M
Lauren L
Patel A

Which SQL set operator completes the program and generates the desired output?

Selecciona una de las siguientes respuestas posibles:

A. append corr
B. union corr
C. outer union corr
D. intersect corr

Explicación

Pregunta 17 de 103

17. Which of the following is an advantage of SAS views?

Selecciona una de las siguientes respuestas posibles:

A.
SAS views can access the most current
data in files that are frequently updated.
B.
SAS views can avoid storing a SAS copy of
a large data file.
C.
SAS views can decrease programming time.
D.
both A and B are true

Explicación

Pregunta 18 de 103

18. In what order does SAS search for format definitions by default?

Selecciona una de las siguientes respuestas posibles:

A. 1. WORK.FORMATS 2. LIBRARY.FORMATS
B. 1. LIBRARY.FORMATS 2. WORK.FORMATS
C. There is no default order, it must be defined by the user.
D. All user defined libraries that have a catalog named FORMATS, in alphabetic order.

Explicación

Pregunta 19 de 103

19. Function %UPCASE:

Which WHERE statement successfully completes the program and produces a report?

Selecciona una de las siguientes respuestas posibles:

A. where upcase(Name)=upcase(&Value);
B. where upcase(Name)=%upcase(&Value);
C. where upcase(Name)="upcase(&Value)";
D. where upcase(Name)="%upcase(&Value)";

Explicación

Pregunta 20 de 103

20. The following SAS program is submitted:
data WORK.TEMP;
length A B 3 X;
infile RAWDATA;
input A B X;
run;

What is the length of variable A?

Selecciona una de las siguientes respuestas posibles:

A. 3
B. 8
C. WORK.TEMP is not created - X has an invalid length.
D. Unknown.

Explicación

Pregunta 21 de 103

21. The following SAS program is submitted:

The purpose of the FILEVAR=option on the INFILE statement is to name the variable Next, whose value:

Selecciona una de las siguientes respuestas posibles:

A. points to a new input file.
B. is output to the SAS data set WORK.NEW.
C. is an input SAS data set reference.
D. points to an aggregate storage location.

Explicación

Pregunta 22 de 103

22. DESCRIBE TABLE Statement
Given the following partial SAS log:
NOTE: SQL table SASHELP.CLASS was created like:
create table SASHELP.CLASS( bufsize=4096 )
(
Name char(8),
Sex char(1),
Age num,
Height num,
Weight num
);

Which SQL procedure statement generated this output?

Selecciona una de las siguientes respuestas posibles:

A. CONTENTS FROM SASHELP.CLASS;
B. CREATE FROM SASHELP.CLASS INTO LOG;
C. DESCRIBE TABLE SASHELP.CLASS;
D. VALIDATE SELECT * FROM SASHELP.CLASS;

Explicación

Pregunta 23 de 103

23. Given the SAS data set SASUSER.HIGHWAY:

What macro variable reference completes the program to create the WORK.NOT and
WORK.SERIOUS data sets?

Selecciona una de las siguientes respuestas posibles:

A. &Status&i
B. &&Status&i
C. &Status&Count
D. &&Status&Count

Explicación

Pregunta 24 de 103

24. The following SAS program is submitted:
%let Num1=7;
%let Num2=3;
%let Result=%eval(&Num1/&Num2);
%put &Result;

What is the value of the macro variable Result when the %PUT statement executes?

Selecciona una de las siguientes respuestas posibles:

A. 2.3
B. 2
C. . (missing value)
D. 2.33333333333333

Explicación

Pregunta 25 de 103

25. Macros That Include Keyword Parameters:
Given the SAS data set SASUSER.HIGHWAY:

How many observations appear in the generated report?

Selecciona una de las siguientes respuestas posibles:

A. 0
B. 2
C. 3
D. 5

Explicación

Pregunta 26 de 103

26. Given the following SAS data sets:

Which of the following SQL statements was most likely used to generate this result?

Selecciona una de las siguientes respuestas posibles:

A.
select
Id,
sum(Expense) label='COST'
from WORK.VISIT1
group by 1
union all
select
Id,
sum(Cost)
from WORK.VISIT2
group by 1
order by 1,2
;
B. select
id,
sum(expense) as COST
from
WORK.VISIT1(rename=(Expense=Cost)),
WORK.VISIT2
where VISIT1.Id=VISIT2.Id
group by Id
order by
Id,
Cost ;
C. select
VISIT1.Id,
sum(Cost) as Cost
from
WORK.VISIT1(rename=(Expense=Cost)),
WORK.VISIT2
where VISIT1.Id=VISIT2.Id
group by Id
order by
Id,
Cost ;
D. select
Id,
sum(Expense) as Cost
from WORK.VISIT1
group by Id
outer union corr
select
Id,
sum(Cost)
from WORK.VISIT2
group by Id
order by 1,2
;

Explicación

Pregunta 27 de 103

27. Given the SAS data sets:

What data values are stored in data set WORK.COMBINE?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 28 de 103

28. Which of the following ARRAY statements is similar to the statement array Yr{1974:2007} Yr1974-Yr2007; and will compile without errors?

Selecciona una de las siguientes respuestas posibles:

A. array Yr{34} Yr1974-Yr2007;
B. array Yr{74:07} Yr1974-Yr2007;
C. array Yr{74-07} Yr1974-Yr2007;
D. array Yr{1974-2007} Yr1974-Yr2007;

Explicación

Pregunta 29 de 103

29. The following program is submitted to check the variables Xa, Xb, and Xc in the SASUSER.LOOK data set:

data _null_ WORK.BAD_DATA / view=WORK.BAD_DATA ;
set SASUSER.LOOK(keep=Xa Xb Xc);
length _Check_ $ 10 ;
if Xa=. then _check_=trim(_Check_)!!" Xa" ;
if Xb=. then _check_=trim(_Check_)!!" Xb" ;
if Xc=. then _check_=trim(_Check_)!!" Xc" ;
put Xa= Xb= Xc= _check_= ;
run ;

When is the PUT statement executed?

Selecciona una de las siguientes respuestas posibles:

A. when the code is submitted
B. only when the WORK.BAD_DATA view is used
C. both when the code is submitted and the view is used
D. never, the use of _null_ in a view is a syntax error

Explicación

Pregunta 30 de 103

30. The following SAS program is submitted:
%let product=merchandise;
[_insert_%put_statement_]
and the following message is written to the SAS log: the value is "merchandise"

Selecciona una de las siguientes respuestas posibles:

A. %put the value is '"'&product.'"';
B. %put the value is %quote(&product.);
C. %put the value is "&product.";
D. %put the value is ""&product."";

Explicación

Pregunta 31 de 103

31. Given the SAS data sets:

What data values are stored in data set WORK.COMBINE?

Selecciona una de las siguientes respuestas posibles:

A. An ERROR message is written to the SAS log and the data set WORK.COMBINE is not created.
B.
SumY X Y
---- -- --
36 A 10
C.
SumY X Y
---- -- --
36 A 10
. A 3
. A 14
. B 9
D.
SumY X Y
---- -- --
36 A 10
36 A 3
36 A 14
36 B 9

Explicación

Pregunta 32 de 103

32. The following SAS program is submitted:
data WORK.NEW(bufno=4);
set WORK.OLD(bufno=3);
run;

Why are the BUFNO options used?

Selecciona una de las siguientes respuestas posibles:

A. to reduce memory usage
B. to reduce CPU time usage
C. to reduce the amount of data read
D. to reduce the number of I/O operations

Explicación

Pregunta 33 de 103

33. Given the following program and desired results:
%let Thing1=gift;
%let Thing2=surprise;
%let Gift1=book;
%let Gift2=jewelry;
%let Surprise1=dinner;
%let Surprise2=movie;

%let Pick=2;
%let Choice=surprise;

Desired %PUT Results in LOG:
My favorite surprise is a movie

What is the correct %PUT statement that generates the desired results?

Selecciona una de las siguientes respuestas posibles:

A. %put My favorite &Thing&Pick is a &&Choice&Pick;
B. %put My favorite &&Thing&pick is a &&&Choice&Pick;
C. %put My favorite &Choice&pick is a &&Thing&Pick;
D. %put My favorite &&Choice&pick is a &&&Thing&Pick;

Explicación

Pregunta 34 de 103

34. Given the SAS dataset WORK.ONE

Which SQL procedure clause completes the program and generates the desired output?

Selecciona una de las siguientes respuestas posibles:

A. select Salary Bonus as Salary*.10
B. select Salary Bonus=Salary*.10 'Bonus'
C. select Salary, Salary*.10 label='Bonus'
D. select Salary, Salary*.10 column="Bonus"

Explicación

Pregunta 35 de 103

35. 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?

Selecciona una de las siguientes respuestas posibles:

A. It allows updates in place.
B. It tracks and recycles free space.
C. It allows a permanently stored SAS data set to be replaced.
D. It allows users to access the same SAS data set concurrently.

Explicación

Pregunta 36 de 103

36. Which statement is true for Data step HASH objects?

Selecciona una de las siguientes respuestas posibles:

A. The key component must be numeric.
B. The data component may consist of numeric and character values.
C. The HASH object is created in one step and referenced in another.
D. The HASH object must be smaller than 2 to the 8th power bytes.

Explicación

Pregunta 37 de 103

37. Given the SAS data sets:

Which SQL set operator completes the program and generates the desired output?

Selecciona una de las siguientes respuestas posibles:

A. intersect corr
B. except all
C. intersect all
D. left except

Explicación

Pregunta 38 de 103

38. 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?

Selecciona una de las siguientes respuestas posibles:

A. Result is 0
B. Result is 1
C. Result is 10 gt 5
D. Result is true

Explicación

Pregunta 39 de 103

39. The following SAS program is submitted:
%let Mv=shoes;
%macro PRODUCT(Mv=bicycles);
%let Mv=clothes;
%mend;

%PRODUCT(Mv=tents)
%put Mv is &Mv;

What is written to the SAS log?

Selecciona una de las siguientes respuestas posibles:

A. Mv is bicycles
B. Mv is clothes
C. Mv is shoes
D. Mv is tents

Explicación

Pregunta 40 de 103

40. Which of the following SAS System options can aid in benchmarking?

Selecciona una de las siguientes respuestas posibles:

A. BUFSIZE= and BUFNO=
B. FULLSTIMER
C. IOBLOCKSIZE=
D. SYSTIMER

Explicación

Pregunta 41 de 103

41. Given the following macro program:

Which option would provide feedback in the log about the parameter values passed into this macro when invoked?

Selecciona una de las siguientes respuestas posibles:

A. MPRINT
B. MDEBUG
C. MLOGIC
D. MPARAM

Explicación

Pregunta 42 de 103

42. The NOTSORTED option on the BY statement cannot be used with which other statement or option?

Selecciona una de las siguientes respuestas posibles:

A. SET
B. MERGE
C. IF FIRST.by-variable
D. BY GROUPFORMAT by-variable

Explicación

Pregunta 43 de 103

43. Given the SAS data set WORK.ONE:
Rep Cost
----- ----
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100

Which SQL clause completes the program and generates the desired output?

Selecciona una de las siguientes respuestas posibles:

A. where calculated Average > (select avg(Cost) from WORK.ONE)
B. having Average > (select avg(Cost) from WORK.ONE)
C. having avg(Cost) < (select avg(Cost) from WORK.ONE)
D. where avg(Cost) > (select avg(Cost) from WORK.ONE)

Explicación

Pregunta 44 de 103

44. Which dictionary table provides information on each occurrence of the variable named LastName?

Selecciona una de las siguientes respuestas posibles:

A. DICTIONARY.TABLES
B. DICTIONARY.COLUMNS
C. DICTIONARY.MEMBERS
D. DICTIONARY.VARIABLES

Explicación

Pregunta 45 de 103

45. To create a list of unique Customer_Id values from the customer data set, which of the following techniques can be used?

technique 1: proc SORT with NODUPKEY and OUT=
technique 2: data step with IF FIRST.Customer_Id=1
technique 3: proc SQL with the SELECT DISTINCT statement

Selecciona una de las siguientes respuestas posibles:

A. only technique 1
B. techniques 1 and 2
C. techniques 1 and 3
D. techniques 1, 2, or 3

Explicación

Pregunta 46 de 103

46. Given the SAS data sets:

Which SQL set operator completes the program and generates the desired output?

Selecciona una de las siguientes respuestas posibles:

A. intersect corr
B. except
C. intersect
D. left except

Explicación

Pregunta 47 de 103

47. The following SAS program is submitted:

Which statement completes the program so that the PROC PRINT step executes on Thursday?

Selecciona una de las siguientes respuestas posibles:

A. if &sysday = Thursday then %do;
B. %if &sysday = Thursday %then %do;
C. %if "&sysday" = Thursday %then %do;
D. %if &sysday = "Thursday" %then %do;

Explicación

Pregunta 48 de 103

48. Given the following program and data:

What is the WHERE statement that successfully completes the PROC PRINT and selects the observation for Barb?

Selecciona una de las siguientes respuestas posibles:

A. where Birthday=&Want;
B. where Birthday="&Want";
C. where Birthday="&Want"d;
D. where Birthday='&Want'd;

Explicación

Pregunta 49 de 103

49. Which macro statement would remove the macro variable Mv_Info from the symbol table?

Selecciona una de las siguientes respuestas posibles:

A. %mdelete &Mv_Info;
B. %symerase Mv_Info;
C. %symdel &Mv_Info;
D. %symdel Mv_Info;

Explicación

Pregunta 50 de 103

50. The table WORK.PILOTS contains the following data:

Which select statement could NOT have produced this output?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 51 de 103

51. The SAS data set WORK.TEMP is indexed on the variable Id:

Which BY statement completes the program, creates a listing report that is grouped by Id, and completes without errors?

Selecciona una de las siguientes respuestas posibles:

A. by Id;
B. by Id grouped;
C. by Id descending;
D. by descending Id;

Explicación

Pregunta 52 de 103

52. To create a dataset with unique values of a given variable using a data step and the FIRST. VARIABLES and LAST.VARIABLES, it is assumed that the input dataset is:

Selecciona una de las siguientes respuestas posibles:

A. sorted on that variable.
B. indexed by that variable.
C. naturally in order.
D. any of the above A, B, or C

Explicación

Pregunta 53 de 103

53.The SASFILE statement requests that a SAS data set be opened and loaded into memory:

Selecciona una de las siguientes respuestas posibles:

A. one page at a time.
B. one variable at a time.
C. one observation at a time.
D. in its entirety, if possible.

Explicación

Pregunta 54 de 103

54. The following SAS program is submitted:

%let Name1=Shoes;
%let Name2=Clothes;
%let Root=name;
%let Suffix=2;
%put &&&Root&Suffix;

What is written to the SAS log?

Selecciona una de las siguientes respuestas posibles:

A. &Name2
B. Clothes
C. &&&Root&Suffix
D. WARNING: Apparent symbolic reference ROOT2 not resolved.

Explicación

Pregunta 55 de 103

55. Given the SAS data sets:

Which join operator completes the program
and generates the desired output?

Selecciona una de las siguientes respuestas posibles:

A. left join
B. right join
C. full join
D. outer join

Explicación

Pregunta 56 de 103

56. The SAS data set WORK.ADDRESSES contains the email addresses of The XYZ Corporation's customers in a variable named Email_Address. The following DATA step is submitted:

Which statement completes the program and creates a SAS program file?

Selecciona una de las siguientes respuestas posibles:

A. infile "c:\email.sas";
B. output "c:\email.sas";
C. file "c:\email.sas";
D. None of the above.

Explicación

Pregunta 57 de 103

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

Selecciona una de las siguientes respuestas posibles:

A. It uses the Ross Data Compression method to compress numeric data.
B. It is most effective with character data that contains repeated characters.
C. It is most effective with numeric data that represents large numeric values.
D. It is most effective with character data that contains patterns, rather than simple repetitions.

Explicación

Pregunta 58 de 103

Given the SAS dataset WORK.ONE:

Salary
------
200
205
.
523

Which WHERE expression completes the program and generates the desired output?

Selecciona una de las siguientes respuestas posibles:

A. where Salary is not .
B. where Salary ne missing
C. where Salary ne null
D. where Salary is not missing

Explicación

Pregunta 59 de 103

59. The SAS data set WORK.TEST has an index on the variable Id and the following SAS
program is submitted.

Selecciona una de las siguientes respuestas posibles:

A. The index on Id is deleted.
B. The index on Id is updated as an index on Id_Code.
C. The index on Id is deleted and an index on Id_Code is created.
D. The index on Id is recreated as an index on Id_Code.

Explicación

Pregunta 60 de 103

Given the data set SASHELP.CLASS:

Which PROC steps execute successfully?

Selecciona una de las siguientes respuestas posibles:

A. PROC MEANS only
B. PROC PRINT only
C. PROC MEANS and PROC PRINT
D. No PROC steps execute successfully

Explicación

Pregunta 61 de 103

61. In a data step merge, the BY variables in all data sets must have the same:

Selecciona una de las siguientes respuestas posibles:

A. name.
B. name and type.
C. name and length.
D. name, type, and length.

Explicación

Pregunta 62 de 103

62. Given the following macro program and invocation:

Which of these choices shows the correct %PUT statement output if the program is submitted at the beginning of a new SAS session? Note that other lines may be written to the SAS log by the program, but only the %PUT output is shown here.

Selecciona una de las siguientes respuestas posibles:

A. ---> inside macro WORK.NEW SASHELP.CLASS
---> outside invocation WORK.NEW SASHELP.CLASS
B. ---> inside macro WORK.NEW SASHELP.CLASS
---> outside invocation &NEWNAME &SETNAME
C. ---> inside macro &NEWNAME &SETNAME
---> outside invocation WORK.NEW SASHELP.CLASS
D. ---> inside macro &NEWNAME &SETNAME
---> outside invocation &NEWNAME &SETNAME

Explicación

Pregunta 63 de 103

63. The following SAS program is submitted:

Which VAR statement successfully completes the program to produce a report containing four variables?

Selecciona una de las siguientes respuestas posibles:

A. var %COLS1 %COLS2;
B. var %COLS1-%COLS2;
C. var %COLS1 Weight Height;
D. var Weight Height %COLS1;

Explicación

Pregunta 64 de 103

Rellena el espacio en blanco para completar el texto.

如何在 Log 中輸出 global macro variables

%put

Explicación

Pregunta 65 de 103

Rellena el espacio en blanco para completar el texto.

選出 unique value of a grouped variable

If =1 then output=xxx

(model 是這個 variable 的名字)

Explicación

Pregunta 66 de 103

Rellena el espacio en blanco para completar el texto.

outer union

Explicación

Pregunta 67 de 103

Rellena el espacio en blanco para completar el texto.

A Data has 2000million observations and 300 Character variables

Compress=

Explicación

Pregunta 68 de 103

Rellena el espacio en blanco para completar el texto.

Data Set
ONE
State_ID state
TWO
State_ID City

Quit 前的最後一句:

Ask: where s.state=

(注意一定要加引號)

Explicación

Pregunta 69 de 103

Rellena el espacio en blanco para completar el texto.

HASH object

Explicación

Pregunta 70 de 103

Rellena el espacio en blanco para completar el texto.

Given 2 Data Set
ONE
Name Year
Joyce 9
John 4
John 2
Jane 6
Thomas 8

TWO
Name Age(不需要理會)
Joyce
John
Thomas
Robert
Jeff

The following SAS program is submitted:
select Name, avg(Year) as average
from WORK.ONE
Except Corr
WORK.TWO
.............. quit;

Average of

Explicación

Pregunta 71 de 103

Rellena el espacio en blanco para completar el texto.

FCMP 填空
proc fcmp outlib=sasuser.funcs.trial;
...
endsub;
options =sasuser.funcs; data null;
...
run;

Explicación

Pregunta 72 de 103

Given data set and macro program, choose missing correct code
call symputx('&Num', California)

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 73 de 103

Rellena el espacio en blanco para completar el texto.

the first part of code gives Key:valuepair definition, the variables are somekey and someAlpha, we need to fill in the hash object definition.

Some.definedata( );

Explicación

Pregunta 74 de 103

Rellena el espacio en blanco para completar el texto.

declare has Goal();
Goal.definekey(“QtrNum”);
Goal.definedata();
Goal.definedone();

Explicación

Pregunta 75 de 103

repeated need a local data set, what kind of effect does SASFILE statement has to the Global statement.

Selecciona una o más de las siguientes respuestas posibles:

reduce CPU
reduce I/O
increase memory

Explicación

Pregunta 76 de 103

考察in line view。程序大致如下: proc sql;
create table forecast as
select a.*, b.sales
from actual a,_______ where a.dept=b.dept
quit;

Selecciona una o más de las siguientes respuestas posibles:

(select
avg(revenue) as average
from Budegt
group by 1) b
select (
avg(revenue) as average from Budegt
group by 1) b

Explicación

Pregunta 77 de 103

%let this_year=%substr(&sysdate9,6);
%let next_year=&this_year+1;
%let check_year=%eval(&next_year<2016);
%put two years after this year is &next_year+1;
%put &check_year is &check_year;

Assume system time is 01Jan2013, what is the output?

Selecciona una o más de las siguientes respuestas posibles:

two years after this year is 2013+1+1
check_year is 1

Explicación

Pregunta 78 de 103

A data set has 300,000 observations, 20 character variables, 50 numeric variables, 我们需要其中的 5 character variables 和 7 numeric variables，which is most efficient:

Selecciona una de las siguientes respuestas posibles:

A. DROP= option in data step
B. KEEP= option in data step
C. KEEP= option in set statement
D. KEEP statement

Explicación

Pregunta 79 de 103

Array multi{1:2,2} (1,2);
Do i=1 to 2;
Do j=1 to 2;
Output =multi{i.j};
问 i，j 和对应 output 的值，答案:

Selecciona una o más de las siguientes respuestas posibles:

i j output
111
122
21 .
22 .
i j output
111
122
21. 22.

Explicación

Pregunta 80 de 103

给定一个 data set 和 SQL 代码，问输出结果一致的是: 具体不记得了，摘一段类似的，考点在 nodupkey，注意要 drop 掉一个 variable
proc sort data=retail.order_fact
out=work.sorted (drop=XXX) nodupkey;
by order_date;
run;

需要选有nodupkey， drop掉一个variable,而且by variable 不能有descending的, 因为SQL中的order by 默认是ascending的

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 81 de 103

data company.newdata / view=company.newdata;
infile <fileref>;
<DATA step statements>
run;
以上代码 create a data step view 之后，要在 proc means 中使用 view，问应该用哪个代码:

Submit the above code and create a data step view, then we need to use this view in the PROC MEANS procedure, which one to use:

Selecciona una de las siguientes respuestas posibles:

A. proc means view= company.newdata;
B. proc means data=company.newdata / view=company.newdata;
C. proc means data company.newdata / view
D. proc means data=company.newdata

Explicación

Pregunta 82 de 103

Pagesize info
Which of proc can check the pagesize info?

Selecciona una de las siguientes respuestas posibles:

A Proc Contents
B Proc print
C Proc report
D Proc catalog

Explicación

Pregunta 83 de 103

Given two format with the same name $Gender, one store in Mylib, and the other in library. Proc print data=... ; run;
Using the format $Gender. From the desired output, we can tell that the format in Mylib is used. Options fmtsearch=______________; Which statement should be filled in here?

Selecciona una de las siguientes respuestas posibles:

A. no fmsearch needed
B. fmsearch=(mylib, library)
C. fmsearch=(library, mylib)
D. fmsearch=(mylib)

Explicación

Pregunta 84 de 103

Horizontal join set operator (i) right join
Two data sets
Work.One
year sales
2001 800
2001 500
2003 700

Work.Two
year profit
2001 100
2002 200

proc sql;
select sum(profit)
from one right join two
on one.year=two.year;
quit;
What is the output?

Selecciona una de las siguientes respuestas posibles:

A. 100
B. 300
C. 400
D. 500

Explicación

Pregunta 85 de 103

IDXNAME=... (instruct SAS to use a specific index for where processing)
IDXWHERE

sas里如何指定使用某一个index,用inxname
选inxname

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 86 de 103

It is about except operator, given two data sets,
Ask about the output. Choose the answer with one

Selecciona una o más de las siguientes respuestas posibles:

Answer: Charlie Omar
Answer:
Charlie
Omar

Explicación

Pregunta 87 de 103

Given two data sets and SQL code, ask for the output.

Selecciona una o más de las siguientes respuestas posibles:

Choose the answer with Thomas, Jones, Smith, but no Adam.
Besides, there is a descreasing option in the code, so the Sales need to be in decreasing order.

Explicación

Pregunta 88 de 103

哪个个 view 的命名 code 正确?

Selecciona una o más de las siguientes respuestas posibles:

data xxx/ view=xxx
(view 和 data set 的命名必须一样)

Explicación

Pregunta 89 de 103

Efficiency of If-then/Else and Where clauses
A compressed data set has 200,000 observations, 300 variables. We need 20% of character observations, What method can minimize computer resource usage?

Selecciona una de las siguientes respuestas posibles:

A. If-then/Else clause
B. Case
C. Where
D. ...

Explicación

Pregunta 90 de 103

Macro variable with macro trigger signs.
Output title “RECENT A&M ACTIVITY”, which macro definition should be used.

Selecciona una de las siguientes respuestas posibles:

A. title %sysfundc(“RECENT A&M ACTIVITY”)
B. title %str(“RECENT A&M ACTIVITY”);
C. title %nrstr(“RECENT A&M ACTIVITY”);
D. title %bquote(“RECENT A&M ACTIVITY);

Explicación

Pregunta 91 de 103

Effect on SASFILE for repeating a local data set
Repeated need a local data set, what kind of effect does SASFILE statement has to the Global statement.

Selecciona una de las siguientes respuestas posibles:

A increase Network Bandwidth
B CPU increase
C I/O increase
D memory increase

Explicación

Pregunta 92 de 103

left join and in-line view

Product
Product_id Product
1 1001
2 1002
3 1003

Sales
Product_id Sales
3 100
1 200
5 100
1 200
3 100
1 100

Proc sql;
Select p.product s.totalsales
From product as p
left join (
select sum(sales) as totalsales
from sales as s)
on p.product_id=s.product_id;
quit;

What is the output?

Selecciona una o más de las siguientes respuestas posibles:

Product Totalsales
1001 500
1002 .
1003 200
Product Totalsales

1001 500
1002 .
1003 200

Explicación

Pregunta 93 de 103

Work.temp is indexed

Selecciona una de las siguientes respuestas posibles:

A Stops to executes as this is not in ascending order
B Stops to executes as this is not in descending order
C continue to executes without problem
D continue to executes but index=USE

Explicación

Pregunta 94 de 103

in-line view
给了一段 code 明确告知 in-line view 中给定的 condition 有
multiply observations satisfied the condition，问 program 运行结果。

Selecciona una o más de las siguientes respuestas posibles:

答案是运行出错没有结果
因为 in-line view return multiple results

Explicación

Pregunta 95 de 103

in-line view
给了一段 code 明确告知运行出错没有结果，问原因
given a failed program, ask the reason of failure.
Proc sql;
select Jobcode, Salary,
(select avg(Salary)
from WORK.PILOTS
order by Jobcode) as Avg
from WORK.PILOTS
order by ID;
quit;

Selecciona una o más de las siguientes respuestas posibles:

Order By statement cannot be used inside of an in-line view.
There is another choice says that if using in-line view then we cannot use Order By statement. This is not true. The ORDER BY ID statement in the outside query is OK.

Explicación

Pregunta 96 de 103

用 sql 生成多个宏变量
Proc sql...;
select column1, column2
<insert code>;

Selecciona una de las siguientes respuestas posibles:

into: c1varibale1-: c1varibale3
: c2varibale1-: c2varibale3
into: c1varibale1- c1varibale3
: c2varibale1- c2varibale3
into: c1varibale1: c1varibale2: c1varibale3
: c2varibale1: c2varibale2: c2varibale3
into : type1 -:type3 , :sale1- :sale3
INTO: shoesales1-: shoesales3, shoetype1-:shoetype3

Explicación

Pregunta 97 de 103

展示数据库中两个数据集的名字、储存的行数和被删除的行数

问怎么在一个 library 里挑出删除了 5%以上 observation 的 dataset
选项太长了不记得具体的了，是考 dictionary table 的

Selecciona una de las siguientes respuestas posibles:

select menname, nobs, delobs from dictionary.tables
select menname, nlobs, delobs from dictionary.tables
select menname, nobs, delobs from dictionary.members

Explicación

Pregunta 98 de 103

multiple datasets 想用 set 和 key 合并的时候，应该应用在什么样的 dataset 上 (chapter 15)

mergedataset时，什么时候用multipleSETstatement最有效率

Selecciona una de las siguientes respuestas posibles:

A: dataset 都是 large，两个里面都有 index。
B: larger dataset，一个 smaller dataset，index in larger dataset
C: larger dataset，一个 smaller dataset，index in smaller dataset

Explicación

Pregunta 99 de 103

考点: create index 时 unique 是已经确认的，不能被更改

Selecciona una de las siguientes respuestas posibles:

create index 时 unique 是已经确认的
不能被更改

Explicación

Pregunta 100 de 103

引用 index 时，哪个效率高(题干和选项都没记清，仅提供考点)
在 index 很复杂的情况下，在 where statement 中选择怎样 index 最有效?

Selecciona una de las siguientes respuestas posibles:

index include more rows
index unqualified more rows
index that disqualify most variables
simple index
composite index

Explicación

Pregunta 101 de 103

给了data set 和desired output，要求选code。发现是要生成unique value of key variable.

Selecciona una de las siguientes respuestas posibles:

只有proc sort nodupkey; by var 的选项对
有干扰选项proc sort nodup; by var;

Explicación

Pregunta 102 de 103

什么样 characteristic 的 index can only be set up with DATASET procedure.

Selecciona una de las siguientes respuestas posibles:

A: 关于 index centiles 的，好像是 index centiles can be updated.
D:index 可以包括 missing value
A. multiple variables;
B. unique key

Explicación

Pregunta 103 de 103

要选出 inactive_date 为 missing 时候的 observation。题目是 prol sql;
Select *
From dataset1 A
Full join dataset2 B
On A.ID = B.ID
Where inactive_date is missing;

问 data dataset3;
merge dataset1 (In=Ina)
dataset2 (In=Inb);
By ID;
<insert statement>;

Selecciona una de las siguientes respuestas posibles:

A: where inactive_date is missing and (Ina and Inb)
B: where inactive_date is missing and (Ina or Inb)
C:想不起来了好像是 if inactive_date is missing and (ina and inb)
D: If inactive_date ne .

Explicación

Revisar respuesta

["https://cdn.goconqr.com/uploads/media/image/17291588/desktop_08cdf852-fbb5-465e-ba76-2e7066936b46.png","https://cdn.goconqr.com/uploads/media/image/17291624/desktop_4e14bbfe-9e67-47ab-811a-872adc314005.png","https://cdn.goconqr.com/uploads/media/image/17291668/desktop_bef58bf7-c38f-400d-b49e-090d50bc8c2b.png","https://cdn.goconqr.com/uploads/media/image/17292028/desktop_eaf575b7-db9f-4196-ba85-1763d8f75fd9.png","https://cdn.goconqr.com/uploads/media/image/17310208/desktop_3c9f22cf-74a5-40e7-b331-23a78d1e239f.png","https://cdn.goconqr.com/uploads/media/image/17310697/desktop_ab9bd8d3-aafc-4951-8c84-dc821440a2f9.png","https://cdn.goconqr.com/uploads/media/image/17310743/desktop_48df73a3-16cd-4476-97f1-85674531efb4.png","https://cdn.goconqr.com/uploads/media/image/17310963/desktop_eb0aa168-8374-427b-93b0-c25d3abdde0e.png","https://cdn.goconqr.com/uploads/media/image/17311298/desktop_89833321-e21e-469c-9d3c-fac88a1db066.png","https://cdn.goconqr.com/uploads/media/image/17314071/desktop_7ad299fd-023f-4cc6-bc7a-7a4352b78a98.png","https://cdn.goconqr.com/uploads/media/image/17314908/desktop_e114f783-e363-42f0-bf3a-3590f2e2b2ed.png","https://cdn.goconqr.com/uploads/media/image/17314977/desktop_c8bfe270-63d1-42d7-9fcd-581b0de3e7f9.png","https://cdn.goconqr.com/uploads/media/image/17315163/desktop_313c2aaf-2efc-45ed-a0f4-f4a8be1e3202.png","https://cdn.goconqr.com/uploads/media/image/17315634/desktop_17ce113f-4b9c-4dd9-bac0-f850980481d5.png","https://cdn.goconqr.com/uploads/media/image/17315840/desktop_08cb6bba-5b9a-4926-abd9-066ad06a6f37.png","https://cdn.goconqr.com/uploads/media/image/17315923/desktop_5dc0232c-4f26-435b-a404-eca20d128c91.png","https://cdn.goconqr.com/uploads/media/image/17316283/desktop_487da0e8-a2df-4f71-a71a-03a175c4da9c.png","https://cdn.goconqr.com/uploads/media/image/17318820/desktop_98d4d8b6-248c-4fde-9a96-206e284998e0.png","https://cdn.goconqr.com/uploads/media/image/17319179/desktop_af964a11-3c57-4bd2-a417-c2b7cf11d422.png","https://cdn.goconqr.com/uploads/media/image/17326574/desktop_a7ec23a0-d8dd-499e-9441-77ff1d98c869.png","https://cdn.goconqr.com/uploads/media/image/17327486/desktop_e23ebe47-1b3e-497d-8a1d-8af848b7d7fe.png","https://cdn.goconqr.com/uploads/media/image/17327576/desktop_5aa63fde-5b4b-4668-86c5-1640e8f59075.png","https://cdn.goconqr.com/uploads/media/image/17327932/desktop_59d8c054-ee97-4056-904a-faf15026c705.png","https://cdn.goconqr.com/uploads/media/image/17327966/desktop_16e5b3bc-ee99-4003-bedd-69d587a5eeea.png","https://cdn.goconqr.com/uploads/media/image/17328018/desktop_c8183ff7-4221-429c-8f61-6dd7108d4c26.png","https://cdn.goconqr.com/uploads/media/image/17328034/desktop_7896b4bf-7629-4468-b75a-d8bc96ac553c.png","https://cdn.goconqr.com/uploads/media/image/17328074/desktop_7398304f-716b-4859-b28c-e0a6c11c0b23.png","https://cdn.goconqr.com/uploads/media/image/17328116/desktop_94ce8a92-5579-4772-81eb-476d2c500ed7.png","https://cdn.goconqr.com/uploads/media/image/17328164/desktop_a10467a1-a18e-4535-99fc-f54817cdb7d4.png","https://cdn.goconqr.com/uploads/media/image/17375482/desktop_a9d0ac51-5ee7-42cb-8db5-da7e0ec1182c.png","https://cdn.goconqr.com/uploads/media/image/17370727/desktop_d26b82b4-2a3a-4ca8-af6d-36ac5d6846eb.png","https://cdn.goconqr.com/uploads/media/image/17315178/desktop_ebf7facb-423d-420d-a411-bbe75d8ffac1.png","https://cdn.goconqr.com/uploads/media/image/17315205/desktop_ef318da9-bf90-428e-ba3a-4827d226613c.png","https://cdn.goconqr.com/uploads/media/image/17315212/desktop_f74edbb5-ce9c-42ca-b18c-69c83e18b0d0.png","https://cdn.goconqr.com/uploads/media/image/17315216/desktop_4b6aa76a-f5a7-45d3-ac16-ab3fa3a3366b.png","https://cdn.goconqr.com/uploads/media/image/17327578/desktop_079fc316-c7e2-421e-8ae6-00447d5f433d.png","https://cdn.goconqr.com/uploads/media/image/17327582/desktop_50f6af37-988c-4316-b993-11d13e09a18a.png","https://cdn.goconqr.com/uploads/media/image/17327635/desktop_1b178395-544f-4c55-b2f4-e9f9fe820d1d.png","https://cdn.goconqr.com/uploads/media/image/17327638/desktop_68c938c1-c443-4dc2-8b78-a8aaa34f1145.png"]

	Creado por Grace Li hace casi 6 años

Test sobre SAS advance 63, creado por Grace Li el 26/09/2018.

SAS advance 63

SAS advance 63

Pregunta 1 de 103

1. When attempting to minimize memory usage, the most efficient way to do group processing when using the MEANS procedure is to use:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 103

2. The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 3 de 103

3. Given the SAS data sets: What would allow the program to successfully execute without errors?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 103

4. Given the SAS data set SASUSER.HIGHWAY: Which SQL clause stores the text 0-29, 30-49, 50+ in the macro variable GROUPS?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 5 de 103

5. The SAS data set WORK.CHECK has an index on the variable Code and the following SAS program is submitted. proc sort data=WORK.CHECK; by Code; run; Which describes the result of submitting the SAS program?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 6 de 103

6. The table WORK.PILOTS contains the following data: Which SQL statement could NOT generate this result?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 103

7. A quick rule of thumb for the space required to run PROC SORT is:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 8 de 103

8. Multi-threaded processing for PROC SORT will affect which of these system resources?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 9 de 103

9. Given the SAS data set WORK.TRANSACT: Which SQL statement was used?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 103

10. (%EVAL) The following SAS program is submitted: %let Value=9; %let Add=5; %let Newval=%eval(&Value/&Add); %put &Newval; What is the value of the macro variable Newval when the %PUT statement executes?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 11 de 103

11. The following SAS code is submitted: data WORK.TEMP WORK.ERRORS / view=WORK.TEMP; infile RAWDATA; input Xa Xb Xc; if Xa=. then output WORK.ERRORS; else output WORK.TEMP; run; Which of the following is true of the WORK.ERRORS data set?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 12 de 103

12. Which title statement would always display the current date?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 13 de 103

13. Given the SAS data sets: Which SQL procedure statement produces the same results?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 14 de 103

14. The following SAS program is submitted: proc contents data=TESTDATA.ONE; run; Which SQL procedure step produces similar information about the column attributes of TESTDATA.ONE?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 15 de 103

15. Given the SAS data set WORK.ONE: Which result set would be generated?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 16 de 103

16. Given the SAS data sets: The following output is desired: Name Fi ------- -- Lauren L Patel A Chang Z Hillier R Smith M Lauren L Patel A Which SQL set operator completes the program and generates the desired output?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 17 de 103

17. Which of the following is an advantage of SAS views?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 18 de 103

18. In what order does SAS search for format definitions by default?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 19 de 103

19. Function %UPCASE: Which WHERE statement successfully completes the program and produces a report?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 20 de 103

3. Given the SAS data sets:

What would allow the program to successfully execute without errors?

4. Given the SAS data set SASUSER.HIGHWAY:

Which SQL clause stores the text 0-29, 30-49, 50+ in the macro variable GROUPS?

5. The SAS data set WORK.CHECK has an index on the variable Code and the following SAS program is submitted.
proc sort data=WORK.CHECK;
by Code;
run;

Which describes the result of submitting the SAS program?

6. The table WORK.PILOTS contains the following data:

Which SQL statement could NOT generate this result?

9. Given the SAS data set WORK.TRANSACT:

Which SQL statement was used?

10. (%EVAL) The following SAS program is submitted:
%let Value=9;
%let Add=5;
%let Newval=%eval(&Value/&Add); %put &Newval;

What is the value of the macro variable Newval when the %PUT statement executes?

11. The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
infile RAWDATA;
input Xa Xb Xc;
if Xa=. then output WORK.ERRORS;
else output WORK.TEMP;
run;

Which of the following is true of the WORK.ERRORS data set?

13. Given the SAS data sets:

Which SQL procedure statement produces the same results?

14. The following SAS program is submitted:
proc contents data=TESTDATA.ONE;
run;

Which SQL procedure step produces similar information about the column attributes of TESTDATA.ONE?

15. Given the SAS data set WORK.ONE:

Which result set would be generated?

16. Given the SAS data sets:

The following output is desired:

Name Fi
------- --
Lauren L
Patel A
Chang Z
Hillier R
Smith M
Lauren L
Patel A

Which SQL set operator completes the program and generates the desired output?

19. Function %UPCASE:

Which WHERE statement successfully completes the program and produces a report?

20. The following SAS program is submitted:
data WORK.TEMP;
length A B 3 X;
infile RAWDATA;
input A B X;
run;

What is the length of variable A?

21. The following SAS program is submitted:

The purpose of the FILEVAR=option on the INFILE statement is to name the variable Next, whose value:

22. DESCRIBE TABLE Statement
Given the following partial SAS log:
NOTE: SQL table SASHELP.CLASS was created like:
create table SASHELP.CLASS( bufsize=4096 )
(
Name char(8),
Sex char(1),
Age num,
Height num,
Weight num
);

Which SQL procedure statement generated this output?

23. Given the SAS data set SASUSER.HIGHWAY:

What macro variable reference completes the program to create the WORK.NOT and
WORK.SERIOUS data sets?

24. The following SAS program is submitted:
%let Num1=7;
%let Num2=3;
%let Result=%eval(&Num1/&Num2);
%put &Result;

What is the value of the macro variable Result when the %PUT statement executes?

25. Macros That Include Keyword Parameters:
Given the SAS data set SASUSER.HIGHWAY:

How many observations appear in the generated report?

26. Given the following SAS data sets:

Which of the following SQL statements was most likely used to generate this result?

27. Given the SAS data sets:

What data values are stored in data set WORK.COMBINE?

30. The following SAS program is submitted:
%let product=merchandise;
[_insert_%put_statement_]
and the following message is written to the SAS log: the value is "merchandise"

31. Given the SAS data sets:

What data values are stored in data set WORK.COMBINE?

32. The following SAS program is submitted:
data WORK.NEW(bufno=4);
set WORK.OLD(bufno=3);
run;

Why are the BUFNO options used?

34. Given the SAS dataset WORK.ONE

Which SQL procedure clause completes the program and generates the desired output?

35. 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?

37. Given the SAS data sets:

Which SQL set operator completes the program and generates the desired output?