Premium

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



Question : The following SAS program is submitted:

proc means data = sasuser.shoes;
where product in ('Sandal' , 'Slipper' , 'Boot');
run;
Which one of the following ODS statements completes the program and sends the report to an HTML file?

: The following SAS program is submitted:
1. ods html = 'sales.html';
2. ods file = 'sales.html';
 3. Access Mostly Uused Products by 50000+ Subscribers
4. ods html file = 'sales.html';


Correct Answer : Get Lastest Questions and Answer :
Exp: Sending output to a .html file

Just as it can generate a .pdf file, the Output Delivery System (ods) can generate .html files for SAS output. Again, we run a regression model separately for each of the four race
categories in our data. Before running our regression, we open a .html file to which output is written. When we are done, we close the .html file.

ods html file = 'd:\body1.html';
proc reg data = hsb2;
by race;
model write = female read;
run;
quit;
ods html close;




Question :

The following SAS program is submitted:
proc format;
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?

:
1. Fail
2. Pass
 3. Access Mostly Uused Products by 50000+ Subscribers
4. . (missing numeric value)

Correct Answer : Get Lastest Questions and Answer :
Answer is 50.5
Bcause that value in between Fail( less than 50) and Pass( greater than 51) Conditions
try this ..


proc format;
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;

data courses;
exam = 50.5;
run;

proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;




Question :

The following SAS program is submitted:
options pageno = 1;
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
The report created by the PRINT procedure step generates 5 pages of output.
What is the page number on the first page of the report generated by the MEANS procedure step?

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

Correct Answer : Get Lastest Questions and Answer :
pagno=6 because proc print write 5 pages output.and after that proc means will write where..?obviously on page no =6;
Print procedure generates 5 pages output, output means procedure starts page 6.


Related Questions

Question : What happens when you run the following program?
proc sort data=work.newcourses;
run;

proc print data=work.newcourses;
var ID COURSENAME FEE;
where Fee=5000;
run;

 : What happens when you run the following program?
1. PROC PRINT Step will run and print the result in sorted order.

2. PROC SORT Step will permanently sort the given data

3. Access Mostly Uused Products by 50000+ Subscribers

4. PROC Sort step will run successfully, PROC PRINT step generates the error.



Question : You will be running below program
proc sort data=hetrain.helr1 out=work.helr2;
by FEE ID ;
run;

proc print data=work.helr2 noobs;
var ID DATE LOCATION FEE ;
sum FEE DATE;
format FEE DOLLAR9.;
label DATE='Start On' LOCATION='Training Venue';
run;



What is the output will be generated


 : You will be running below program
1.
image1

2.
image2
 3. Access Mostly Uused Products by 50000+ Subscribers
image3

4.
image4



Question : You have to write a program such that following conditions are met
1. Course fee is less than or equal to $4000
2. The course id is 1 or course name is Ů“park

 : You have to write a program such that following conditions are met
1. where fee <= 4000 and
id=1 or name='Spark';


2. where (fee le 4000 and id=1)
or name='Spark';


 3. Access Mostly Uused Products by 50000+ Subscribers
and (id=1 or name eq 'Spark');



4. where fee <= 4000 or id=1
and name='Spark';



Question : Which of the following statement is correct?
 : Which of the following statement is correct?
1. When you use PROC PRINT, you need to provide specific variables. As by default it cannot create any report.

2. Using PROC PRINT statement you can print all the ROWS and COLUMNS which exists in dataset. However, you can request more sample data
to be extracted if required.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. PROC PRINT displays all observations and variables in the dataset, a column for observation numbers will be first left. Variable
will be printed in the same order in which they are stored with the dataset.



Question :

Select the DO WHILE statement that would generate the same result as the program below.

data work.hadoopdata;
hadoopprice=100000;
do until(hadoopprice gt 500000);
Year+1;
hadoopprice+(hadoopprice*.10);
end;
run;

 :
1. do while(hadoopprice ge 500000);
2. do while(hadoopprice=500000);
 3. Access Mostly Uused Products by 50000+ Subscribers
4. do while(hadoopprice>500000);


Question : Which of the following statement correctly creates a fileref allhecrs
 : Which of the following statement correctly creates a fileref allhecrs
1. libname allhecrs '/folders/myfolders/hedata/hecourses2017t.dat';

2. file allhecrs '/folders/myfolders/hedata/hecourses2017t.dat';

 3. Access Mostly Uused Products by 50000+ Subscribers

4. filename allhecrs '/folders/myfolders/hedata/hecourses2017t.dat';