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

Question : You have been given below dataset as with the fileref as hadoopexam

Which of the following statement is correct to read these values.

1. infile hadoopexam;

2. infile hadoopexam أ;

3. Access Mostly Uused Products by 50000+ Subscribers

4. infile hadoopexam dlm=#;

Correct Answer : Get Lastest Questions and Answer :
Explanation: As we can see that Infile statement is correct. But we need to see that how the values are delimited , they are separated by #
symbol, so we need to use dlm option like dlm=#

Question : You have been given below rawfile

In which of the following option we can use MISSOVER option?

1. A

2. B

3. Access Mostly Uused Products by 50000+ Subscribers

4. D

Correct Answer : Get Lastest Questions and Answer :
Explanation: Missover option can only be used when values are missing at the end of records. If values missing in between than missover is
not helpful.

Question : You have been given below raw data

Which of the following program correctly read given data

A.
filename course42 '/folders/myfolders/hedata/course42.txt';

data data42;
infile course42;
input
@1 course_name $ 7. @8 FEE1: comma7. @16 COURSE_DATE : date9. @25 DISCOUNT: comma7. LOCATION $ DURATION ;
run;

B.
filename course42 '/folders/myfolders/hedata/course42.txt';

data data42;
infile course42;
input
course_name $ 7. FEE1: comma7. COURSE_DATE : date9. DISCOUNT: comma7. LOCATION $ DURATION ;
run;

C.
filename course42 '/folders/myfolders/hedata/course42.txt';

data data42;
infile course42;
input
course_name $ 7. FEE1: comma7. COURSE_DATE : date9. @25 DISCOUNT: comma7. LOCATION $ DURATION ;
run;

D.
data '/folders/myfolders/hedata/course42.txt';
infile course42;
input
course_name $ 7. FEE1: comma7. COURSE_DATE : date9. @25 DISCOUNT: comma7. LOCATION $ DURATION ;
run;

1. A

2. B

3. Access Mostly Uused Products by 50000+ Subscribers

4. D

Correct Answer : Get Lastest Questions and Answer :
Explanation: As we read data from the rawfile, we need to create fileref first. Once the fileref is created we need we need to use it in
data step. Option 4 is out. Now we can see that data is mixed format we need to use formatted, column and list format. As you can see in the data last
columns does not start at fixed location. Hence we need to use list input. So option 1 is correct. Column input start at position defined.

Related 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?

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.

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?

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.

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?

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

Question :

The following SAS program is submitted:
proc freq data = class;
tables gender * age / (insert option here);
run;
The following report is created:
The FREQ Procedure
Table of gender by age
Row Column
Gender age Frequency Percent Percent Percent
F 11 11 0.002 0.005 0.00
12 22 0.004 0.004 0.00
13 22 0.004 0.006 6.67
Total 55 0.0010 0.00
M 11 11 0.002 0.005 0.00
12 33 0.006 0.006 0,00
13 11 0.002 0.003 3.33
Total 55 0.001 0 0.00
Total 11 22 0.001 0 0.00
12 55 0.00 10 0.00
13 33 0.00 10 0.00
Total 10 10 0.00
Which option correctly completes the program and creates the report?

1. LIST
2. NOCOLS
3. Access Mostly Uused Products by 50000+ Subscribers
4. NOCROSSTAB

Question :

The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?

1. format salary comma11.2;
2. format salary dollar8.2;
3. Access Mostly Uused Products by 50000+ Subscribers
4. format salary comma8.2 dollar8.2;

Question :

Given the SAS data set EMPLOYEE INFO:
EMPLOYEE_INFO
IDNumber
Expenses
100.00
133.15
234.34
111.12
The following SAS program is submitted:
proc sort data = employee_info;
( insert BY statement here )
run;
Which BY statement completes the program and sorts the data sequentially by ascending expense
values within each ascending IDNUMBER value?

1. by Expenses IDNumber;
2. by IDNumber Expenses;
3. Access Mostly Uused Products by 50000+ Subscribers
4. by ascending IDNumber ascending Expenses;