Interested to Buy Any Domain ? << Click Here >> for more details...
Identify statements whose placement in the DATA step is
critical?
- 11 Answers
- 24934 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 |
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
What are the difference between the sas data step and sas procs?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
What is the registered Key word is sas????
what is the difference between floor and ceil functions in sas? : Sas-administrator
Which is the best training Institute for SAS Business Intelligence course?
i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?
Why is SAS considered self-documenting?
Explain what Proc glm does?
What is _n_?
wat is sas? is a package or programming language?
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
Teradata 
