Premium

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



Question : You have been using SAS program since quite long time and you are always using the SAS PUTLOG statements, in which case it is very helpful?

: You have been using SAS program since quite long time and you are always using the SAS PUTLOG statements, in which case it is very helpful?
1. Syntax Error

2. Semantic Errors

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Any of the above


Correct Answer : Get Lastest Questions and Answer :
Explanation: PUTLOG statement is good if you are facing the logical error and you can use it to debug various values during the SAS program
run. Logical errors means output generated is not as per your expectations.




Question : Which of the following code can generate below results?

: Which of the following code can generate below results?
1. proc print data=hetrain.helr1 noobs;
var ID DATE date8. LOCATION$ FEE;
label DATE='Start On' LOCATION='Training Venue';
where FEE>=4000;
run;


2. proc print data=hetrain.helr1;
var ID DATE date8. LOCATION$ FEE;
where FEE>=4000;
label DATE='Start On' LOCATION='Training Venue';
run;


 3. Access Mostly Uused Products by 50000+ Subscribers
id date;
var ID DATE LOCATION FEE;
label DATE='Start On' LOCATION='Training Venue';
where FEE>=4000;
format DATE date10.;
run;


4. proc print hetrain.helr1 noobs;
id date;
var ID DATE date8. LOCATION FEE;
where FEE>=4000;
run;


Correct Answer : Get Lastest Questions and Answer :
Explanation: Replacing with Custom ID: If you want your own id in output from the dataset, to identify an observation.
Both ID and VAR: You can have both id and var to select specific columns in output. If column appears in both id and var than it will be two times in
output.
Assigning Descriptive Label: You can assign up to 256 character long labels to table columns.





Question : Which group processing statement produced the PROC MEANS output shown in left ?

: Which group processing statement produced the PROC MEANS output shown in left ?
1. class sex survive;
2. class survive sex;
3. Access Mostly Uused Products by 50000+ Subscribers
4. by survive sex;




Correct Answer : Get Lastest Questions and Answer :

Explanation: A CLASS statement produces a single large table, whereas BY group processing creates a series of small tables. The order of the variables in the CLASS statement determines
their order in the output table.




Related Questions

Question : You have been given below two datasets


And you apply below program
data course100;
merge course101 course102 ;
by COURSE_ID;
run;

Which of the following statement is correct?

 : You have been given below two datasets
1. For all the same course_id LOCATION value of the first data set course101 will remain as it is and Location from Course102 will be
discarded.

2. For the same course_id , merged data set course100 will have missing LOCATION.

3. Access Mostly Uused Products by 50000+ Subscribers

4. Value of all the common columns for which course_id matches will be unpredictable.



Question : You have been given below dataset and program


data course100;
merge course101 (in=in_first rename=(DATE=TRAINING_DATE))
course102 (in=in_second rename=(DATE=REGISTRATION_DATE)) ;
by COURSE_ID;
if in_first=1 and in_second=1;
run;

Which of the following is a correct output?


 : You have been given below dataset and program
1.
Image1
2.
Image2
 3. Access Mostly Uused Products by 50000+ Subscribers
Image3
4. None of the above



Question : You have two datasets Course and Course both have the Fee column variables. However, you dont want that Fee column from first
dataset will be overwritten during match merge. How can you avoid that, select the correct SAS program?

 : You have two datasets Course and Course both have the Fee column variables. However, you dont want that Fee column from first
1. data course100;
merge course101 (in=FirstFee)
course102 ;
by COURSE_ID;
if in_first=1 and in_second=1;
run;


2. data course100;
merge course101 (rename=(FEE=TRAINING_FEE))
course102 (rename=(FEE=REGISTRATION_FEE)) ;
by COURSE_ID;
run;


 3. Access Mostly Uused Products by 50000+ Subscribers
merge course101 (out=(FEE=TRAINING_FEE))
course102 (out=(FEE=REGISTRATION_FEE)) ;
by COURSE_ID;
run;


4. Both 2 and 3 are correct



Question : You have been given below dataset

And program as below
data course100;
merge course101 (rename=(FEE=TRAINING_FEE))
course102 (rename=(FEE=REGISTRATION_FEE)) ;
by COURSE_ID;
run;

What is the expected once you run above program?

 : You have been given below dataset
1. All the observation which does not have same course_id in both the dataset will be discarded.

2. Merged output will be generated and FEE columns will be re-named in the output.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Program will generate error



Question : Which of the following statements is true regarding direct access of data sets?


 : Which of the following statements is true regarding direct access of data sets?
1. a
2. b
 3. Access Mostly Uused Products by 50000+ Subscribers
4. d

Ans : 1
Exp : Concatenating appends the observations from one data set to another data set. The new data set contains the total number of records from all input data sets, so b is incorrect.
All the variables from all the input data sets appear in the new data set, so c is incorrect.




Question : If you concatenate the data sets below in the order shown,
what is the value of Sale in observation 2 of the new data set?


: Which of the following statements is true regarding direct access of data sets?
1. missing
2. $30,000
 3. Access Mostly Uused Products by 50000+ Subscribers
4. you cannot concatenate these data sets

Ans : 1
Exp : The concatenated data sets are read sequentially, in the order in which they are listed in the SET statement. The second observation in Sales.Reps does not contain a value for
Sale, so a missing value appears for this variable. (Note that if you merge the data sets, the value of Sale for the second observation is $30,000.)




Question : You have been given below dataset

You run the below program

data course100 (drop=COURSE_ID);
merge course101 (in=in_first rename=(DATE=TRAINING_DATE))
course102 (drop=FEE in=in_second rename=(DATE=REGISTRATION_DATE)) ;
by COURSE_ID;
if in_first and in_second;
run;

What is the output?

: Which of the following statements is true regarding direct access of data sets?
1. Merged data will be generated wherever column name matches and course_id will be dropped.

2. In merged data DATE columns will not be renamed.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. In output only Fee column will be dropped.



Question : You have been given below datasets

Now you merge all these three datasets using course_id, what would be values of location column in 5th observation?

 : You have been given below datasets
1. MUMBAI

2. PUNE

 3. Access Mostly Uused Products by 50000+ Subscribers

4. HYDERABAD

5. CHENNAI