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

Question : How many observations are in data set WORK.ALL after submitting the program?


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

Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :
The following program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

1. The output contains only a list of the SAS data sets that are contained in the WORK library.
2. The output displays only the contents of the SAS data sets that are contained in the WORK library.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.

Correct Answer : Get Lastest Questions and Answer :

Explanation:






Question :

The following program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?



1. The descending option applies to the variable Code.
2. The variable Code is sorted by ascending order.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The descending option applies to the Date and Cost variables.

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :Assume that SAS data sets Sasdata.Products and Sasdata.Sales both contain the Prod_ID variable.
Which of the following SAS DATA steps returns only exceptions or non matches?
a.
libname sasdata 'SAS-data-library';
data all;
merge sasdata.products
sasdata.sales;
by prod_id;
if ins=1 or inp=1; run;
b.
libname sasdata 'SAS-data-library';
data all;
merge sasdata.products(in=inp)
sasdata.sales(in=ins);
by prod_id;
if ins=1 and inp=1; run;
c.
libname sasdata 'SAS-data-library';
data all;
merge sasdata.products(in=inp)
sasdata.sales(in=ins);
by prod_id;
if ins=0 and inp=0; run;
d.
libname sasdata 'SAS-data-library';
data all;
merge sasdata.products(in=inp)
sasdata.sales(in=ins);
by prod_id;
if ins=0 or inp=0; run;

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


Question :

The following SAS program is submitted:

libname sasdata 'SAS-data-library';
libname labdata 'SAS-data-library';
data labdata.boston
labdata.dallas(drop=city dest equipment);
set sasdata.cities(keep=orig dest city
price equipment);
if dest='BOS' then output labdata.boston;
else if dest='DFW' then output labdata.dallas;
run;

Which variables are output to both data sets?

1. price and orig only
2. city and equipment only
3. Access Mostly Uused Products by 50000+ Subscribers
4. city, price, orig, and equipment


Question : The following SAS program is submitted:

proc contents data=sasuser._all_ nods;run;

Which one of the following is produced as output?


1. the list of all data set names in the Sasuser library only
2. the descriptor portion of the data set named Sasuser._All_
3. Access Mostly Uused Products by 50000+ Subscribers
4. the list of data set named in the Sasuser library plus the descriptor portion of every data set in the Sasuser library.


Question :

The following SAS program is submitted:

data work.test;
length city $20;
city='Paris';
city2=trim(city);
run;

Which one of the following is the length of the city2 variable?



1. 5
2. 6
3. Access Mostly Uused Products by 50000+ Subscribers
4. 20


Question :

60. A raw data record is listed below.

1---+----10---+----20---+---
$23,456 750

The following SAS program is submitted:

data bonus;
infile 'file-specification';
input salary $ 1-7 raise 9-11;
(insert statement here)
run;

Which one of the following statements completes the program and adds the values of salary and raise to calculate the expected values of the newsalary variable?




1. newsalary=salary + raise;
2. newsalary=put(salary,comma7.) + raise;
3. Access Mostly Uused Products by 50000+ Subscribers
4. newsalary=put(salary,comma7.) + put(raise,3.);


Question : Which one of the following is the value of the variable trip in the output data set?


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