Identify statements whose placement in the DATA step is
critical?
Answers were Sorted based on User's Feedback
Answer / amaran
Datalines or Cards - They should be the Last statement in
your Data step. all the ohers can be placed any where
between the Data & Datalines statement.
Is This Answer Correct ? | 8 Yes | 1 No |
The placement of drop keep and rename statement does not affect its execution order.The order is fixed in the order
DROP-KEEP-RENAME.Even if you put a rename statement(rename old_var=new_var;) before a drop statement.The drop statement will look for old_var as it is executed prior to rename statement.
Length can be the answer as its placement is very important.Changing the length value of a variable after the set statement will not carry out the necessary change.It has to be done before set statement.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vijay
first preference goes to run;
next - placement of ; if you use datalines
next - use of infile and input
next - use of retain and length statements
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / meena
Placement of the last six statements (shown below) is critical
because the attributes of variables are determined
by the first reference to the compiler:
drop, keep, rename
label
retain
length
format, informat
attrib
array
by
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / chandra sekar
Keep, Drop and Rename can also play a critical role if you
are using some of the variables listed in them.
Is This Answer Correct ? | 0 Yes | 2 No |
What are the difficulties u faced while doing vital signs table or dataset?
how to change the execute of macro
What is the purpose of the trailing and How would you use them?
Why and when do you use proc sql?
how to write code for left outer join in SAs using datastep?
What SAS statements would you code to read an external raw data file to a DATA step?
what are all the default values getting in PROC MEANS...???
Explain how merging helps to combine data sets.
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
What are the difference between sas functions and procedures?
What is the work of tranwrd function?
Have you used macros? For what purpose you have used? : sas-macro