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

Question : The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?


1. proc print data=MYXLS.NORTH;
run;
2. proc print data=MYXLS.NORTH$;
run;
3. Access Mostly Uused Products by 50000+ Subscribers
run;
4. proc print data=MYXLS.'NORTH$'n;
run;


Correct Answer : Get Lastest Questions and Answer :

Explanation:




Question :

Given the data set WORK.EMPDATA:

Which one of the following where statements
would display observations with
job titles containing the
word 'Manager'?


1. where substr(Job_Title,(length(Job_Title)-6))='Manager';
2. where upcase(scan(Job_Title,-1,' '))='MANAGER';
3. Access Mostly Uused Products by 50000+ Subscribers
4. where Job_Title like '%Manager%';

Correct Answer : Get Lastest Questions and Answer :

Explanation:






Question :

The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?

1. the numeric value 0
2. the character value "01Jan1960"
3. Access Mostly Uused Products by 50000+ Subscribers
4. the code contains a syntax error and does not execute

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :

The SAS data set Employee_info is listed below.

employee bonus
2542 100.00
3612 133.15
2198 234.34
2198 111.12
The following SAS program is submitted:

proc sort data=employee_info;
(insert BY statement here)
run;

Which one of the following BY statements completes the program and sorts the data in sequential order bydescending bonus values within ascending employee values?



1. by descending bonus employee;
2. by employee bonus descending;
3. Access Mostly Uused Products by 50000+ Subscribers
4. by descending employee bonus;


Question :

Assume the SAS data set Sasuser.Houses has four numeric variables.
The following SAS program is submitted:

proc means data=sasuser.houses mean;
(insert statement(s) here)run;
The following report is produced:
Which of the following statement(s) create(s) this report?

1. class style;
2. var bedrooms baths;
3. Access Mostly Uused Products by 50000+ Subscribers
var bedrooms baths;
4. . var style;
class bedrooms baths;


Question :

The following SAS program is submitted:

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

The Work.Department SAS data set contains a character variable named jobcode with a length of 5. Which of the following is the length of the variable jobcode in the output data set?

1. 5
2. 8
3. Access Mostly Uused Products by 50000+ Subscribers
4. The value cannot be determined because the program fails to execute due to syntax errors.


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=



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


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.