Premium

Base SAS Certified Associate: Programming Fundamentals Using SAS Questions and Answers (Dumps and Practice Questions)



Question : When you run the below program what would happened. Assume hesample.dat has valid observations.
data prices;
infile '/folders/myfolders/hadoopexam/hesample1.dat';
input CODE $ NAME$ FEE1 FEE2;
format FEE1 fee. Name name.;
run;

data work.subset;
set prices (firstobs=3 obs=2);
run;

: When you run the below program what would happened. Assume hesample.dat has valid observations.
1. Subset data set will have 2 observation.

2. Subset data set will have 3 observation.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Program will generate error


Correct Answer : Get Lastest Questions and Answer :
Explanation: Option given are wrong and you will get below error.
ERROR: FIRSTOBS option > OBS option - no data to read from file WORK.PRICES.
FIRSTOBS= specifies the number of the first observation to process.
When the FIRSTOBS= data set option specifies a starting point for processing, the OBS= data set option specifies an ending point. The two options are
often used together to define a range of observations to be processed.





Question : You are running below program
data course2017_1;
obsnum=5;
set course2017 (keep=COURSE_NAME LOCATION) point=obsnum;
output;
stop;
run;

where course2017 has 100 observations. What happen when you run the program?

: You are running below program
1. It will give error

2. It will generate warning messages

 3. Access Mostly Uused Products by 50000+ Subscribers

4. It will generate output with 1 observations having two columns only.


Correct Answer : Get Lastest Questions and Answer :
Explanation: In the given program three things matter POINT= output and stop. If they all three are used together than only 1 observation
will be generated.




Question : You are running below program
data course2017_1;
set course2017 end=last;
if last;
run;

where course2017 has 100 observations. What happen when you run the program?

: You are running below program
1. It will give error and no output will be generated

2. It will give warning and 100 observations will be in the output.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. It will generate only 1 output with warning


Correct Answer : Get Lastest Questions and Answer :
Explanation: This type of questions really want to know, do you have hands on or not. Like in the given program nothing is wrong.
END= option to tell SAS to create a temporary numeric value whose value is used to detect the last observation.
SET statement's END= option and a subsetting IF statement to tell SAS to write only the last observation in the input data set (course2017) to the
output data set (course2017_1)



Related Questions

Question : You have been given below SAS program, how many statements are there ?
data
hadoopexam.courses;
infile hadoopexam1; input name $ price ;
run;

: You have been given below SAS program, how many statements are there ?
1. 4

2. 5

3. 6

4. 7



Question : How do you define a SAS library?
A. It is a collection of SAS files.
B. It is a collection of physical SAS files.
C. It is a group files in a folder
D. It is a collection of folders

 : How do you define a SAS library?
1. A,B,C
2. B,C,D
3. A,C,D
4. A,B,D


Question : Which of the following is best suitable option on all the SAS platform, so that SAS ouput can be generated in HTML format?

 : Which of the following is best suitable option on all the SAS platform, so that SAS ouput can be generated in HTML format?
1. You must use system options

2. You have to use dataset specific options

3. By default on all the platform it will be HTML format only

4. You should use proper programming statement to generate HTML format output



Question : You have been given two dates as Dec and Jan, now you need to make sure that the date read by the SAS system as above, what
value you should specify for the YEARCUTOFF= option?

 : You have been given two dates as Dec and Jan, now you need to make sure that the date read by the SAS system as above, what
1. YEARCUTOFF=46

2. YEARCUTOFF=55

3. YEARCUTOFF=45

4. YEARCUTOFF=54

5. Any value, you can specify



Question : : You are working in a company named Acmeshell Inc. which has SAS licensed software. However, you have been asked to use specific SAS
engine while working on the data set, why?

 : : You are working in a company named Acmeshell Inc. which has SAS licensed software. However, you have been asked to use specific SAS
1. Because any temporary files created by the SAS will depend on this engine.

2. You may have to use specific files generated in Acmeshell needs to be read by SAS

3. It will make sure that you will be always using the latest version of the SAS software

4. It will specify the file format for files that will be stored in the library.



Question : The contents of the raw data file SIZE are listed below:

--------10-------20-------30
72 95
The following SAS program is submitted:
data test;
infile 'size';
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?



 : The contents of the raw data file SIZE are listed below:
1. 2
2. 72
3. 95
4. . (missing numeric value)