topic sas reading a blank record in SAS Programming

sas reading a blank record

dennis_oz — Fri, 30 May 2014 07:00:25 GMT

hi in my below file below is my file after trailer there is a (.)

So when i execute my data setep , it is telling 4 records have been read. the record after trilaer is being read. I do not want to read that . Any suggestion

data a;

input name $;

if trailer then delete;

datalines;

Tailer
..

run;

Re: sas reading a blank record

RW9 — Fri, 30 May 2014 08:29:22 GMT

Sorry, not really understanding you very well, you don't want any observations after/including the trailer one? Why not just remove them from the datalines step? You could add a retained flag:

data a;

input name $;

retain flag;

if _n_=1 then flag=0;

if trailer then flag=1;

if not flag then output;

datalines;

Tailer
..

run;

The question is, why?

Re: sas reading a blank record

sureshsas — Fri, 30 May 2014 09:06:32 GMT

Hi dennis ,

I am sorry not getting your question according to my understanding if there are trailing blanks

remove it by it by input options.

Re: sas reading a blank record

Scott_Mitchell — Fri, 30 May 2014 10:48:57 GMT

If '..' is not an acceptable value in any of the previous observations you could.use the following:

DATA A;

INPUT NAME $ @;

IF NAME = '..' THEN STOP;

DATALINES;

TRAILER

;

RUN;

The trailing @ holds the input record so that you can process the item conditionally. In this case we are telling SAS to stop processing once a '..' is read.

Alternately you could use:

DATA A;

INPUT NAME $ @;

IF NAME = '..' THEN DELETE;

DATALINES;

TRAILER

RUN;

This will delete any occurrence of '..'.

I hope this helps.

Regards,

Scott

Re: sas reading a blank record

ballardw — Fri, 30 May 2014 14:53:51 GMT

if name='Trailer' then stop;

Re: sas reading a blank record

stat_sas — Fri, 30 May 2014 15:17:10 GMT

Try this.

data have;
input name $10.;
output;
if name eq 'Tailer' then stop;
datalines;
aa
bb
cc
Tailer

..
run;