A00-201
name age Alfred 14 Alice13 Barbara 13 Carol 14
The following SAS program is submitted using the PERM.STUDENTS data set as input:
Libnameperm 'SAS-date-library'; data students; set perm.students; file 'file-specification'; put name $15. @5 age 2.; run
Which one of the following represents the values written to the output raw data file?
A. ----|----10---|----20---|----30 Alfred 14 Alice 13 Barbara 13 Carol 14
B. ----|----10---|----20---|----30 Alfr14 Alic13 Barb13a Caro14
C. ----|----10---|----20---|----30 Alfr14ed Alic13e Barb13ara Caro14l
D. ----|----10---|----20---|----30 Alfred 14 Alice 13 Barbara 13 Carol 14
Answer: B
QUESTION 33
The contents of the raw data file TEAM are listed below: ----|----10---|----20---|----30 Janice 10 Henri 11 Michael 11 Susan 12
The following SAS program is submitted:
Actualtests.com - The Power of Knowing
A00-201
data group; infile 'team';
input name $15. age 2.; file 'file-specification'; put name $15. =5 age 2.; run;
Which one of the following describes the output created?
A. a raw data file only
B. a SAS data set named GROUP only
C. a SAS data set named GROUP and a raw data file
D. No output is generated as the program fails to execute due to errors.
Answer: C
QUESTION 34
The following SAS program is submitted: data_null_; set old;
put sales1 sales2; run;
Where is the output written?
A. the SAS log
B. the raw data file that was opened last C. the SAS output window or an output file
D. the data set mentioned in the DATA statement
Answer: A
QUESTION 35
The following SAS program is submitted: data_null_;
set old (keep = prod sales1 sales2); file 'file-specification'; put sales1 sales2; run;
Which one of the following default delimiters separates the fields in the raw data file created?
A. : (colon) B. (space) C. , (comma) D. ;(semicolon)
Answer: B
Actualtests.com - The Power of Knowing
A00-201
QUESTION 36
The following SAS program is submitted: data allobs;
set sasdata.origin (firstobs = 75 obs = 499); run;
The SAS data set SASDATA.ORIGIN contains 1000 observations. How many observations does the ALLOBS data set contain?
A. 424 B. 425 C. 499 D. 1000
Answer: B
QUESTION 37
The SAS data set named COMPANY.PRICES is listed below: COMPANY.PRICES
prodidprice producttype sales returns K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10 R18KY2 1.29 SOFTWARE 25 5 3KL8BY 6.37 HARDWARE 125 15 DY65DW 5.60 HARDWARE 45 5 DGTY23 4.55 HARDWARE 67 2
The following SAS program is submitted: libnamecompany 'SAS-data-library'; data hware inter soft;
set company.prices (keep = producttype price); if price le 5.00;
if producttype = 'HARDWARE' then output HWARE; else if producttype = 'NETWORK' then output INTER; else if producttype = 'SOFTWARE' then output SOFT; run;
How many observations does the HWARE data set contain? A. 0 B. 2 C. 4 D. 6
Answer: B
QUESTION 38
The SASDATA.BANKS data set has five observations when the following SAS
Actualtests.com - The Power of Knowing
A00-201
program is submitted:
libnamesasdata 'SAS-date-library'; data allobs;
set sasdata.banks; capital=0;
do year = 2000 to 2020 by 5; capital + ((capital+2000) * rate); output; end;
How many observations will the ALLOBS data set contain? A. 5 B. 15 C. 20 D. 25
Answer: D
QUESTION 39
A raw data file is listed below: ----|----10---|----20---|----30 John McCloskey 35 71 June Rosesette 10 43 TinekeJones 9 37
The following SAS program is submitted using the raw data file as input: data work.homework; infile 'file-specification'; input name $ age height; if age LE 10; run;
How many observations will the WORK.HOMEWORK data set contain? A. 0 B. 2 C. 3
D. No data set is created as the program fails to execute due to errors.
Answer: C
QUESTION 40
The following SAS program is submitted: proc contents data = sasuser.airplanes; run;
Which one of the following is produced as output?
A. the data portion of every data set in the SASUSER library
Actualtests.com - The Power of Knowing
A00-201
B. the data portion of the data set SASUSER.AIRPLANES only C. the descriptor portion of every data set in the SASUSER library D. the descriptor portion of the data set SASUSER.AIRPLANES only
Answer: D
QUESTION 41
The following SAS program is submitted: proc datasets lib = sasuser; contents data = class varnum; quit;
Which one of the following is the purpose of the VARNUM option?
A. to print a list of variable names
B. to print the total number of variables
C. to print a list of the variables in alphabetic order
D. to print a list of the variables in the order they were created
Answer: D
QUESTION 42
Which one of the following SAS procedures displays the data portion of a SAS data set?
A. PRINT B. FSLIST C. CONTENTS D. DATASETS
Answer: A
QUESTION 43
On which portion(s) of a SAS data set does the PRINT procedure report?
A. the data portion only
B. the descriptor portion only
C. the descriptor portion and the data portion
D. neither the data portion nor the descriptor portion
Answer: A
QUESTION 44
The following SAS program is submitted: data work.test;
set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - difsales3;
Actualtests.com - The Power of Knowing
SAS base 123 训练题 免费 - 图文
