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

Question :
The SAS program is submitted:

The SAS data set WORK.SALARY is currently ordered by Gender within Department.
Which inserted
code will accumulate subtotals for each Gender within Department?

1. Gender
2. Department
3. Access Mostly Uused Products by 50000+ Subscribers
4. Department Gender


Correct Answer : Get Lastest Questions and Answer :

Explanation:






Question :
Which step displays a listing of all the data sets in the WORK library?

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


Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :
Given the SAS data set WORK.ORDERS:

The variable order_id is numeric;
customer is character; and shipped is numeric,
contains a SAS date
value, and is shown with the DATE9. format.
A programmer would like to create a new variable,
ship_note, that shows a character value with
the order_id, shipped date, and customer name. For
example, given the first observation ship_note
would have the value "Order 9341 shipped on 02FEB2009
to Josh Martin".
Which of the following statement will
correctly create the value and assign it to ship_note?


1. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
2. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
3. Access Mostly Uused Products by 50000+ Subscribers
4. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);

Correct Answer : Get Lastest Questions and Answer :

Explanation: IAM allows you to grant either user-based permissions (what a user can access) or resource-based permissions (who can access a specific resource)

Related Questions

---

Question : The following SAS program is submitted:
(_insert_ods_code_)
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
The following SAS program is submitted:
(_insert_ods_code_)
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');


1. ods html open='sales.html';
ods html close;
2. ods file='sales.html' / html;
ods file close;
3. Access Mostly Uused Products by 50000+ Subscribers
ods html close;
4. ods file html='sales.html';
ods file close;


Question : Which of the following choices is an unacceptable ODS destination for producing output that can be
viewed in Microsoft Excel?


1. MSOFFICE2K
2. EXCELXP
3. Access Mostly Uused Products by 50000+ Subscribers
4. WINXP



Question : Which statement describes a characteristic of the SAS automatic variable _ERROR_?


1. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
2. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The _ERROR_ variable contains the number of the observation that caused the data error.


Question : The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?


1. proc print data=MYXLS.NORTH;
run;
2. proc print data=MYXLS.NORTH$;
run;
3. Access Mostly Uused Products by 50000+ Subscribers
run;
4. proc print data=MYXLS.'NORTH$'n;
run;



Question :

Given the data set WORK.EMPDATA:

Which one of the following where statements
would display observations with
job titles containing the
word 'Manager'?


1. where substr(Job_Title,(length(Job_Title)-6))='Manager';
2. where upcase(scan(Job_Title,-1,' '))='MANAGER';
3. Access Mostly Uused Products by 50000+ Subscribers
4. where Job_Title like '%Manager%';


Question :

The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?

1. the numeric value 0
2. the character value "01Jan1960"
3. Access Mostly Uused Products by 50000+ Subscribers
4. the code contains a syntax error and does not execute