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

Question : Following output can be generated using which of the following procedure


A. proc means data=course2017 ;
class course_name;
run;

B. proc summary data=course2017 print ;
class course_name;
run;

C. proc means data=course2017 noprint ;
class course_name;
run;

D. proc summary data=course2017 noprint;
class course_name;
run;


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

Correct Answer : Get Lastest Questions and Answer :
Explanation: You can use either summary or means procedure to generate descriptive statistics. Only difference is that in summary procedure
you have to use print option to generate the output. Other two options are not correct.




Question : You have been given a SAS data set with the name of HESAMPLE which contains various columns including Numeric and character, when you use
this data set in FREQ proc which of the statement will be true?


1. It will generate freq only for numeric values

2. It will generate freq only for character variables

3. Access Mostly Uused Products by 50000+ Subscribers

4. By default it will not generate freq for any variable/


Correct Answer : Get Lastest Questions and Answer :
Explanation: By default freq proc will generate frequency for all the variables it does not matter whether it is numeric or character based.




Question : You have been asked to apply frequency analysis of some data, now you need to select the variables which is best fit for frequency analysis
which variable you will be choosing.


1. Numerical Value column only

2. Column which has unique value only

3. Access Mostly Uused Products by 50000+ Subscribers

4. Column which has Categorical values


Correct Answer : Get Lastest Questions and Answer :
Explanation: Whenever you want to do frequency analysis of the data than you should choose the categorical data. There is no point of doing
frequency analysis for the unique and continuous values. Any categorical data is fine whether it is numeric or character based does not matter.

Related Questions

---

Question :
The SAS program is submitted:

The SAS data set WORK.SALARY is currently ordered by Gender within Department.
Which inserted
code will accumulate subtotals for each Gender within Department?

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



Question :
Which step displays a listing of all the data sets in the WORK library?

1. proc contents lib=WORK
run;
2. proc contents lib=WORK.all;
run;
3. Access Mostly Uused Products by 50000+ Subscribers
run;
4. proc contents data=WORK _ALL_;
run;



Question :
Given the SAS data set WORK.ORDERS:

The variable order_id is numeric;
customer is character; and shipped is numeric,
contains a SAS date
value, and is shown with the DATE9. format.
A programmer would like to create a new variable,
ship_note, that shows a character value with
the order_id, shipped date, and customer name. For
example, given the first observation ship_note
would have the value "Order 9341 shipped on 02FEB2009
to Josh Martin".
Which of the following statement will
correctly create the value and assign it to ship_note?


1. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
2. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
3. Access Mostly Uused Products by 50000+ Subscribers
4. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);


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)


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.


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.