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 |
How do you add a number to a macro variable?
Explain the difference between nodup and nodupkey options?
What is the good sas programming practices for processing large data sets?
what is the diff b/w verification validation in sas
what is factor analysis? : Sas-administrator
what is data governance? : Sas-di
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
How to read the file names of a text files from a shared drive using SAS?
Describe 5 ways to do a “table lookup” in SAS?
how do u test a pros sql(works or not) without executing it?
what is the difference between proc means and proc summary?
Differentiate between ceil and floor functions.