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

Question :

The following SAS program is submitted:

What is produced as output?


1. A file named test.cvs that can only be opened in Excel.
2. A text file named test.cvs that can be opened in Excel or in any text editor.
3. Access Mostly Uused Products by 50000+ Subscribers
4. A file named test.cvs that can only be opened by SAS.

Correct Answer : Get Lastest Questions and Answer :

Explanation:






Question :

You're attempting to
read a raw data file
and you see the following
messages displayed
in the SAS Log:
What does it mean?


1. A compiler error, triggered by an invalid character for the variable Salary.
2. An execution error, triggered by an invalid character for the variable Salary.
3. Access Mostly Uused Products by 50000+ Subscribers
4. An error on the INPUT statement specification for reading the variable Salary.

Correct Answer : Get Lastest Questions and Answer :

Explanation:






Question :

The following SAS program is submitted:


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 :
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
Which one of the following represents how many observations the WORK.TOTAL data set contains?


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



Question :
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set named WORK.SALARY contains 10 observations for each department, currently ordered by DEPARTMENT.
Which one of the following is true regarding the program above?


1. The BY statement in the DATA step causes a syntax error.
2. FIRST.DEPARTMENT and LAST.DEPARTMENT are variables in the WORK.TOTAL data set.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORK.SALARY data set.



Question :
The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists (keep = job_code);
if job_code = 'chem3'
then description = 'Senior Chemist';
run;
The variable JOB_CODE is a character variable with a length of 6 bytes.
Which one of the following is the length of the variable DESCRIPTION in the output data set?



1. 6 bytes
2. 8 bytes
3. Access Mostly Uused Products by 50000+ Subscribers
4. 200 bytes



Question :
The following SAS program is submitted:
data work.accounting;
set work.dept1 work.dept2;
run;
A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable
JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.
Which one of the following is the length of the variable JOBCODE in the output data set?


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



Question :
The following SAS DATA step is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5.
Which one of the following is the length of the variable JOBCODE in the output data set?



1. 5
2. 8
3. Access Mostly Uused Products by 50000+ Subscribers
4. The length can not be determined as the program fails to execute due to errors.


Question :
Which one of the following SAS statements renames two variables?


1. set work.dept1
work.dept2(rename = (jcode = jobcode)
(sal = salary));
2. set work.dept1
work.dept2(rename = (jcode = jobcode
sal = salary));
3. Access Mostly Uused Products by 50000+ Subscribers
work.dept2(rename = jcode = jobcode
sal = salary);
4. set work.dept1
work.dept2(rename = (jcode jobcode)
(sal salary));