Premium

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



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


 : 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


Correct Answer : Get Lastest Questions and Answer :
Explanation: Whenever you specify two digit year, than how SAS will understand what exactly this year is. Let say you have given year=29
what does that mean it 2029 or 1929. It depends what value you have set for the option YEARCUTOFF=. In given question if you have defined
YEARCUTOFF=1930, it means it will range between 1930 and 2029. Hence, year between 0 and 29 will be part of 2000 range. And any value between and to 99
will be part of 1900. Hence year=29 means it is 2029 and year=35 means 1935.
Default value of YEARCUTOFF=1920.





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.

 : Which of the following statements are correct (Assume you are not using SAS windows environment)
1. A,B,C
2. B,C,D
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,C,D

Correct Answer : Get Lastest Questions and Answer :
Explanation: Please note that LIBNAME statement is global, it means librefs will be effective until changed or canceled or session ends.
Hence, librefs reference created by LIBNAME statement will be valid for current session only. As soon as, you start a new session, you have to assign
librefs again before you are able to access the files from SAS library.




Question : Which program displays a listing of all data sets in the SASUSER library?
 : 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;

Correct Answer : Get Lastest Questions and Answer :

Explanation: : You can use the CONTENTS procedure to create SAS output that describes the contents of a library. _ALL_ requests a listing of all files in the library, and NODS suppresses
the printing of detailed information about each file in the output.

The Sasuser library contains the customizations (such as window size and positioning, colors, fonts, and printer entries) that you specified for your SAS session. When you invoke
SAS, it looks for the Sasuser directory to find these customizations. If this directory does not exist, SAS uses the SASUSER system option to create it. The default directory is set
in the system configuration file (sasv9.cfg) and is usually similar to the following:
-sasuser ~/sasuser.v91
This specification tells SAS to create a directory for the Sasuser libref in your home directory. To determine the value of this directory for your system, use PROC OPTIONS or
libname sasuser LIST .
You can permit read-only access to the Sasuser library by using the RSASUSER system option. See System Options under UNIX for information about the SASUSER and RSASUSER system
options.
After the Sasuser library has been created, SAS automatically assigns the same Sasuser libref to it each time you start a SAS session. It cannot be cleared or reassigned during a SAS
session. If you delete the library, SAS re-creates it the next time you start a session. Because SAS assigns the libref for you, you do not need to use a LIBNAME statement before
referencing this library.
________________________________________
Contents of the Sasuser Library
Your customizations are stored in one of the following locations in the Sasuser library:
" Sasuser.Profile catalog
" Sasuser.Registry catalog
" Sasuser.Prefs file
SASUSER library
a default permanent SAS data library that is created at the beginning of your first SAS session. It contains a PROFILE catalog that stores the tailoring features you specify for SAS.
You can also store other SAS files in this library. See also PROFILE catalog and SAS data library.



Related Questions


Question :
Given the raw data file AMOUNT:
----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile `amount';
input@1 salary 6.;
if_error_then description = `Problems';
else description = `No Problems';
run;
What is the result?

  :
1. The value of the DESCRIPTION variable is No Probl.
2. The value of the DESCRIPTION variable is Problems.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The value of the DESCRIPTION variable can not be determined.


Question :
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for
each of 5 departments.
What is the result?

  :
1. The WORK.TOTAL data set contains 5 observations.
2. The WORKTDTAL data set contains 100 observations.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.


Question :
The following SAS program is submitted;
data combine;
country = `Italy, Russia, ireland';
found = find(country, `i');
run;
What is the value of the variable FOUND in the output data set?

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


Question :
Given the following code:
proc print data=SASHELP.CLASS(firstobs=5 obs=15);
where Sex='M';
run;
How many observations will be displayed?

  :
1. 11
2. 15
3. Access Mostly Uused Products by 50000+ Subscribers
4. 11 or fewer


Question :
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently
ordered by Department. The SAS program is submitted (left image):

Which statement is true?

  :
1. The by statement in the DATA step causes a syntax error.
2. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.


Question :
Given the contents of the raw data file TYPECOLOR.DAT: (left image)

What are the values of the variables Type and Color?

  :
1. Type=daisy, Color=yellow
2. Type=daisy, Color=w
3. Access Mostly Uused Products by 50000+ Subscribers
4. Type=daisy, Color=