Premium

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



Question : You have been given a data set, which contains all the training courses provided by the HadoopExam.com, now you need to select particular
data which has only three courses in output which are Hadoop, SAS, and Spark. Which of the following is correct statement to select these specific
courses?

: You have been given a data set, which contains all the training courses provided by the HadoopExam.com, now you need to select particular
1. where courses='Hadoop' or 'SAS' or 'Spark';

2. where courses in 'Hadoop' or 'SAS' or 'Spark';

 3. Access Mostly Uused Products by 50000+ Subscribers

4. where courses in ('Hadoop','SAS','Spark');


Correct Answer : Get Lastest Questions and Answer :
Explanation: As you can see in the options only where condition is given and not the entire syntax. Hence, whenever you need to select
particular value or values from the dataset where statement is one of the solution. However, we need to apply where statement correctly
In option 4, we are correctly using the syntax with the IN operator. Here, IN operator will help you select the courses from dataset. Whenever you have
more than one values on which selection depends than you can use IN operator. Make sure values are in parenthesis and separated by comma as well if they
are character values then they should be individually enclosed by quotation mark. And values are case sensitive, hence it should be in the same case as
stored with the dataset.





Question : You have been given some dataset HETRAIN.HELR, now you need to sort this dataset and sorted data needs to be copied in new dataset named
NEWCOURSES. Which of the following is correct syntax?

: You have been given some dataset HETRAIN.HELR, now you need to sort this dataset and sorted data needs to be copied in new dataset named
1. proc sort data=work.newcourses out=hetrain.helr1;
run;


2. proc sort helr1 out=newcourses;
by name;
run;


 3. Access Mostly Uused Products by 50000+ Subscribers
by name;
run;


4. proc sort from hetrain.helr1 to newcourses;
by name;
run;


Correct Answer : Get Lastest Questions and Answer :
Explanation: Whenever you want to sort the data you should have used SORT PROCECURE. As per the sort syntax, you should try to create new
dataset whenever possible otherwise it will overwrite your existing dataset. Hence, DATA= is the dataset you want to sort. OUT= is the option to create
new sorted dataset. Also when you want to sort the data you need to provide on which column you want to sort the data. Here, in the given option it
would be sorted by name. So correct syntax is provided in Option 3




Question : Which of the following statement is correct when you want Date to appear on top of the page and output should not have page number defined?

: Which of the following statement is correct when you want Date to appear on top of the page and output should not have page number defined?
1. When you want DATE without page number in output use system option date and withoutnumber

2. When you want DATE without page number in output use system option date and withoutpagenumber

 3. Access Mostly Uused Products by 50000+ Subscribers

4. When you want DATE without page number in output use system option date and NONNUMBER


Correct Answer : Get Lastest Questions and Answer :
Explanation: You can provide system options as per your need. If you are running SAS university edition than try to download PDF output and
see the results.
options linesize=64 nocenter number date;
NUMBER
specifies that SAS print the page number on the first title line of each page of SAS output.
NONUMBER
specifies that SAS not print the page number on the first title line of each page of SAS output.
DATE
specifies that the date and the time that the SAS program started are printed at the top of each page of the SAS log and any output that is created by
SAS.
NODATE
specifies that the date and the time are not printed.

Some of the options example are below
NOCAPS Translate quoted strings and titles to upper case?
CENTER Center SAS output?
DATE Date printed in title?
ERRORS=20 Maximum number of observations with error messages
FIRSTOBS=1 First observation of each data set to be processed
FMTERR Treat missing format or informat as an error?
LABEL Allow procedures to use variable labels?
LINESIZE=96 Line size for printed output
MISSING=. Character printed to represent numeric missing values
NOTES Print SAS notes on log?
NUMBER Print page number on each page of SAS output?
OBS=MAX Number of last observation to be processed
PAGENO=1 Resets the current page number on the print file
PAGESIZE=54 Number of lines printed per page of output
PROBSIG=0 Number of significant figures guaranteed when printing P-values
REPLACE Allow replacement of permanent SAS data sets?
SOURCE List SAS source statements on log?
NOSOURCE2 List included SAS source statements on log?
YEARCUTOFF=1900 Cutoff year for DATE7. informat




Related Questions

Question : You have following array declaration
array Hadoop{xxxx} fee1-fee4;

What is the correct value for xxxx ?

A. 6:9
B. 4
C. 1-4
D. 0-4
E. 0:4

 : You have following array declaration
1. A,B
2. B,C
3. Access Mostly Uused Products by 50000+ Subscribers
4. D,E
5. A,E


Question : You have been given below SAS program

data course100;
set course101;
array fee{4} fee1 fee2 fee3 fee4;
array new_fee{4} nfee1 nfee2 nfee3 nfee4;

xxxxx
put _all_;
new_fee{index}=fee{index}+fee{index}*.10;
end;
run;

Replace xxxxx with the correct statement, so that all the defined array variables can be processed?

 : You have been given below SAS program
1. do index=1 to 4;

2. do index=0 to 4;

 3. Access Mostly Uused Products by 50000+ Subscribers

4. do until index= 4;



Question : You have defined below program

data course100;
set course101;
array fee{4} fee1 fee2 fee3 fee4;
array new_fee{4} nfee1 nfee2 nfee3 nfee4;

do index=1 to 4;
put _all_;
new_fee{index}=fee{index}+fee{index}*.10;
end;
run;

what is the index value which can point variable fee3 and nfee4

 : You have defined below program
1. 3 , 4

2. 4, 4

 3. Access Mostly Uused Products by 50000+ Subscribers

4. 4, 4



Question : You have been given below array declaration

array fee{4} fee1 fee2 fee3 fee4;

which of the following option correctly process all the variable declared in array ?

A. do i=1 to dim(fee);
B. do i=1 to dim(*);
C. do i=1,2,3,4;
D. do i=1 to 4;

 : You have been given below array declaration
1. A,B,C
2. B,C,D
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,D


Question : You have similar variables in your dataset like sales of last months jan, feb, mar, apr, may, jun. And you wanted to do some
calculations on those variable referencing them through array, which of the following statement is correct with regards to array?

A. All newly created variable through array will be added in compilation stage of data step
B. Only numeric variables can be created through array declaration
C. Only character variables can be created through array declaration.
D. It is not mandatory to define all the variables explicitly while array declaration.

 : You have similar variables in your dataset like sales of last months jan, feb, mar, apr, may, jun. And you wanted to do some
1. A,B
2. B,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,D
5. B,D


Question : You have been given below data set and program



data course100 (drop=index);
set course101;
array existing{99:100} fee DURATION;
array new_values{99:100} nfee nduration;

do index=99 to 100;
put _all_;
new_values{index}=existing{index}+existing{index}*.10;
end;
run;

What is the value of nduration variable for course_id=104

 : You have been given below data set and program
1. 55

2. 88

 3. Access Mostly Uused Products by 50000+ Subscribers

4. 77