Premium

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



Question : You have been given below dataset



Which of the following correctly read all three columns course_id, course_name and fee

A. INPUT @1 COURSE_ID $3. +1 COURSE_NAME $8. @14 FEE COMMA9.
B. INPUT COURSE_ID $3. +1 COURSE_NAME $8. @14 FEE COMMA9.
C. INPUT COURSE_ID $3. @4 COURSE_NAME $8. @14 FEE COMMA9.
D. INPUT COURSE_ID $3. +1 COURSE_NAME $8. +1 FEE COMMA9.


: You have been given below dataset
1. A,B,C,D
2. B,C,D
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,D

Correct Answer : Get Lastest Questions and Answer :
Explanation: Here all the given option are correct. You can use pointer column to say at which column data starts. In this case COURSE_ID
start at @1 , course_name start at @4 and Fee starts at @14. Similarly you can use +n option to define how many blank spaces are there before other
field start in all the cases here +1 . And field width define for next position of the columns.




Question : You have been given below dataset



For which of the dataset. You should have used PAD option to read data correctly using column input or formatted input?

: You have been given below dataset
1. Image1
2. Image2
 3. Access Mostly Uused Products by 50000+ Subscribers
4. Image4

Correct Answer : Get Lastest Questions and Answer :
Explanation: You have to use PAD option while reading the data which has fixed columns and its width. But length of record varies. And PAD
option can only be applied if last fields width varies with the trailing column value is not present. Using PAD option will help you to create all the
lines in equal size by padding required blank space at the end of record.




Question : You have been given below data


What is the format of this raw data?

: You have been given below data
1. Fixed Column Format

2. Arranged Format

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Free format


Correct Answer : Get Lastest Questions and Answer :
Explanation: Given data is not in a fixed format, their column positions varies. So you can clearly say that this is a free format data.


Related Questions

Question : The following program is submitted:

data numrecords;
infile cards dlm=',';
input agent1 $ agent2 $ agent3 $;
cards;
jones,,brownjones,spencer,brown;
run;

What is the value for the variable named Agent2 in the second observation?


 : The following program is submitted:
1. brown
2. spencer
3. Access Mostly Uused Products by 50000+ Subscribers
4. There is no value because only one observation is created


Question :
1---+----10---+----20---+----30---+----40---+----50
TWOSTORY 1040 2 1SANDERS ROAD $55,850
CONDO 2150 4 2.5JEANS AVENUE $127,150
The following program is submitted using this file as input:

data work.houses;
infile 'file-specification';
(insert INPUT statement here)
run;
Which one of the option from left image, INPUT statements reads the raw data file correctly?

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


Question : The SAS data set Sasdata.Salesdata has ten observations. Which one of the following explains why a report fails to generate?

 : The SAS data set Sasdata.Salesdata has ten observations. Which one of the following explains why a report fails to generate?
1. The DATA step fails execution.
2. The SAS data set Sales does not exist.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The PRINT procedure contains a syntax error.



Question : The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?
 : The following SAS program is submitted:
1. a list of variable names
2. the total number of variables
 3. Access Mostly Uused Products by 50000+ Subscribers
4. a list of the variables in the order they were created



Question : The following SAS program is submitted:
data test;
set chemists;
itjobcode = `Chem2'
then description = `Senior Chemist';
else description = `Unknown';
run;
The value for the variable JOBCODE is:
JOBCODE
-------------
chem2
What is the value of the variable DESCRIPTION?

 : The following SAS program is submitted:
1. chem2
2. Unknown
 3. Access Mostly Uused Products by 50000+ Subscribers
4. '' (missing character value)


Question :

Given the AIRPLANES data set
AlRPLANES
TYPE MPG
-------- ------
F-18 105
C-130 25
Harrier 75
A-6 110
The following SAS program is submitted:
data gt100;
set airplanes(keep = type mpg load);
load = mpg * 150;
run;
The program fails to execute due to syntax errors.
What is the cause of the syntax error?

 :
1. MPG is not a numeric variable.
2. LOAD is not a variable in the data set GT100.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. LOAD must be defined prior to the SET statement.