Premium

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



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

Correct Answer : Get Lastest Questions and Answer :

Explanation: Error messages are found in the program log, not the
descriptive portion of the data set.



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

Correct Answer : Get Lastest Questions and Answer :


Explanation: The #n pointer references the absolute number of the
line for moving the pointer to read data.






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)

Correct Answer : Get Lastest Questions and Answer :

Explanation: Values from 50 to 51 are not covered in the proc format range.



Related 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


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


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



Question : You have been given below dataset


Which of the style you will use to read the data?

 : You have been given below dataset
1. Column

2. Formatted

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Mixed



Question : You have been given below dataset named data.

And you need to generate data as below in a file called gen_course43.txt which of the following code segment is correct?

A.
data gen_course43.txt;
set data41;
file ' data41 dsd;
put course_name FEE1: comma7. FEE2 : comma7. FEE3: comma7. FEE4 : comma7.;
run;

B.
data _null_;
set data41;
file '/folders/myfolders/hedata/gen_course43.txt' dsd;
put course_name FEE1: comma7. FEE2 : comma7. FEE3: comma7. FEE4 : comma7.;
run;

C.
data _null_;
set data41;
file '/folders/myfolders/hedata/gen_course43.txt';
put course_name FEE1: comma7. FEE2 : comma7. FEE3: comma7. FEE4 : comma7.;
run;

D.
data _null_;
set data41;
file '/folders/myfolders/hedata/gen_course43.txt' dlm=;
put course_name FEE1: comma7. FEE2 : comma7. FEE3: comma7. FEE4 : comma7.;
run;

: You have been given below dataset named data.
1. A



2. B



 3. Access Mostly Uused Products by 50000+ Subscribers




4. D




Question : You have been given below raw data



You need to read it correctly which of the following code fragment is correct

 : You have been given below raw data
1.
filename course35 '/folders/myfolders/hedata/course35.txt';
data data35;
length course_name $ 16;
infile course35 ;
input course_name $ (Fee1-Fee4 ) (comma7.);


2.
filename course35 '/folders/myfolders/hedata/course35.txt';
data data35;
length course_name $ 16;
infile course35 ;
input course_name Fee1 : comma7. FEE2 : comma7. FEE3 : comma7. FEE4 : comma7. ;


 3. Access Mostly Uused Products by 50000+ Subscribers
filename course35 '/folders/myfolders/hedata/course35.txt';
data data35;
infile course35 ;
input course_name 16. (Fee1-Fee4 ) (comma7.);


4.
filename course35 '/folders/myfolders/hedata/course35.txt';
data data35;
infile course35 dlm=-;
input course_name $ (Fee1-Fee4 ) (comma7.);