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

Question : While creating a user defined format, you are creating a format for the numeric values. However, you know in your dataset it is possible
some values are missing than you also want to give label to the missing values as well. So what keyword you will be using as part of PROC FORMAT VALUE
statement?


1. NULL

2. MISSING

3. Access Mostly Uused Products by 50000+ Subscribers

4. OTHER

5. UNKNOWN


Correct Answer : Get Lastest Questions and Answer :
Explanation: You have to use OTHER keyword in case of missing numeric values. LOW does not represent missing numeric value. There is no
values like MISSING, NULL and UNKNOWN.




Question : Which of the following statement is correct with regards to the FORMAT PROCEDURE?

1. When you use FORMAT as part of DATA step than FORMAT definition will be stored permanently with the data.

2. When you use FORMAT as part of PROC step than FORMAT definition will be stored permanently with the data.

3. Access Mostly Uused Products by 50000+ Subscribers

4. When you use FORMAT as part of PROC step than FORMAT definition will replace the existing label.


Correct Answer : Get Lastest Questions and Answer :
Explanation: When you use FORMAT as part of DATA step than FORMAT definition will be stored permanently with the data.




Question : You have created a format named HEFORMAT, when you want to apply this format to COURSE_NAME, what is the correct code syntax?


1. Format COURSE_NAEM HEFORMAT;

2. Format COURSE_NAEM HEFORMAT. ;

3. Access Mostly Uused Products by 50000+ Subscribers

4. Format COURSE_NAEM=HEFORMAT;


Correct Answer : Get Lastest Questions and Answer :
Explanation: You should have used period at the end of FORMAT name when you will be using this format

Related Questions

---

Question :

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



Question :
The following SAS program is submitted:
data WORK.DATE_INFO;
Day="01" ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?


1. the numeric value 0
2. the character value "01011960"
3. Access Mostly Uused Products by 50000+ Subscribers
4. the step will not compile because of the character argument in the mdy function.


Question :

The following SAS program is submitted:
data WORK.AUTHORS;
array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');
run;
What is the value of the second variable in the dataset WORK.AUTHORS?


1. Hemingway
2. Hemingwa
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program contains errors. No variables are created.


Question :
The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label
of "Open Date". Which SAS program temporarily replaces the label "Open Date" with the label "Starting
Date" in the output?


1. proc print data=SASUSER.HOUSES label;
label Open_Date "Starting Date";
run;
2. proc print data=SASUSER.HOUSES label;
label Open_Date="Starting Date";
run;
3. Access Mostly Uused Products by 50000+ Subscribers
label Open_Date="Starting Date";
run;
4. proc print data=SASUSER.HOUSES;
Open_Date="Starting Date";
run;


Question :
Consider the following data step:

In filtering the values of the variable X in data set WORK.OLD,
what value new value would be assigned
to X if its original value was a missing value?


1. X would get a value of 1.
2. X would get a value of 3.
3. Access Mostly Uused Products by 50000+ Subscribers
4. This step does not run because of syntax errors.



Question :
The following program is submitted:
Why does the program fail?

1. The PAGENO option is invalid in the OPTIONS statement.
2. The RUN statement is missing after the FORMAT procedure.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The LABEL option is missing from the PROC PRINT statement.