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

Question : Select the correct defined format from below


1. proc format lib=library;
value location ;
1='Mumbai'
2='Pune'
3='Chennai';
run;


2. proc format lib=library;
value location
1='Mumbai'
2='Pune'
3='Chennai';
run;


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


4. proc format lib=library;
value location ;
1='Mumbai' ;
2='Pune';
3='Chennai';
run;


Correct Answer : Get Lastest Questions and Answer :
Explanation: When you define your own format statement than you can use either LIB= or LIBRARY= to refer the library to store FORMAT catalog
permanently.
And format statement should start with the value statement give the name to the format and should not end with semicolon, after than define all the
required formats. Once you are done end it with the semicolon. Individual format values should not end with the semicolon.





Question : While creating a user defined formats, what all are possible values?
A. You can use single value like 100 or 'H'
B. You can use the range of values like 0-100
C. You can use character range like 'A'-'G'
D. You can define a list which can contain anything lile 'A' ,100, 200, 'SAS' etc.



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

Correct Answer : Get Lastest Questions and Answer :
Explanation: You can have only those values which can be possible values like only numeric or only character values. Hence, as part of
format you can have numeric value or character values only. But can not be a mixed values. You can define the range of values like 1-10 or A-Z etc.




Question : Which pointer control can be used to read records non-sequentially?


1. @n
2. #n
1. +n
2. /
Ans : 2
Exp : The #n line pointer control is used to read records non-sequentially. The #n specifies the absolute number of the line to which you want to move the pointer.


Question : While creating user defined format and you want to specify particular label for a particular value in data set. What is the maximum
possible character length for a label?


1. 32

2. 8

3. Access Mostly Uused Products by 50000+ Subscribers

4. 256

5. 32,767


Correct Answer : Get Lastest Questions and Answer :
Explanation: You can have label character length up to 256 character.

Related Questions

---

Question :

Which is a valid LIBNAME statement?


1. libname "_SAS_data_library_location_";
2. sasdata libname "_SAS_data_library_location_";
3. Access Mostly Uused Products by 50000+ Subscribers
4. libname sasdata sas "_SAS_data_library_location_";


Question :

The following output is created by the FREQUENCY procedure:
Which TABLES option(s) would be used to eliminate the
row and column counts and just see the
frequencies and percents?


1. norowcount nocolcount
2. freq percent
3. Access Mostly Uused Products by 50000+ Subscribers
4. nocounts


Question :

The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?


1. libname qtrdata 'qtr1.xls';
2. libname 'qtr1.xls' sheets=3;
1. libname jan feb mar 'qtr1.xls';
2. libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);


Question :

The following SAS program is submitted:

What is produced as output?


1. A file named test.cvs that can only be opened in Excel.
2. A text file named test.cvs that can be opened in Excel or in any text editor.
3. Access Mostly Uused Products by 50000+ Subscribers
4. A file named test.cvs that can only be opened by SAS.


Question :

You're attempting to
read a raw data file
and you see the following
messages displayed
in the SAS Log:
What does it mean?


1. A compiler error, triggered by an invalid character for the variable Salary.
2. An execution error, triggered by an invalid character for the variable Salary.
3. Access Mostly Uused Products by 50000+ Subscribers
4. An error on the INPUT statement specification for reading the variable Salary.


Question :

The following SAS program is submitted:


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