Statement to remove all observations below a certain string.

Stretlow — Thu, 29 May 2014 10:34:22 GMT

Hello there!

I have a small issue i've been googleing to no avail and would appreciate some help if that's ok.

I have an exported report that's in a stupid format.

once read in I want a statement to run to say the following.

IF Var1 = "UC" then delete all observations below it?

Is that possible?

many thanks in advance.

Stret

Re: Statement to remove all observations below a certain string.

data_null__ — Thu, 29 May 2014 10:39:49 GMT

data clip;

set unclip;

output;

if var1 eq 'UC' then stop;

run;