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

Question :

An HTML file contains a SAS report. Which ODS statement option is used to specify the name of the HTML file?


1. OUT=
2. FILE=
3. Access Mostly Uused Products by 50000+ Subscribers
4. HTMLFILE=


Correct Answer : Get Lastest Questions and Answer :

Explanation: The FILE= option identifies the file that contains the HTML output. The FILE= option is
an alias for the BODY= option in the ODS HTML statement.





Question : The following SAS program is submitted:

data work.test;
set sasuser.class;
array t{3}
(insert text here)
(5, 10, 15);
run;

Which one of the following completes the ARRAY statement and creates data elements that are not included in the SAS data set Work.Test?

1. _DROP_
2. _TEMP_
3. Access Mostly Uused Products by 50000+ Subscribers
4. Noextratextisneeded

Correct Answer : Get Lastest Questions and Answer :

Explanation: _TEMPORARY_ is a keyword used in the ARRAY statement to create temporary data elements. By default, the ARRAY statement creates new data set variables or references existing
variables for use by the array.




Question : A raw data file is listed below.

1---+----10---+----20---+---
01/05/1989 Frank 11
12/25/1987 June 13
01/05/1991 Sally 9
The following SAS program is submitted using the raw data file as input:

data work.family;
infile 'file-specification';
input @1 date_of_birth mmddyy10. @15 first_name $5. @25 age 3;
run;

proc print data=work.family noobs;
run;
Which one of the following is the result?


1. The program executes, but the age values are missing in the output.
2. The program executes, but the date values are missing in the output.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute because the date informat is coded incorrectly.


Correct Answer : Get Lastest Questions and Answer :

Explanation: Values for the variable age are missing in the output because the informat for age is coded incorrectly. Since age is standard numeric input, it should use the w.d informat to
specify a field width of 3 in the INPUT statement. 3 did not write about

Related Questions

---

Question : Which of the variable declaration increase the value of the variable named fee with the %?


1. Fee= fee*100;

2. Fee= fee+(fee*2);

3. Access Mostly Uused Products by 50000+ Subscribers

4. Fee=*2;



Question : The following SAS program is submitted:

data test;
infile `file specification';
input name $ amount@@;
run;

Which of the following is true?

1. Two @@ together are the same as one c
2. Two @@ hold the data records until the bottom of the DATA step.
3. Access Mostly Uused Products by 50000+ Subscribers
4. Two @@ are invalid syntax and will cause the program to fail to execute.


Question :

Which SAS statement correctly uses column input to read
the values in the raw data file below in this order: Address
(4th field), SquareFeet (second field), Style (first field),
Bedrooms (third field)?



1. input Address 15-29 SquareFeet 8-11 Style 1-6
Bedrooms 13;
2. input $ 15-29 Address 8-11 SquareFeet $ 1-6 Style
13 Bedrooms;
3. Access Mostly Uused Products by 50000+ Subscribers
Bedrooms 13;
4. input Address 15-29 $ SquareFeet 8-11 Style 1-6
$ Bedrooms 13;


Question : Select the correct statement which is not an advantage of column input, while Reading Raw Data with the INPUT Statement?


1. It can be used to read character variables that contain embedded blanks
2. No placeholder is required for missing data.
3. Access Mostly Uused Products by 50000+ Subscribers
4. Fields do not have to be separated by blanks or other delimiters


Question : Which of the following program correctly reads the instream data



1. A
2. B
3. Access Mostly Uused Products by 50000+ Subscribers


Question : You have been given below dataset

You need to process the dataset which has either MUMBAI or AHMEDABAD as a location and fee is higher than 500, which of the following statement is
correct for this?


1. if fee=5000 and location NOT in ('MUMBAI' ,'AHMEDABAD');

2. if fee>=5000 and location AND ('MUMBAI' ,'AHMEDABAD');

3. Access Mostly Uused Products by 50000+ Subscribers

4. if fee>5000 OR location OR ('MUMBAI' ,'AHMEDABAD');