Interested to Buy Any Domain ? << Click Here >> for more details...
Identify statements whose placement in the DATA step is
critical?
- 11 Answers
- 25050 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 |
how can you improve the performance of a query, If it is excuting very slowly?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
How would you delete observations with duplicate keys?
how can you code the confidence intervals?
6 Answers Cytel, IIT, Ranbaxy,
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
Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.
How to read the file names of a text files from a shared drive using SAS?
What is the difference between %local and %global?
what is in stream data in SAS?
what is SAS/Access and SAS/Connect?what are the uses?
What is interleaving in SAS?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
Teradata 
