topic SAS HLO= O not working as expected in SAS Data Management

SAS HLO= O not working as expected

eagles_dare13 — Mon, 26 Jan 2015 18:58:16 GMT

I am creating a data step as follows:

data TEST;

INFILE DATALINES DSD;

INPUT CODE: $4. FLAG_IND: $1.;

DATALINES;

0111,Y

0115,N

;

if last then do;

hlo ='O';

FLAG_IND ='U';

output;

end;

run;

My desired output is:

CODE FLAG_IND HLO

0111 Y

0115 N

U O

But I get:

Statement is not valid or it is used out of proper order.

Is my syntax not right? I was following this:

Page 2

ballardw — Mon, 26 Jan 2015 19:30:49 GMT

The log should be pointing to this line for the error:

if last then do;

Firstly, code precedes the datalines statement.

Second the example uses the END= option for reading a dataset which is not available for DATALINES.

Example:

set Med_tmp end = last;

To use the End option first read the dataset and then use the code from the example on the SET statement reading the set just created.

Or read the data from an external file and use the End=last option on the INFILE statement.