Premium

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



Question : Is there anything wrong with the below program
data HADOOPEXAM ;
infile "/folders/myfolders/hedata/filtered1.dat"
input COURSE_ID 1-3 COURSE_NAME$ 5-20 LOCATION$ 22-30 FEE 32-35 DATE$ 36-47
DURATION 48-50;
Total_FEE=FEE+FEE*18/100;
run;

: Is there anything wrong with the below program
1. You must put semicolon on each line. Semicolon missing on line 2 and 3

2. Semicolon is required in line 3 only

 3. Access Mostly Uused Products by 50000+ Subscribers

4. You must put semicolon in line 2


Correct Answer : Get Lastest Questions and Answer :
Explanation: There is no issue, if you use the variable in a calculation and update the same variable as in the given program. It is
mandatory to have semicolon at the end of each SAS statement and not the end of the line, because a single SAS statement can span more than 1 line.




Question : You can see following log is printed after execution of SAS program.
NOTE: Invalid data for COURSEID in line 7 15-19.
RULE: ----+----1----+----2----+----3----+----47
MUMBAI SPARK 3 5000
LOCATION=MUMBAI COURSEID=. COURSE_NAME=SPARK FEE=5000
Total=100 _ERROR_=1 _N_=1

What can you interpret from this?

: You can see following log is printed after execution of SAS program.
1. There is a Syntax error and you have not used SAS keywords correctly.

2. All the columns are not kept in the correct order

 3. Access Mostly Uused Products by 50000+ Subscribers

4. A dollar sign was missing in the INPUT statement.


Correct Answer : Get Lastest Questions and Answer :
Explanation: This kind of question generally take longer time to find the reason, However, focus first that is there any value which is
shown as missing. If value is missing it means something wrong with the input data or variable definition. However, we dont know how the input data in
the raw file. However, you know it is a numeric value defined. So the only option which is correspond to given output is missing dollar sing while
declaring the variable.




Question : You have defined a SAS format as below.
proc format ;
value location
1='Mumbai'
2='Pune'
3='Chennai';
Run;
How long this format will be available?

: You have defined a SAS format as below.
1. For the new PROC and DATA step only

2. For Next DATA step only.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. It will be available permanently


Correct Answer : Get Lastest Questions and Answer :
Explanation: Since, this format are not defined as part of permanent library. Hence, they will remain only temporary as part of Work library
only.


Related Questions

Question :

Which programming statement is used to perform conditional processing on
groups of SAS statements?


 :
1. DO
2. BY
3. Access Mostly Uused Products by 50000+ Subscribers
4. IF/THEN


Question :

The following SAS program is submitted:


data test;
set sasuser.employees;
if 2 le years_service le 10 then amount = 1000;
else if years_service gt 10 then amount = 2000;
else amount = 0;
amount_per_year = years_service / amount;
run;


Which one of the following values does the variable AMOUNT_PER_YEAR contain if an employee has been with the company for one year?


 :
1. 0
2. 1000
 3. Access Mostly Uused Products by 50000+ Subscribers
4. . (missing numeric value)


Question :

Which of the following statements is not true for list inputs?

 :
1. Fields cannot be skipped or re-read
2. Fields are read from left to right
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The MISSOVER option must be used at all times to read missing values


Question :

Each data set has a descriptive portion providing useful information about
the data set. Which of the following items would not be found in the
descriptive portion?


 :
1. Creation data and time
2. Set name
 3. Access Mostly Uused Products by 50000+ Subscribers
4. Error messages


Question :

Which location pointer identifies the exact line number from which to begin
reading data from?


 :
1. #n pointer
2. input pointer
 3. Access Mostly Uused Products by 50000+ Subscribers
4. Column pointer


Question :

The following SAS program is submitted:


proc format;
value score
1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;


proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;


The variable EXAM has a value of 50.5.


How will the EXAM variable value be displayed in the REPORT procedure output?



 :
1. Fail
2. Pass
 3. Access Mostly Uused Products by 50000+ Subscribers
4. . (missing numeric value)