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

Question : The following program is submitted:

data numrecords;
infile cards dlm=',';
input agent1 $ agent2 $ agent3 $;
cards;
jones,,brownjones,spencer,brown;
run;

What is the value for the variable named Agent2 in the second observation?



1. brown
2. spencer
3. Access Mostly Uused Products by 50000+ Subscribers
4. There is no value because only one observation is created

Correct Answer : Get Lastest Questions and Answer :

The CARDS statement enables you to read instream data. Any number of consecutive commas are considered to be a single delimiter as a result of the DLM= option, and the length of each
variable defaults to 8 bytes. Therefore, the values jones, brownjon, and spencer are assigned to Agent1, Agent2, and Agent3, respectively, for the first observation. The rest of the
data on the record is not read by the INPUT statement and is not output to the data set.

Because the cards are one per line observation, this question only one row of data, so there is no second observation





Question :
1---+----10---+----20---+----30---+----40---+----50
TWOSTORY 1040 2 1SANDERS ROAD $55,850
CONDO 2150 4 2.5JEANS AVENUE $127,150
The following program is submitted using this file as input:

data work.houses;
infile 'file-specification';
(insert INPUT statement here)
run;
Which one of the option from left image, INPUT statements reads the raw data file correctly?


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

Correct Answer : Get Lastest Questions and Answer :

Formatted input requires periods as part of the informat name. The period is missing from the variables Style and Street in Answer b, the variable Baths in Answer d, and the variable
Price in Answer a (which is also missing a dollar sign to read the variable Street as a character value).
formatted input

formatted input (+1, @ 20, etc.) after which the format to the "."

The following SAS program is submitted at the start of a new SAS session:

libname sasdata 'SAS-data-library';
data sasdata.sales;
set sasdata.salesdata;
profit=expenses-revenues;
run;
proc print data=sales;
run;




Question : The SAS data set Sasdata.Salesdata has ten observations. Which one of the following explains why a report fails to generate?


1. The DATA step fails execution.
2. The SAS data set Sales does not exist.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The PRINT procedure contains a syntax error.


Correct Answer : Get Lastest Questions and Answer :

The DATA step creates a permanent SAS data set, Sasdata.Salesdata. The PRINT procedure is printing a temporary SAS data set, Sales, that is stored in the Work library. At the
beginning of the SAS session, Work.Sales does not exist.

Related Questions

---

Question : You have been given a data set named HESAMPLE with the column variables named COURSE_ID, COURSE_NAME, COURSE_FEE, STUDENTS. TRAINING_DATE
etc. which of the following is not a good fit for descriptive analytics using MEANS PROCEDURE?


1. COURSE_ID

2. COURSE_NAME

3. Access Mostly Uused Products by 50000+ Subscribers

4. STUDENTS

5. TRAINING_DATE



Question : You have been using PROC MEANS procedure for descriptive analytics, which of the following statement is true when you want to categorize
the data using BY statement?
A. Data must be already sorted or indexed in the order of the by statement.
B. Output will be generated in multiple tables instead of single
C. Data must not be already sorted or indexed in the order of the by statement.
D. Output will be generated in single tables instead of single


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


Question : Which of the given SAS code will generate the below output


1. proc means data=course2017 ;
by course_name fee;
run;

2. proc means data=course2017 ;
class course_name fee;
run;

3. Access Mostly Uused Products by 50000+ Subscribers
class fee course_name;
run;

4. proc means data=course2017 ;
class course_name ;
run;



Question : Following output can be generated using which of the following procedure


A. proc means data=course2017 ;
class course_name;
run;

B. proc summary data=course2017 print ;
class course_name;
run;

C. proc means data=course2017 noprint ;
class course_name;
run;

D. proc summary data=course2017 noprint;
class course_name;
run;


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


Question : You have been given a SAS data set with the name of HESAMPLE which contains various columns including Numeric and character, when you use
this data set in FREQ proc which of the statement will be true?


1. It will generate freq only for numeric values

2. It will generate freq only for character variables

3. Access Mostly Uused Products by 50000+ Subscribers

4. By default it will not generate freq for any variable/



Question : You have been asked to apply frequency analysis of some data, now you need to select the variables which is best fit for frequency analysis
which variable you will be choosing.


1. Numerical Value column only

2. Column which has unique value only

3. Access Mostly Uused Products by 50000+ Subscribers

4. Column which has Categorical values