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

Question : Which one of the following SAS system options displays the time on a report?

1. TIME
2. DATE
3. Access Mostly Uused Products by 50000+ Subscribers
4. DATETIME

Correct Answer : Get Lastest Questions and Answer :

Explanation: the questions is related to displaying time on report not to reads or write a date. So, you need to use date is in sas systeme option. here an example:
options date pageno=1;
proc print data=test.example;
run;
so you will get date on your printed report. if you don't need to display a date put nodate instead date






Question : Which one of the following SAS system options prevents the page number from appearing on a report?

1. NONUM
2. NOPAGE
3. Access Mostly Uused Products by 50000+ Subscribers
4. NOPAGENUM

Correct Answer : Get Lastest Questions and Answer :

Explanation: Syntax
NUMBER | NONUMBER
Syntax Description
NUMBER
specifies that SAS print the page number on the first title line of each page of SAS output.
NONUMBER
specifies that SAS not print the page number on the first title line of each page of SAS output.







Question : The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?

1. Add the option MAXDEC = 2 to the MEANS procedure statement.
2. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
3. Access Mostly Uused Products by 50000+ Subscribers
4. Add the option FORMAT = 7.2 option to the MEANS procedure statement.

Correct Answer : Get Lastest Questions and Answer :

Explanation: Other commonly used options available in PROC MEANS include:

o DATA= Specify data set to use
o NOPRINT Do not print output
o MAXDEC=n Use n decimal places to print output

So the Answer is 1

Related Questions

---

Question : You have been given below program

data PREDICTED (drop=WEIGHT index );
set User ;
array month_{6} xxxx (1,2,3,4,5,6) ;
array weigh_{6} ;
EXISTING_WEIGHT=WEIGHT;
do index=1 to dim(month_);

put _all_;
weigh_{index}=month_{index}+WEIGHT+WEIGHT*.02;
WEIGHT=weigh_{index}

end;
run;

proc print data=PREDICTED;run;

What value you will put in place of xxxx , so that all month_ variable become temporary and will not be part of output?


1. _temporary_

2. temporary

3. Access Mostly Uused Products by 50000+ Subscribers

4. missing

5. blank space



Question : You have been given below dataset



Which of the following will correctly read the files.


1. input ID $1-3 IDnum $4-11 @13 Fee comma8. LOCATION $ 22-35;

2. input ID 1-3 $ IDnum 4-11 $ @13 Fee comma8. LOCATION 22-35 $;

3. Access Mostly Uused Products by 50000+ Subscribers

4. input ID 1-3 IDnum 4-11 @13 Fee comma8. LOCATION 22-35;




Question : You have been given some data in a text file at below location and you tried to read it is using SAS column input.
filename course22 '/folders/myfolders/hedata/course22.txt;

Which of the following statements are correct with regards to column input?

A. If your datasets column has blank spaces than it can be read using column input.
B. If data is missing than it is not mandatory to have placeholder.
C. You can read either standard or non-standard values
D. It is not necessary that data stored in course22.txt file should be separated by either comma or space.


1. A,B,C
2. B,C,D
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,D


Question : You have been given below dataset which has training fee


Which of the fee can be considered as a standard numeric data for last column fee


1. Line-1

2. Line-2

3. Access Mostly Uused Products by 50000+ Subscribers

4. Line-4



Question : : You are working on Sales data and by looking at the data you have decided that you have to use formatted input, for which kind of data
you can use formatted input?


1. Standard Free Format Data

2. Standard data with fixed fields and length

3. Access Mostly Uused Products by 50000+ Subscribers

4. You can use it for both standard and non-standard data in fixed length.



Question : You have been given below dataset



Which of the following format can be used to read data from column 1-8 ?


1. w.

2. $w.

3. Access Mostly Uused Products by 50000+ Subscribers

4. Commaw.d