Premium

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



Question : You have been given below dataset

How will you read it in 2 observation in order of course_name , training_date, location, duration, fee and institute?

: You have been given below dataset
1. input course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;


2. input
#1 course_name $ training_date mmddyy8. /
#2 location $ duration /
#3 Fee INSTITUTE $;


 3. Access Mostly Uused Products by 50000+ Subscribers
#1 course_name $ training_date mmddyy8. ;
#2 location $ duration ;
#3 Fee INSTITUTE $;


4. input course_name $ training_date mmddyy8. \
location $ duration \
Fee INSTITUTE $;


Correct Answer : Get Lastest Questions and Answer :
Explanation: To read data from multiple lines you can use either #n or / . However, it depends which one you choose. Like if you want to
read it sequentially than you will not use #n syntax, but / . This / will help you to read data in sequence line by line. You should not use semicolon
until you finish line read.




Question : You have been given below dataset


Now you want to read ID first from line 4 and then go back to line 1 to read course_name and date, which of the following syntax are correct?

: You have been given below dataset
1. Input #4 id $ \
course_name $ course_date mmddyy8.;


2. Input #4 id $
@1 course_name $ course_date mmddyy8.;


 3. Access Mostly Uused Products by 50000+ Subscribers
#1 course_name $ course_date mmddyy8.;


4. Input #4 id $
#1 course_name $ course_date mmddyy8.;


Correct Answer : Get Lastest Questions and Answer :
Explanation: To reach absolute line number you should have used #n line control, it help you read data which are not sequential.




Question : You have below raw data file



And given SAS input statement

input
# 4 course_id $
#1 course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;

How many observation will be produced using above input statement?

: You have below raw data file
1. 24

2. 16

 3. Access Mostly Uused Products by 50000+ Subscribers

4. 4

5. 6


Correct Answer : Get Lastest Questions and Answer :
Explanation: As you can see line control start at #4 and in total we have 4 records are being read using both / and #n syntax. So there are
24 records in raw file which will generate 6 observations.


Related Questions

Question :
The following SAS program is submitted:
What is the initial value of the variable Total in the following program?
 :
1. 0
2. Missing
3. Access Mostly Uused Products by 50000+ Subscribers
4. Cannot be determined from the information given



Question :
Consider the following data step:
data WORK.NEW;
set WORK.OLD;
Count+1;
run;
The varaible Count is created using a sum statement. Which statement regarding this variable is true?
 :
1. It is assigned a value 0 when the data step begins execution.
2. It is assigned a value of missing when the data step begins execution.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. It is assigned a value of missing at compile time.



Question :
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable
CountryFee with a format of 7.;
The following SAS program is submitted:

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?
 :
1. LocalFee has format of 9. and CountryFee has a format of 7.
2. LocalFee has format of 9. and CountryFee has a format of percent7.2
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The data step fails execution; there is no format for LocalFee.


Question :

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




Question :
Which of the programs correctly invokes the DATA Step Debugger?
 :
1. a
2. b
 3. Access Mostly Uused Products by 50000+ Subscribers
4. d


Question :
Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted
observations in a temporary SAS data set?
 :
1. proc sort out=EMPLOYEES data=EMPSORT;
by Lname and Fname;
run;
2. proc sort data=SASUSER.EMPLOYEES out=EMPSORT;
by Lname Fname;
run;
 3. Access Mostly Uused Products by 50000+ Subscribers
run;
4. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT; by Lname and Fname;
run;