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

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_";

Correct Answer : Get Lastest Questions and Answer :







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

Correct Answer : Get Lastest Questions and Answer :







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);

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :

The following SAS program is submitted:
data work.test;
Title = 'A Tale of Two Cities, Charles J. Dickens';
Word = scan(title,3,' ,');
run;
Which one of the following is the value of the variable WORD in the output data set?


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


Question :

The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City_Country = substr(First,1,7)!!', '!!'England';
run;
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?



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


Question :
The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City = substr(First,1,7);
City_Country = City!!', '!!'England';
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?



1. Ipswich!!
2. Ipswich, England
3. Access Mostly Uused Products by 50000+ Subscribers
4. Ipswich , England


Question :
Which one of the following is true of the RETAIN statement in a SAS DATA step program?

1. It can be used to assign an initial value to _N_ .
2. It is only valid in conjunction with a SUM function.
3. Access Mostly Uused Products by 50000+ Subscribers
4. It adds the value of an expression to an accumulator variable and ignores missing values.


Question :
A raw data file is listed below:
--------10-------20-------30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted and references the raw data file above:
data coins;
infile 'file-specification';
input year quantity;

run;
Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last
observation of the output data set?


1. totquantity + quantity;
2. totquantity = sum(totquantity + quantity);
3. Access Mostly Uused Products by 50000+ Subscribers
sum totquantity;
4. retain totquantity 0;
totquantity = totquantity + quantity;



Question :
A raw data file is listed below:
--------10-------20-------30
squash 1.10
apples 2.25
juice 1.69
The following SAS program is submitted using the raw data file above:
data groceries;
infile 'file-specification';
input item $ cost;

run;
Which one of the following completes the program and produces a grand total for all COST values?



1. grandtot = sum cost;
2. grandtot = sum(grandtot,cost);
3. Access Mostly Uused Products by 50000+ Subscribers
grandtot = sum(grandtot,cost);
4. grandtot = sum(grandtot,cost);
output grandtot;