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

Question : Whenver dates are given in the SAS dateset, SAS will read data from a fixed date , what is that fixed date?

1. January 1, 2000 for dates greater than 01 Jan 2000

2. January 1, 2001 for dates greater than 01 Jan 2001

3. Access Mostly Uused Products by 50000+ Subscribers

4. January 1, 1960 for any dates

5. January 1, 1000 for any dates


Correct Answer : Get Lastest Questions and Answer :
Explanation: Whnever SAS read the date field with correct format it will store number of days internally from the date January 1, 1960.




Question : Why SAS prefer to use SAS date values as numeric rather that text?


1. It can be easily converted from numeric to text.

2. SAS does not have to any special calculation while storing numeric data

3. Access Mostly Uused Products by 50000+ Subscribers

4. Date can be used for various calculations, hence storing them as numeric value will help.


Correct Answer : Get Lastest Questions and Answer :
Explanation: Compare to other programming language, SAS stores date values in numeric format. So that values can be easily used for various
date calculations like difference between two dates, adding date values etc.




Question : Which of the following statements are correct for SAS date values?


1. SAS automatically make the adjustment for day light savings on date values.

2. SAS automatically make the adjustment for leap years on date values.

3. Access Mostly Uused Products by 50000+ Subscribers

4. SAS automatically make the adjustment for Julian dates on date values.


Correct Answer : Get Lastest Questions and Answer :
Explanation: SAS does not automatically do the adjustment for the day light savings but for leap years they can do that.

Related Questions

---

Question : What is the purpose or the MISSOVER option on the INFILE statement?

1. It prevents SAS from loading a new record when the end of the current record is reached.
2. It enables SAS to scan the input data records until the character string that is specified in the
@`character-string' expression is round.
3. Access Mostly Uused Products by 50000+ Subscribers
input tine for all the variables in the statement.
4. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current
record without finding values for all variables in the statement.


Question : A user-defined format has been created using the FORMAT procedure. Where is it stored?


1. in a SAS catalog
2. in an external binary file
3. Access Mostly Uused Products by 50000+ Subscribers
4. in a SAS dataset in a permanent SAS data library



Question :The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile `file specification';
input num chars$;
run;
ONE
NUMCHAR
----------------
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?

1. NUM CHAR
1 77
2. NUM CHAR
1 23
3 23
3. Access Mostly Uused Products by 50000+ Subscribers
1 23
3 23
1 77
4. No output is generated.


Question : The following SAS program is submitted:
data work.retail;
cost = `20000';
total= .10* cost
run;
What is the result?

1. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.
2. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.


Question : Which program can be used to create the
output similar to shown in left?

1. proc means data=clinic.diabetes;
var age height weight;
class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
2. proc summary data=clinic.diabetes print;
var age height weight; class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
3. Access Mostly Uused Products by 50000+ Subscribers
var age height weight;
class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
4. Both a and b.


Question : You have been given a dataset named hetrain.helr , you have been using the PROC PRINT statement to print the dataset, with the labels.
However, labels are not stored in the dataset than which of the following is a correct statement PORC PRINT statement >


1. proc print data=hetrain.helr1 label;
label welcome='Welcome to HadoopExam Learning Resources';
run;


2. proc print data=hetrain.helr1;
label welcome='Welcome to HadoopExam Learning Resources';
run;


3. Access Mostly Uused Products by 50000+ Subscribers
run;


4. proc print hetrain.helr1 label;
run;