How many observations will be there in the output dataset person? Data person; infile datalines; input name $ dept $ age; if age le 30; datalines; John Sales 38 Mary Brown Acctng 32 Spielberg Manager 28 ;

At compile time when an external file is read, what items are created?

What does the line hold specifier single trailing(@) do when used in an input statement?

What is the output of the following sum statement? X1=9, X2=4, X3=1 Z=sum(of X1-X3);

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

Dataset Temp contains 1 observation and 30 variables. Which procedure can be used to convert it into 30 observations with 1 variable in an efficient manner?

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?

A SAS code has been executed and it has an error on the 10th line of the code. What will be the value of the automatic variable ERROR?

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

What is the length of variable a ? data temp; a=substr('joshi anand',1,3); run;

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;

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

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;

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

Can we use title statement inside Proc SQL?

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

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

What are the different classes of tokens available in SAS?

What is the use of macro function %SYSFUNC?

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?