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

Question : The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file 'file-specification';
put sales1 sales2;
run;
Which one of the following default delimiters separates the fields in the raw data file created?


1. : (colon)
2. (space)
3. Access Mostly Uused Products by 50000+ Subscribers
4. ; (semicolon)

Correct Answer : Get Lastest Questions and Answer :

Exp: because no delimiter is specified at the end of the file stmt.so the default delimitter space is used.if you want comma as a delimitter, use the stmt
file 'file specification' dlm=',';
the default delimiter is 'space'.
but, in case of 'DSD' option then default delimiter becomes 'comma'.





Question :

The contents of the raw data file TEAM are listed below:
--------10-------20-------30
Janice 10
Henri 11
Michael 11
Susan 12
The following SAS program is submitted:
data group;
infile 'team';
input name $15. age 2.;
file 'file-specification';
put name $15. +5 age 2.;
run;
Which one of the following describes the output created?



1. a raw data file only
2. a SAS data set named GROUP only
3. Access Mostly Uused Products by 50000+ Subscribers
4. No output is generated as the program fails to execute due to errors.

Correct Answer : Get Lastest Questions and Answer :

Exp: infile and input statements are used to read data from raw data file. File and put statements are used to write data to raw data file. In our example later is happening, so a
raw data file is created and as data step is creating a dataset (it is not data _null_), it will create an output dataset too. So the answer is C raw data file and group dataset.

it's a data error not a syntax error! so the program will produce the data set named GROUP and a raw data file, with some missing values.






Question :The contents of the SAS data set named PERM.STUDENTS are listed below:
name age
Alfred 14
Alice 13
Barbara 13
Carol 14
The following SAS program is submitted using the PERM.STUDENTS data set as input:
libname perm 'SAS-data-library';
data students;
set perm.students;
file 'file-specification';
put name $15. @5 age 2.;
run;
Which one of the following represents the values written to the output raw data file?

1.
--------10-------20-------30
Alfred 14
Alice 13
Barbara 13
Carol 14
2.
--------10-------20-------30
Alfr14
Alic13
Barb13a
Caro14
3. Access Mostly Uused Products by 50000+ Subscribers
--------10-------20-------30
Alfr14ed
Alic13e
Barb13ara
Caro14l
4.
--------10-------20-------30
Alfred 14
Alice 13
Barbara 13
Carol 14

Correct Answer : Get Lastest Questions and Answer :

Exp: Answer is 2 because @5 age 2. will not create space for itself but rather it will overwrite name $15, which is written first. So Alfred written by name variable will become
Alfr14

Related Questions

---

Question : Finish the ARRAY statement below to create temporary array elements that have initial values of , , , and . array goal{} ... ;


1. _temporary_ (8000 8300 8600 8900)
2. temporary (8000 8300 8600 8900)
3. Access Mostly Uused Products by 50000+ Subscribers
4. (temporary) 8000 8300 8600 8900


Question : Based on the ARRAY statement below, select the array reference for the array element hadoop. array hadoopexam{,} hadoop-hadoop;

1. hadoopexam{hadoop50}
2. hadoopexam{1,50}
3. Access Mostly Uused Products by 50000+ Subscribers
4. hadoopexam{3,0}


Question :

Given the contents of the raw data file EMPLOYEE:
----|----10----|----20----|----30
Amit
19/2/2004
ACCT
Rohit
22/5/2004
MKTG
Manglesh
14/3/2004
EDUC
The following SAS program is submitted:

data emps;
infile 'employee';
input@1 name$
@15 date (insert INFORMAT here)
@25 department$;
run;

Which INFORMAT correctly completes the program?


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


Question : Which of the variable declaration increase the value of the variable named fee with the %?


1. Fee= fee*100;

2. Fee= fee+(fee*2);

3. Access Mostly Uused Products by 50000+ Subscribers

4. Fee=*2;



Question : The following SAS program is submitted:

data test;
infile `file specification';
input name $ amount@@;
run;

Which of the following is true?

1. Two @@ together are the same as one c
2. Two @@ hold the data records until the bottom of the DATA step.
3. Access Mostly Uused Products by 50000+ Subscribers
4. Two @@ are invalid syntax and will cause the program to fail to execute.


Question :

Which SAS statement correctly uses column input to read
the values in the raw data file below in this order: Address
(4th field), SquareFeet (second field), Style (first field),
Bedrooms (third field)?



1. input Address 15-29 SquareFeet 8-11 Style 1-6
Bedrooms 13;
2. input $ 15-29 Address 8-11 SquareFeet $ 1-6 Style
13 Bedrooms;
3. Access Mostly Uused Products by 50000+ Subscribers
Bedrooms 13;
4. input Address 15-29 $ SquareFeet 8-11 Style 1-6
$ Bedrooms 13;