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

Question :
Given the following code:
proc print data=SASHELP.CLASS(firstobs=5 obs=15);
where Sex='M';
run;
How many observations will be displayed?


1. 11
2. 15
3. Access Mostly Uused Products by 50000+ Subscribers
4. 11 or fewer

Correct Answer : Get Lastest Questions and Answer :

Explanation:




Question :
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently
ordered by Department. The SAS program is submitted (left image):

Which statement is true?


1. The by statement in the DATA step causes a syntax error.
2. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.

Correct Answer : Get Lastest Questions and Answer :

Explanation:




Question :
Given the contents of the raw data file TYPECOLOR.DAT: (left image)

What are the values of the variables Type and Color?


1. Type=daisy, Color=yellow
2. Type=daisy, Color=w
3. Access Mostly Uused Products by 50000+ Subscribers
4. Type=daisy, Color=

Correct Answer : Get Lastest Questions and Answer :

Explanation:

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



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%';


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


Question : How many observations are in data set WORK.ALL after submitting the program?


1. 1
2. 2
3. Access Mostly Uused Products by 50000+ Subscribers
4. 5


Question :
The following program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

1. The output contains only a list of the SAS data sets that are contained in the WORK library.
2. The output displays only the contents of the SAS data sets that are contained in the WORK library.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.


Question :

The following program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?



1. The descending option applies to the variable Code.
2. The variable Code is sorted by ascending order.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The descending option applies to the Date and Cost variables.