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

Question : The following SAS program is submitted:
data work.test;
array agents{4} $ 12 sales1 - sales4;
run;
Which one of the following represents the variables that are contained in the output data set?

1. SALES1, SALES2, SALES3, SALES4
2. AGENTS1, AGENTS2, AGENTS3, AGENTS4
3. Access Mostly Uused Products by 50000+ Subscribers
4. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.

Correct Answer : Get Lastest Questions and Answer :
array named 'agents' is temporary but variables created by array sales1- sales4 are stored in dataset.
D is not correct, because we can define arrays for new variables to be created too.
If we dont't give dimentions 'Sales1-sales4' only then variable named agents1-agents 4 will be stored in output dataset.






Question : The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
Which one of the following represents the new variables that are created?

1. JANSALES, FEBSALES and MARSALES
2. MONTHLY1, MONTHLY2 and MONTHLY3
3. Access Mostly Uused Products by 50000+ Subscribers
4. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3

Correct Answer : Get Lastest Questions and Answer :
The reason is if you look at the set statement : 'set work.staff (keep = jansales febsales marsales);' jansales, febsales, marsales are variables you are bringing in. The array:
array diff_sales{3} difsales1 - difsales3;are the variables you want to create - since there is no other programming code to define the variables, SAS creates the variables the array
defines. Since these arrays are numeric, the variables created are also numeric.





Question : On which portion(s) of a SAS data set does the PRINT procedure report?


1. the data portion only
2. the descriptor portion only
3. Access Mostly Uused Products by 50000+ Subscribers
4. neither the data portion nor the descriptor portion

Correct Answer : Get Lastest Questions and Answer :
proc print only shows data portion of dataset and proc contents shows descriptor portion of a dataset.
there are two portion of a data set- descriptor and data portion.
the descriptor portion gives an insight into the data set and its variable attributes. whereas the data portion displays the data in listed column.

the descriptor portion of the data set can be viewed through 'proc content' and the data portion can be displayed through 'proc print'

Related Questions

---

Question : Which one of the following SAS system options displays the time on a report?

1. TIME
2. DATE
3. Access Mostly Uused Products by 50000+ Subscribers
4. DATETIME


Question : Which one of the following SAS system options prevents the page number from appearing on a report?

1. NONUM
2. NOPAGE
3. Access Mostly Uused Products by 50000+ Subscribers
4. NOPAGENUM


Question : The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?

1. Add the option MAXDEC = 2 to the MEANS procedure statement.
2. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
3. Access Mostly Uused Products by 50000+ Subscribers
4. Add the option FORMAT = 7.2 option to the MEANS procedure statement.


Question : 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


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?


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;


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