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?

What is the use of macro function %SYSFUNC?

What are the different classes of tokens available in SAS?

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

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

Can we use title statement inside Proc SQL?

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

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 will you define the list of variables to be printed in the PRINT procedure?

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;

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

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

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?

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?

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?

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

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

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

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

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 ;