0

programming languages Online Quiz - 258

Description: programming languages Online Quiz - 258
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0
  1. Program data vector (PDV) and Descriptor portion

  2. Input buffer, Program data vector (PDV) and Descriptor portion

  3. Input buffer and Descriptor portion

  4. None of the above


Correct Option: B
  1. holds the input record for the next INPUT statement to read in the same iteration of the DATA step

  2. holds the input record for the next INPUT statement to read across further iterations of the DATA step

  3. holds the input record for the current input statement to read across further iterations of the DATA step

  4. All of the above


Correct Option: A

What is the use of PUT function in a DATA step?

  1. converts character to numeric

  2. onverts numeric to character

  3. writes the values to the output file

  4. None of the above


Correct Option: B

I want to create a 2 way cross tabulation frequency based on Country and Sales using FREQ procedure. From the given options pick the correct code?

  1. Proc freq; Tables country sales; Run;

  2. Proc freq; Table country sales; Run;

  3. Proc freq; Tables country * sales; Run;

  4. Proc freq; Table country * sales; Run;


Correct Option: C

Which procedure can be used to see the descriptor portion of a dataset?

  1. Proc freq

  2. Proc print

  3. Proc datasets

  4. Proc contents


Correct Option: D

Find out the error in the following code? Libname output_dir “c:\mydocuments\output”; Data output_dir.test; Infile datalines dlm=’,’; Input name $ total; If total > 50; Datalines; Sharma,50 Thiyaga,90 Ashok,60 Run;

  1. No Errors

  2. Error in the LIBNAME Statement

  3. Error in the Datalines statement

  4. Error in the infile statement


Correct Option: B

How will you define the list of variables to be printed in the PRINT procedure?

  1. Weight statement

  2. Var statement

  3. Class statement

  4. By statement


Correct Option: B

You have to sort the dataset Temp by the values of salary in descending order. SORT procedure is given below. Find out the missing statement? Data temp; Infile datalines; Input empname $ salary; Datalines; AAA 25000 BBB 45000 CCC 36000 DDD 47000 ; Proc sort data=temp; <<<<<<>>>>>>>>>; Run;

  1. by descending salary

  2. by salary descending

  3. by salary ascending

  4. by salary


Correct Option: A

How can you assign a value from a datastep to a macro variable?

  1. Using Symget function

  2. Using Symput function

  3. Using Assign function

  4. Using Sysfunc function


Correct Option: B

Can we use title statement inside Proc SQL?

  1. True

  2. False


Correct Option: B

What is the value of x in the following code? %let a=2; %let c=3; %let x=a + c;

  1. 5

  2. Error in the code

  3. 2 + 3

  4. 2 + 3 ;


Correct Option: C

What is the value of z? z=weekday(today()); Today being Wednesday, 30 September 2009

  1. 2

  2. 3

  3. 5

  4. 4


Correct Option: D

What are the different classes of tokens available in SAS?

  1. Literals, Numbers, Strings and Symbols

  2. Literals, Numbers, Names and Special Characters

  3. Literals, Characters, Special Characters and Symbols

  4. Characters and Numbers only


Correct Option: B

What is the use of macro function %SYSFUNC?

  1. Used to execute SAS Functions

  2. Used to execute SAS Statements

  3. Used to pass parameters to a macro function

  4. All of the above


Correct Option: A

In Proc SQL, Index can be created on tables and views. State whether the statement is true or false. Also classify the index types in Proc SQL?

  1. True, Simple and Complex

  2. False, Simple and Composite

  3. True, Simple and Composite

  4. False, Simple and Complex


Correct Option: B
- Hide questions