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

Question : Which of the following is correct way to store formats in the permanent catalog?

1. libname library '/folders/myfolders/hadoopexam';
proc format lib=library;
value location
1='Mumbai'
2='Pune'
3='Chennai';
run;


2. libname library '/folders/myfolders/hadoopexam';
format lib=library;
value location
1='Mumbai'
2='Pune'
3='Chennai';
run;


3. Access Mostly Uused Products by 50000+ Subscribers
proc format library;
value location
1='Mumbai'
2='Pune'
3='Chennai';
run;


4. libname library '/folders/myfolders/hadoopexam';
proc library;
value location
1='Mumbai'
2='Pune'
3='Chennai';
run;


Correct Answer : Get Lastest Questions and Answer :
Explanation: To store formats in a permanent catalog, you need to create a library pointing to a storage location and format catalog will be
stored there. And you can use either LIB= or LIBRARY= PROC FORMAT statement.




Question :
The following SAS program is submitted:
data combine;
prefix='505';
middle='6465 `;
end='09090';
(insert statement here)
run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-
09090?


1. total = cat('-', prefix, middle, end);
2. total = catx('-', prefix, middle, end);
3. Access Mostly Uused Products by 50000+ Subscribers
4. total = prefix!!'-'!! left(middle)!!'-'!! end;

Correct Answer : Get Lastest Questions and Answer :

Explanation:




Question :
The following SAS program is submitted:

(insert ODS statement here)

proc means data = sasuser.shoes;
where product in (`Sandal' , `Slipper' , `Boot');
run;

(insert ODS statement here)

Which ODS statements complete the program and send the report to an HTML file?


1. ods html = `sales.html'; ods html close;
2. ods file = `sales.html'; ods file close;
3. Access Mostly Uused Products by 50000+ Subscribers
4. ods html file = `sales.html'; ods html close;

Correct Answer : Get Lastest Questions and Answer :

Related Questions

---

Question :

The SAS data set named COMPANY.PRICES is listed below:

COMPANY.PRICES

prodid price producttype sales returns

K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2

The following SAS program is submitted:

libname company 'SAS-data-library';
data hware inter soft;
set company.prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;

How many observations does the HWARE data set contain?



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


Question :

The following SAS program is submitted:

proc datasets lib = sasuser;
contents data = class varnum;
quit;

Which one of the following is the purpose of the VARNUM option?

1. to print a list of variable names
2. to print the total number of variables
3. Access Mostly Uused Products by 50000+ Subscribers
4. to print a list of the variables in the order they were created


Question :

The following SAS program is submitted:

data work.accounting;
set work.department;
length jobcode $ 12;
jobcode='FAl';
run;

The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5.
What is the result?


1. The length of the variable JOBCODE is 3
2. The length of the variable JOBCODE is 5.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.



Question :

Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?


1. infile 'customer.txt' 1-10;
2. input 'customer.txt' stop@10;
3. Access Mostly Uused Products by 50000+ Subscribers
4. input 'customer.txt' stop=10;



Question :
The following SAS program is submitted:

What value will SAS assign to Pos?


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


Question :


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