Premium

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



Question : Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?
: Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?
1. non-missing numeric variable values only
2. missing numeric variable values and non-missing numeric variable values only
 3. Access Mostly Uused Products by 50000+ Subscribers
4. missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variablevalues

Correct Answer : Get Lastest Questions and Answer :

Explanation: : just verified it in SAS by running a program below:

data shoes;
input shoe_number val;
datalines;
6 2
7 .
8 4
9 8
;
proc means data = shoes;
run;

Below is the output where you can clearly see for variable val N is 3 not 4, so proc means only consider numeric non-missing values for that variable to calculate its statistics, so
answer is A.
Variable N Mean
---------------------------------
shoe_number 4 7.5000000
val 3 4.6666667
---------------------------------
proc means excluded the missing value of val and therefore computed the mean with 3 obs:(2+4+8)/3=4.66. SAS did not consider the missing value.
However, if we specify in the program an option to go with the means proc, the result willbe different.

proc means, and in general other SAS procedures that perform calculations, will not factor in missing values. However, you can specify for missing values to affect proc means by
using option MISSING.






Question : The following SAS program is submitted:
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;

run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700
RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550
SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650
TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950

Which of the following SAS statement(s) create(s) the report?

: The following SAS program is submitted:
1. id style;
2. id style;
var style bedrooms baths price;
 3. Access Mostly Uused Products by 50000+ Subscribers
by style;
var bedrooms baths price;
4. id style;
by style;
var style bedrooms baths price;

Correct Answer : Get Lastest Questions and Answer :

Explanation: C and D options are same only diff is that there is style variable in var... But, if the style variable is present in id statement, you don't have to mention it in var
statement, else you will get 2 style variable in the output, but since there is just 1 style column present ans is C and not D..



Question :

You have executed following SAS DATA step as on Monday, April 01, 2000:
data joiners;
set joinee;
join_date = today();
run;
Which one of the following is the value of the variable JOIN_DATE in the output data set?

:
1. This will be a character string with the value '04/01/2000'
2. This will be a character string with the value 'Monday, April 01, 2000'
 3. Access Mostly Uused Products by 50000+ Subscribers
4. This will be a numeric value 04252000, representing the SAS date for April 01, 2000

Correct Answer : Get Lastest Questions and Answer :


Explanation: Today's date is given in the SAS date form

The Ans is: the numeric value 14701

The TODAY function produces the current date in the form of a SAS date value, which is the number of days since January 1, 1960.


Related Questions

Question : You are planning to use commaw.d informat, which of the following data can be read using this format?

A. 9,99
B. $99.9
C. %99.9

 : You are planning to use commaw.d informat, which of the following data can be read using this format?
1. A,B,C
2. B,C,D
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,D


Question : You have been given below dataset


Which of the following is correct statement to read data as course_name and Fee, both value should be read as character

 : You have been given below dataset
1. Input +1 FEE $9 . @1 COURSE_NAME $8.

2. Input +6 FEE $9 . @1 COURSE_NAME $5.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Input @9 FEE $9 @1 COURSE_NAME $8.



Question : You have been given below dataset


Which of the following will correctly read column Fee as a numeric value ?

 : You have been given below dataset
1. Input @11 FEE $9;

2. Input @11 Fee 9.2.;

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Input @11 FEE comma9.2.;



Question : You have been given below dataset



Which of the following correctly read all three columns course_id, course_name and fee

A. INPUT @1 COURSE_ID $3. +1 COURSE_NAME $8. @14 FEE COMMA9.
B. INPUT COURSE_ID $3. +1 COURSE_NAME $8. @14 FEE COMMA9.
C. INPUT COURSE_ID $3. @4 COURSE_NAME $8. @14 FEE COMMA9.
D. INPUT COURSE_ID $3. +1 COURSE_NAME $8. +1 FEE COMMA9.


 : You have been given below dataset
1. A,B,C,D
2. B,C,D
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,D


Question : You have been given below dataset



For which of the dataset. You should have used PAD option to read data correctly using column input or formatted input?

 : You have been given below dataset
1. Image1
2. Image2
 3. Access Mostly Uused Products by 50000+ Subscribers
4. Image4


Question : You have been given below data


What is the format of this raw data?

 : You have been given below data
1. Fixed Column Format

2. Arranged Format

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Free format