topic Re: coding help please!!! in SAS Enterprise Guide

coding help please!!!

sas_9 — Tue, 26 Nov 2013 22:22:40 GMT

hi guys, i am trying to get total amount for two patient but in below code i am getting only one obs. instead of two. can someone plz help...

Thanks!

data test (drop=type amount);

infiles cards end=last;

retain id name;

input type $1. @;

if type='p' then do;

if _n_ >1 then output;

totalcost=0;

input @3 id @8 name $15.;

end;

if type='c' then do;

input @12 amount comma6.;

totalcost+amount;

end;

if last then output;

cards,

p 1095 smith, howard

c 01-08-98 $45.0

c 01-17-98 $37.0

p 1096 barclay, nick

c 01-09-98 $156.5

c 01-17-98 $20.0

;

run;

/*i think it's OUTPUT statement issue, i tried to put 'output' statement different places but didn't get correct result*/

Re: coding help please!!!

Tom — Tue, 26 Nov 2013 23:09:38 GMT

You cannot use the END= option when using in line data. Try re-coding to use the EOF= option instead.

data test (drop=type amount);

infile cards eof=last;

retain id name;

input type $1. @;

if type='p' then do;

if _n_ >1 then output;

totalcost=0;

input @3 id @8 name $15.;

end;

if type='c' then do;

input @12 amount comma6.;

totalcost+amount;

end;

return;

last:

output;

cards;

p 1095 smith, howard

c 01-08-98 $45.0

c 01-17-98 $37.0

p 1096 barclay, nick

c 01-09-98 $156.5

c 01-17-98 $20.0

run;

Re: coding help please!!!

sas_9 — Tue, 26 Nov 2013 23:16:14 GMT

Thanks a lot Tom - it ran fine...

can you please give little more explanation on

return;

last:

output;

Re: coding help please!!!

art297 — Tue, 26 Nov 2013 23:23:31 GMT

Like Tom mentioned, you can't use eof in an infile statement when you are using cards or datalines. Instead, you can use eof=label. What Tom's code did was create a label called 'last'.

As such, when the code hit the return statement, it skipped the label (and its code) and returned to the start of the code. When it got to the last record, it jumped down to the last label, output the record, then exited.

Re: coding help please!!!

sas_9 — Wed, 27 Nov 2013 00:00:53 GMT

thanks all!