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

Question :
The following SAS program is submitted:
What is the initial value of the variable Total in the following program?

1. 0
2. Missing
3. Access Mostly Uused Products by 50000+ Subscribers
4. Cannot be determined from the information given


Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :
Consider the following data step:
data WORK.NEW;
set WORK.OLD;
Count+1;
run;
The varaible Count is created using a sum statement. Which statement regarding this variable is true?

1. It is assigned a value 0 when the data step begins execution.
2. It is assigned a value of missing when the data step begins execution.
3. Access Mostly Uused Products by 50000+ Subscribers
4. It is assigned a value of missing at compile time.


Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable
CountryFee with a format of 7.;
The following SAS program is submitted:

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

1. LocalFee has format of 9. and CountryFee has a format of 7.
2. LocalFee has format of 9. and CountryFee has a format of percent7.2
3. Access Mostly Uused Products by 50000+ Subscribers
4. The data step fails execution; there is no format for LocalFee.

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :

The following SAS program is submitted:
data work.new;
length word $7;
amount = 7;
if amount = 5 then word = 'CAT';
else if amount = 7 then word = 'DOG';
else word = 'NONE!!!';
amount = 5;
run;
Which one of the following represents the values of the AMOUNT and WORD variables?


1. amount word
5 DOG
2. amount word
5 CAT
3. Access Mostly Uused Products by 50000+ Subscribers
7 DOG
4. amount word
7 ' ' (missing character value)


Question :

When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;
How many observations are processed by each procedure?


1. 400 for PROC PRINT
4500 for PROC MEANS
2. 401 for PROC PRINT
4501 for PROC MEANS
3. Access Mostly Uused Products by 50000+ Subscribers
4500 for PROC MEANS
4. 500 for PROC PRINT
5000 for PROC MEANS


Question :

In the following SAS program, the input data files are sorted by the NAMES variable:
libname temp 'SAS-data-library';
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
Which one of the following results occurs when this program is submitted?



1. The program executes successfully and a temporary SAS data set is created.
2. The program executes successfully and a permanent SAS data set is created.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.


Question :

Which programming statement is used to perform conditional processing on
groups of SAS statements?



1. DO
2. BY
3. Access Mostly Uused Products by 50000+ Subscribers
4. IF/THEN


Question :

The following SAS program is submitted:


data test;
set sasuser.employees;
if 2 le years_service le 10 then amount = 1000;
else if years_service gt 10 then amount = 2000;
else amount = 0;
amount_per_year = years_service / amount;
run;


Which one of the following values does the variable AMOUNT_PER_YEAR contain if an employee has been with the company for one year?



1. 0
2. 1000
3. Access Mostly Uused Products by 50000+ Subscribers
4. . (missing numeric value)


Question :

Which of the following statements is not true for list inputs?


1. Fields cannot be skipped or re-read
2. Fields are read from left to right
3. Access Mostly Uused Products by 50000+ Subscribers
4. The MISSOVER option must be used at all times to read missing values