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

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;

Correct Answer : Get Lastest Questions and Answer :

Explanation:






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.


Correct Answer : Get Lastest Questions and Answer :

Explanation:






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.


Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :

The contents of two SAS data sets named EMPLOYEE and SALARY
are listed below. How many observation are in EMPLSAL dataset

data emplsal;
merge employee (in=ine) salary(in=ins);
by name;
if ine and ins;
run;
Choices are




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



Question :
Which of the following will occur when an EC2 instance in a VPC (Virtual Private Cloud) with an associated Elastic IP is stopped and started?


1. The Elastic IP will be dissociated from the instance
2. All data on instance-store devices will be lost
3. Access Mostly Uused Products by 50000+ Subscribers
4. The underlying host for the instance is changed


Question :

The following SAS program is submitted:
data numrecords;
infile 'file-specification';
input @1 patient $15.
relative $ 16-26 @;
if relative = 'children' then
input @54 diagnosis $15. @;
else if relative = 'parents' then
input @28 doctor $15.
clinic $ 44-53
@54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step during execution?



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


Question :

A raw data file is listed below:

RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

The following SAS program is submitted using the raw data file as input:

data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH';
input sqfeet bedrooms baths street $ price : dollar10.;
run;

How many observations will the output data set contain?


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


Question :

A raw data file is listed below:

RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

The following SAS program is submitted using the raw data file as input:

data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH' then
input sqfeet bedrooms baths street $ price : dollar10.;
run;
How many observations does the WORK.CONDO_RANCH data set contain?



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


Question :

The contents of the raw data file FURNITURE are listed below:
--------10-------20-------30
chair,,table
chair,couch,table

The following SAS program is submitted:
data stock;
infile 'furniture' dsd;
input item1 $ item2 $ item3 $;
run;
Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?


1. table
2. ,table
3. Access Mostly Uused Products by 50000+ Subscribers
4. ' ' (missing character value)