Premium

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



Question : You have submitted a SAS program, but there seems to be an invalid option given in a statement, How would you identify that?

: You have submitted a SAS program, but there seems to be an invalid option given in a statement, How would you identify that?
1. Wherever is an invalid option given SAS will give Error message for that

2. In the log message you can see that an option is not a valid or not recognized

 3. Access Mostly Uused Products by 50000+ Subscribers

4. You have to carefully examine the SAS program, because SAS will not tell you about invalid option and will be ignored by the SAS.


Correct Answer : Get Lastest Questions and Answer :
Explanation: When you run a SAS program with the statement that contains an invalid option, a log message will be printed that option is not
valid or not recognized in log window.




Question : The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?
: The following SAS program is submitted:
1. A LIBNAME statement for the libref TEMP only must be submitted.
2. A LIBNAME statement for the libref SASUSER only must be submitted.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. No LIBNAME statement needs to be submitted.



Correct Answer : Get Lastest Questions and Answer :

Explanation:




Question : The data set RALESTATE has the variable LOCALFEE with a format or . and a variable

COUNTRYFEE with a format or 7.;

The following SAS program is submitted:
data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

: The data set RALESTATE has the variable LOCALFEE with a format or . and a variable
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 percent6.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The data step fails execution; there is no format for LOCALFEE

Correct Answer : Get Lastest Questions and Answer :

Explanation:


Related Questions

Question : You have been given below data

With the following SAS statements
If course_name=SAS AND DURATION=30
Then FEE=10000;
If LOCATION=PUNE or COURSE_ID=100
Then MESSAGE=LOW;

What would the correct values of the variable?

 : You have been given below data
1. FEE=5000 MESSAGE=LOW

2. FEE=10000 MESSAGE=LOW

3. Access Mostly Uused Products by 50000+ Subscribers

4. FEE=10000 MESSAGE=



Question : Which is the correct statement regarding length of a variable in a SAS program?
A. As soon as variable appear in data step and its value derive the length.
B. Whatever length explicitly defined will be the length of that variable
C. As soon as you do the assignment

 : Which is the correct statement regarding length of a variable in a SAS program?
1. A,B
2. B,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,C


Question : You have been given below program
If course_name=SAS then fee=7000;
If course_name=HADOOP then FEE=8000;
If course_name^=HADOOP and COURSE_NAME^=SAS then FEE=5000;

Which of the following SAS program will be the same as given above?

 : You have been given below program
1. IF COURSE_NAME=SAS then FEE=7000;
Else if COURSE_NAME=HADOOP then FEE=8000;
Else FEE=5000;


2. IF COURSE_NAME=SAS then FEE=7000;
if COURSE_NAME=HADOOP then FEE=8000;
Else FEE=NULL;


 3. Access Mostly Uused Products by 50000+ Subscribers
Else COURSE_NAME=HADOOP then FEE=8000;
Else FEE=5000;


4. IF COURSE_NAME=SAS then FEE=7000;
SELECT if COURSE_NAME=HADOOP then FEE=8000;
Else FEE=5000;



Question : You have been given below program

data course2017 ;
input COURSE_ID 1-3 COURSE_NAME$ 5-20 LOCATION$ 22-30 FEE 32-35 DATE$ 36-47
DURATION 48-50;
DROP FEE;
TotalFee=(FEE*18/100)+FEE;
RETAIN ENTIREFEE 100000;
ENTIREFEE+TotalFee;
if LOCATION in ('PUNE','JODHPUR') then FEETYPE=MEDIUM;
length FEETYPE $ 8;

In this case what would be the length of a variable FEETYPE?

 : You have been given below program
1. 8

2. 6

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Not known



Question : In which of the following program either DROP or KEEP is wrongly used

 : In which of the following program either DROP or KEEP is wrongly used
1. data course2017 ;
input COURSE_ID 1-3 COURSE_NAME$ 5-20 LOCATION$ 22-30 FEE 32-35 DATE$ 36-47
DURATION 48-50;
DROP FEE;
TotalFee=(FEE*18/100)+FEE;
RETAIN ENTIREFEE 100000;
ENTIREFEE+TotalFee;

2. proc print data=course2017 lable;
DROP TotalFee;
var COURSE_ID COURSE_NAME LOCATION DATE DURATION ENTIREFEE MESSAGE ;
run;



 3. Access Mostly Uused Products by 50000+ Subscribers
input COURSE_ID 1-3 COURSE_NAME$ 5-20 LOCATION$ 22-30 FEE 32-35 DATE$ 36-47
DURATION 48-50;
DROP FEE;
TotalFee=(FEE*18/100)+FEE;
RETAIN ENTIREFEE 100000;
ENTIREFEE+TotalFee;


4. data course2017 ;
input COURSE_ID 1-3 COURSE_NAME$ 5-20 LOCATION$ 22-30 FEE 32-35 DATE$ 36-47
DURATION 48-50;
DROP FEE;
KEEP COURSE_NAME;
TotalFee=(FEE*18/100)+FEE;
RETAIN ENTIREFEE 100000;
ENTIREFEE+TotalFee;




Question : You have been given below step

data course2017_1 (drop=DATE DURATION);
set course2017 (keep=COURSE_NAME FEE DATE DURATION);
run;

After running this which of the columns will be in the output?

 : You have been given below step
1. COURSE_NAME FEE DATE DURATION

2. DATE DURATION

 3. Access Mostly Uused Products by 50000+ Subscribers

4. ERROR