Question 1

PROC SORT data = lib.temp out = temp2; By subjid; Run; In which library temp2 is made?

technology programming languages

work
sasuser
lib
syntax error

Answer

Correct Option: A

Question 2

options obs = 500; Data TEMP; Set test(firstobs = 75); Run; What will be the number of observations in temp dataset?

technology programming languages

425
424
500
426

Answer

Correct Option: D

Question 3

PROC SORT data = temp out=new; BY JOBCODE Descending SALARY; RUN; Temp DATASET What will be the output??

technology programming languages

"temp" dataset sorted by jobcode in desending order and salary in ascending order
"temp" dataset sorted by jobcode in ascending order and salary in descending order
"new" dataset sorted by jobcode in ascending order and salary in descending order
"new" dataset sorted by jobcode in descending order and salary in ascending order

Answer

Correct Option: C

Question 4

data temp; test = ‘X’; select(test); when(‘Y’) Name = ‘Ank’; when(‘X’) Name = ‘Ankur’; when(‘Z’) Name = ‘ ’; end; run; What is the output?

technology programming languages

Ank
Ankur
Missing
'Ankur'

Answer

Correct Option: A

Question 5

data null; put ‘test’; run; Where will the ouput(test) be written?

technology programming languages

Syntax error
Log
In Last file opened
In dataset null

Answer

Correct Option: B

Question 6

What is true about ERROR variable?

technology programming languages

d.) Will have values “TRUE” or “FALSE”
c.) Will have values “YES” or “NO”
b.) This variable appears in output dataset
a.) Can be used in assignments/calculation in datastep.

Answer

Correct Option: D

Question 7

1----5----10--- (data in file ‘asa’) 03132000 data temp; infile ‘asa’; input date : MMDDYY10.; run; What will be stored in date?

technology programming languages

02 January
02FEB2000
01022000
14682(number of days from 1st jan 1960)

Answer

Correct Option: D

Question 8

data test; n=1; do while(n lt 6); n+1; end; run; What will be the value of n at the end of datastep?

technology programming languages

7
6
5
8

Answer

Correct Option: B

Question 9

data test; dat = '13MAR2000'd; format dat WEEKDATE.; run; What will be the value of dat in output dataset?

technology programming languages

14682 (nmber of days from 1st jan 1960)
13MAR2000
Monday, March 13, 2000
Mon, March 13, 2000

Answer

Correct Option: C

Question 10

data temp; set x; run; “missing code” data test; set y; run; What will be the missing code to reset the page number ?

technology programming languages

OPTIONS PAGENO = 1;
OPTIONS RESET PAGENO = 1;
OPTIONS RESET PAGENUMBER = 1;
OPTIONS PAGENUMBER = 1;

Answer

Correct Option: A

Question 11

DATA TEMP; Infile ‘filename’; Input ID $5 @; If ID = ‘RAMES’ then input Y $6 Z $10 @; else ID = ‘VIJAY’ then input R $2 @; Input age 5.; RUN; How many lines are read from input file during one execution of dataset?

technology programming languages

2
1
3
4

Answer

Correct Option: B

Question 12

How to write comma separated file?

technology programming languages

a.) FILE ‘filename’ dsd = ‘,’;
b.) FILE ‘filename’ dlm = ‘ ’ dsd = ‘,’;
c.) FILE ‘filename’ dlm = ‘,’;
d.) FILE ‘filename’ csv = ‘,’;

Answer

Correct Option: C

Question 13

1----5----10----15----(file ‘abc’) RAM,,20 RAJU,SHARMA,24 DATA temp; Infile ‘abc’ dsd; Input FNAME $ LNAME $ AGE; RUN; What will be the value of LNAME for 1st observation?

technology programming languages

‘,’
blank character value
‘SHARMA’
syntax error

Answer

Correct Option: B

Question 14

libname temp ‘abc.sds.as’; data temp.X1; set sasuser.X2; run; Which is the correct statement??

technology programming languages

In datastep input is read from temporary location and output is written to temporary location.
.) In datastep input is read from permanent location and output is written to temporary location.
In datastep input is read from temporary location and output is written to permanent location.
In datastep input is read from permanent location and output is written to permanent location.

Answer

Correct Option: D

Question 15

What is the output of DATE9. format?

technology programming languages

11/31/2000
31/11/2000
31NOV2000
01NOVEMBER2000

Answer

Correct Option: C

Question 16

data a; do X=1 to 3 ; input ID NAME $ AGE; end; datalines; 01 vivek 22 02 vital 25 03 rajes 20 ; What will be the number of observations and variables in output dataset??

technology programming languages

3 and 3
1 and 3
1 and 4
3 and 1

Answer

Correct Option: C

Question 17

What informat should be used to read the date variable in the flat file having the values like 02NOV2003?

technology programming languages

DATE9.
MMDDYY8.
MMDDYY10.
none

Answer

Correct Option: A

Question 18

Flat file structure is as below 1----5----10 $1,120 The following code is submitted. data temp; infile ‘file specification’; input salary 5; run; What would be the value of SALARY in the dataset TEMP

technology programming languages

blank value
$1,120
2
.

Answer

Correct Option: C

Question 19

Format name or Informat name should end with a dot eg:DATE9.

technology programming languages

True
False

Answer

Correct Option: A

Question 20

data temp; length y $5; x=4; if x=4 then y='four'; else if x=7 then y='seven'; x=7; run; What would be the value of X and Y in the dataset temp?

technology programming languages

X=4 and Y= ‘seven’
X=7 and Y=’seven’
X=7 and Y=’four’
X=4 and Y=’four’

Answer

Correct Option: C

Description: programming languages Online Quiz - 121
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: programming languages

programming languages Online Quiz - 121

Find more quizzes from top tags