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

Question :
After a SAS program is submitted, the following is written to the SAS log:
105 data WORK.JANUARY;
106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);
107 if Month='JAN' then output WORK.JANUARY;
108 Sales=Cost * Quantity;
109 drop=Month Quantity Cost;
-----
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, , *, **, +, -,
, , =, >, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What data set option could be attached to WORK.JANUARY to replace the DROP statement that
generated the error in the log?



1. (drop Month Quantity Cost)
2. (drop Month, Quantity, Cost)
3. Access Mostly Uused Products by 50000+ Subscribers
4. (drop=Month Quantity Cost)

Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :
Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a
RETAIN statement and an Assignment statement. Which statement regarding this program is true?

1. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
2. Both the RETAIN and assignment statement are being used to initialize new variables and
are equally efficient. Method used is a matter of programmer preference.
3. Access Mostly Uused Products by 50000+ Subscribers
statement has been omitted.
4. City's value will be assigned one time, State's value 5 times.

Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :
Given the SAS data set WORK.ONE:

What value will SAS assign to Total?


1. 3
2. 1.6
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

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.


Question : The following code was modified to
generate the results further below:

proc format;
value agegrp
low-12 ='Pre-Teen'
13-high = 'Teen';
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display
only specific statistics and limit the decimals with the
modification: Which statement below was
modified or added to generate the results above:

1. var Height / nobs min max mean maxdec=1;
2. proc means data=SASHELP.CLASS maxdec=1 ;
3. Access Mostly Uused Products by 50000+ Subscribers
4. output nobs min max mean maxdec=1;



Question :

The following SAS program is submitted:

What types of variables are DayOfMonth, MonthOfYear, and Year?

1. DayOfMonth, Year, and MonthOfYear are character.
2. DayOfMonth, Year, and MonthOfYear are numeric.
3. Access Mostly Uused Products by 50000+ Subscribers
4. DayOfMonth, Year, and MonthOfYear are date values.


Question :

The following SAS program is submitted:
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?

1. 2 temporary and 1 permanent SAS data sets are created
2. 3 temporary and 2 permanent SAS data sets are created
3. Access Mostly Uused Products by 50000+ Subscribers
4. there is an error and no new data sets are created