Interested to Buy Any Domain ? << Click Here >> for more details...
Identify statements whose placement in the DATA step is
critical?
- 11 Answers
- 25440 Views
- I also Faced
- E-Mail Answers
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 is the use of LRECL option.
What versions of SAS have you used (on which platforms)?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
how sas deals with business intelligence? : Sas-bi
How can you limit the variables written to output dataset in data step?
What is the purpose of the trailing @? The @@? How would you use them?
%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help
What are the applications primarily used by business analyst? : Sas-bi
Teradata 
