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

Question :
The SAS program is submitted:

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

1. ' ' (missing character value)
2. Unknown
3. Access Mostly Uused Products by 50000+ Subscribers
4. SENIOR PILOT

Correct Answer : Get Lastest Questions and Answer :

Explanation:






Question :
Given the contents of the raw data file 'EMPLOYEE.TXT'

Which SAS informat correctly completes the program?


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

Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :
Given the SAS data set WORK.P2000:



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

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :

Which statement is true concerning the SAS automatic variable _ERROR_?

1. It cannot be used in an if/then condition.
2. It cannot be used in an assignment statement.
3. Access Mostly Uused Products by 50000+ Subscribers
4. It is automatically dropped.



Question :
Given the SAS data set WORK.TEMPS:

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



Question :
The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
label Jobcode='Job Description';
run;
Which statement is true about the output dataset?

1. The label of the variable Jobcode is Job (only the first word).
2. The label of the variable Jobcode is Job Desc (only the first 8 characters).
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors. Labels must be defined in a PROC step.



Question :

Which is a valid LIBNAME statement?


1. libname "_SAS_data_library_location_";
2. sasdata libname "_SAS_data_library_location_";
3. Access Mostly Uused Products by 50000+ Subscribers
4. libname sasdata sas "_SAS_data_library_location_";


Question :

The following output is created by the FREQUENCY procedure:
Which TABLES option(s) would be used to eliminate the
row and column counts and just see the
frequencies and percents?


1. norowcount nocolcount
2. freq percent
3. Access Mostly Uused Products by 50000+ Subscribers
4. nocounts


Question :

The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?


1. libname qtrdata 'qtr1.xls';
2. libname 'qtr1.xls' sheets=3;
1. libname jan feb mar 'qtr1.xls';
2. libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);