Identify statements whose placement in the DATA step is critical?

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

Identify statements whose placement in the DATA step is
critical?

Question Posted / sasguru

11 Answers
25091 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Identify statements whose placement in the DATA step is critical?..

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

Identify statements whose placement in the DATA step is critical?..

Answer / suresh

Input
inifle
run

Is This Answer Correct ?

5 Yes

1 No

Identify statements whose placement in the DATA step is critical?..

Answer / pratik singh jageera

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

Identify statements whose placement in the DATA step is critical?..

Answer / vsrao

data,run

Is This Answer Correct ?

4 Yes

2 No

Identify statements whose placement in the DATA step is critical?..

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

Identify statements whose placement in the DATA step is critical?..

Answer / raghu

data
input
cards/datalines
run

Is This Answer Correct ?

0 Yes

0 No

Identify statements whose placement in the DATA step is critical?..

Answer / lakshmi

data,run,semicolon

Is This Answer Correct ?

0 Yes

1 No

Identify statements whose placement in the DATA step is critical?..

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

Identify statements whose placement in the DATA step is critical?..

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

Identify statements whose placement in the DATA step is critical?..

Answer / sasfaqs

input is the critical step

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More SAS Interview Questions

in ods is there any lib's

2 Answers SAS,

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 Answers

why a stop statement is needed for the point= option on a set statement?

0 Answers

how the sas basic syntax style described? : Sas-administrator

0 Answers

Are you sensitive to code walk-throughs peer review or QC review?

0 Answers Quintiles,

How many ways to overcome a missing values???

0 Answers HSBC,

How do you read in the variables that you need?

5 Answers

Name statements that are recognized at compile time only?