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

Question : You have been given below dataset which has training fee


Which of the fee can be considered as a standard numeric data for last column fee


1. Line-1

2. Line-2

3. Access Mostly Uused Products by 50000+ Subscribers

4. Line-4


Correct Answer : Get Lastest Questions and Answer :
Explanation: Standard Numeric values can contain : Number, Scientific Notation, Decimal points, plus sign and minus sign.
Nonstandard Numeric Data: values contain fractions, special characters such as commas, dollar sign, and percent sign.





Question : : You are working on Sales data and by looking at the data you have decided that you have to use formatted input, for which kind of data
you can use formatted input?


1. Standard Free Format Data

2. Standard data with fixed fields and length

3. Access Mostly Uused Products by 50000+ Subscribers

4. You can use it for both standard and non-standard data in fixed length.


Correct Answer : Get Lastest Questions and Answer :
Explanation: You can use formatted input to read both standard and non-standard data which has to be in fixed fields.




Question : You have been given below dataset



Which of the following format can be used to read data from column 1-8 ?


1. w.

2. $w.

3. Access Mostly Uused Products by 50000+ Subscribers

4. Commaw.d


Correct Answer : Get Lastest Questions and Answer :
Explanation: You can use $w. to read column 1-8. Column 1 to 8 is a character string. A character string can have numeric data in it. $w.
means w is the maximum width of column and $ to read as character data.

Related Questions

---

Question : Within the data set Furnitur.Bookcase, the variable Finish contains values such as ash/cherry/teak/matte-black.
Which of the following creates a subset of the data in which the values of Finish contain the string walnut? Make the search for the string case-insensitive.

1. data work.bookcase;
set furnitur.bookcase;
if index(finish,walnut) = 0;
run;
2. data work.bookcase;
set furnitur.bookcase;
if index(finish,'walnut') > 0;
run;
3. Access Mostly Uused Products by 50000+ Subscribers
set furnitur.bookcase;
if index(lowcase(finish),walnut) = 0;
run;
4. data work.bookcase;
set furnitur.bookcase;
if index(lowcase(finish),'walnut') > 0;
run;


Question : You have been given a library named HETRAIN, now you need to find the summary of all the files stored in this SAS library, which of the
following option will be best suitable.


1. proc contents data=HETRAIN._all_ nods;

2. proc contents data=HETRAIN _all_ nods;

3. Access Mostly Uused Products by 50000+ Subscribers

4. proc contents data=HETRAIN _all_.nods;



Question : Which of the following is a correct syntax with regards to referencing a file stored in a SAS permanent library?


1. data hadoopexam.subs;
set courses.subscriber;
if price>100;
run;



2. data 2hadoop.subs;
set courses.subscriber;
if price>100;
run;


3. Access Mostly Uused Products by 50000+ Subscribers
set courses.subscriber;
if price>100;
run;


4. data subs;
set courses.subscriber;
if price>100;
run;



Question : If you have specified the YEARCUTOFF= , which is the correct range of year , whenyou specify digit years.



1. 1930-2029

2. 1930-2030

3. Access Mostly Uused Products by 50000+ Subscribers

4. 1929-2029



Question : Which of the following statements are correct (Assume you are not using SAS windows environment)
A. LIBNAME statements can be stored with a SAS program to reference the SAS library automatically when you submit the program.
B. As soon as you delete the librefs, SAS cannot access the files in a library. Actual contents from the OS will not be deleted.
C. Once, you have created Librefs, you dont have to create it again across the various SAS session.
D. LIBNAME statement will help you to access the files which are created by Software Vendors other than SAS.


1. A,B,C
2. B,C,D
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,C,D


Question : Which program displays a listing of all data sets in the SASUSER library?

1. proc contents lib = sasuser.all; run;
2. proc contents data = sasuser.all; run;
3. Access Mostly Uused Products by 50000+ Subscribers
4. proc contents data = sasuser._all_; run;