topic Re: base sas in SAS Programming

base sas

molla — Sat, 03 Dec 2016 20:28:02 GMT

Hi ,

I need the following output

id sal out

2 500

2 500 500

3 600

3 600 600

4 700

4 700 700

Re: base sas

PGStats — Sat, 03 Dec 2016 22:27:00 GMT

Assuming what you want is variable out = last value of variable sal for each id, a double DO UNTIL() will do the job:

data want;
do until (last.id);
    set have; by id;
    end;
lastSal = sal;
do until (last.id);
    set have; by id;
    out = lastSal;
    output;
    end;
drop lastSal;
run;

Re: base sas

Astounding — Sat, 03 Dec 2016 22:28:01 GMT

Since you didn't mention any input, I have to assume you want a program to generate this data.

data want;

do id=2 to 4;

out=300 + id*100;

do obsnum=1 to 3;

if obsnum=3 then sal=out;

output;

end;

drop obsnum;

run;