Premium

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



Question : You have been given below dataset



Where every 4th record has course id and you want to read it first, which of the following can help you for this?

: You have been given below dataset
1. Column pointer control

2. Line pointer control

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Line position control


Correct Answer : Get Lastest Questions and Answer :
Explanation: You can read specific line and directly move that line using line pointer control.




Question : You have been given below dataset, which contains lines. However, you want to read it in observation, where each observation will have
3 records from raw file.



Which of the following can help for this requirement?

: You have been given below dataset, which contains lines. However, you want to read it in observation, where each observation will have
1. @n

2. /

 3. Access Mostly Uused Products by 50000+ Subscribers

4. I++


Correct Answer : Get Lastest Questions and Answer :
Explanation: You can use forward line control / to read data from multiple line into single observation.




Question : You have been given below dataset, which contain observation in line.

You want to read the observation like this 4th line first and then 1, 2, 3 line. Which of the following can help you to read raw data using absolute
line number?

: You have been given below dataset, which contain observation in line.
1. @n

2. @

 3. Access Mostly Uused Products by 50000+ Subscribers

4. \


Correct Answer : Get Lastest Questions and Answer :
Explanation: You can use absolute line number using syntax #n, it means it will read line 4 as #4


Related Questions

Question :
The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label
of "Open Date". Which SAS program temporarily replaces the label "Open Date" with the label "Starting
Date" in the output?

 :
1. proc print data=SASUSER.HOUSES label;
label Open_Date "Starting Date";
run;
2. proc print data=SASUSER.HOUSES label;
label Open_Date="Starting Date";
run;
3. Access Mostly Uused Products by 50000+ Subscribers
label Open_Date="Starting Date";
run;
4. proc print data=SASUSER.HOUSES;
Open_Date="Starting Date";
run;


Question :
Consider the following data step:

In filtering the values of the variable X in data set WORK.OLD,
what value new value would be assigned
to X if its original value was a missing value?

 :
1. X would get a value of 1.
2. X would get a value of 3.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. This step does not run because of syntax errors.



Question :
The following program is submitted:
Why does the program fail?
 :
1. The PAGENO option is invalid in the OPTIONS statement.
2. The RUN statement is missing after the FORMAT procedure.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The LABEL option is missing from the PROC PRINT statement.



Question :
Given the SAS data set WORK.PRODUCTS:
How many observations does the WORK.OUTDOOR data set contain?


 :
1. 1
2. 2
 3. Access Mostly Uused Products by 50000+ Subscribers
4. 6



Question :



 :
1. a
2. b
 3. Access Mostly Uused Products by 50000+ Subscribers
4. d



Question :
Given the SAS data set WORK.PRODUCTS:
How many variables does the WORK.REVENUE data set contain?


 :
1. 2
2. 3
 3. Access Mostly Uused Products by 50000+ Subscribers
4. 6