Premium

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



Question :

The SAS data set named COMPANY.PRICES is listed below:

COMPANY.PRICES

prodid price producttype sales returns

K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2

The following SAS program is submitted:

libname company 'SAS-data-library';
data hware inter soft;
set company.prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;

How many observations does the HWARE data set contain?


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

Correct Answer : Get Lastest Questions and Answer :

Explanation: The if price le 5.00; limits the obs to the below obs out of which HARDWARE has two obs.
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
DGTY23 4.55 HARDWARE 67 2




Question :

The following SAS program is submitted:

proc datasets lib = sasuser;
contents data = class varnum;
quit;

Which one of the following is the purpose of the VARNUM option?
:
1. to print a list of variable names
2. to print the total number of variables
 3. Access Mostly Uused Products by 50000+ Subscribers
4. to print a list of the variables in the order they were created

Correct Answer : Get Lastest Questions and Answer :

Exp: Print a list of the variables by their position in the data set. By default, the CONTENTS statement lists the variables alphabetical





Question :

The following SAS program is submitted:

data work.accounting;
set work.department;
length jobcode $ 12;
jobcode='FAl';
run;

The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5.
What is the result?

:
1. The length of the variable JOBCODE is 3
2. The length of the variable JOBCODE is 5.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.


Correct Answer : Get Lastest Questions and Answer :


Explanation: The program fails to execute due to errors.


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

 : You have been given below dataset as with the fileref as hadoopexam
1. infile hadoopexam;

2. infile hadoopexam أ;

3. Access Mostly Uused Products by 50000+ Subscribers

4. infile hadoopexam dlm=#;



Question : You have been given below rawfile



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

 : You have been given below rawfile
1. A

2. B

 3. Access Mostly Uused Products by 50000+ Subscribers

4. D



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;

 : You have been given below raw data
1. A




2. B



 3. Access Mostly Uused Products by 50000+ Subscribers



4. D




Question : You have been given following value



Then which of the format you should use to read this data

 : You have been given following value
1. Column

2. Formatted

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Modified List



Question : You have been given below values with fields in each record.



Which of the following can be used to read data .

: You have been given below values with fields in each record.
1. length course_name $ 16;
input course_name & FEE1: comma7. FEE2 : comma7. FEE3: comma7. FEE4 : comma7. ;


2. input course_name & FEE1: comma7. FEE2 : comma7. FEE3: comma7. FEE4 : comma7. ;


3. Access Mostly Uused Products by 50000+ Subscribers


4. length course_name $ 16;
input course_name & FEE1-FEE4 : comma7. ;




Question : You have been given below dataset in a file course.txt,



Which of the given program correctly reads this files.

A.
filename course22 '/folders/myfolders/hedata/course22.txt';
data data23;
infile course22 MISSOVER ;
input ID $1-3 IDnum $4-11 @13 Fee comma8. LOCATION $ 22-35;
run;
B.

filename course22 '/folders/myfolders/hedata/course22.txt';
data data23;
infile course22;
input ID $1-3 IDnum $4-11 @13 Fee comma8. LOCATION $ 22-35;
run;
C.
filename course22 '/folders/myfolders/hedata/course22.txt';
data data23;
infile course22 MISSOVER ;
input ID $1-3 IDnum @13 Fee comma8. LOCATION;
run;


D.
filename course22 '/folders/myfolders/hedata/course22.txt';
data data23;
infile course22 MISSOVER ;
input @1 ID +3 IDnum $4-11 @13 Fee comma8. LOCATION $ 22-35;
run;

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