topic Re: Camparing two data fields in SAS Enterprise Guide

Camparing two data fields

deleted_user — Thu, 31 Jul 2008 19:06:59 GMT

I need help in SAS Enterprise Guide. I have a table containing current and historical data. The data is in the same column as such:

date name value
7/5 John 5
current John 10

I need SAS to return the difference. If there is no difference, then it won't return a value.

Any help would be greatly appreciated.

Thanks,

Re: Camparing two data fields

datalligence — Mon, 04 Aug 2008 09:03:35 GMT

Not very sure of what you exactly want but i think you can try using the first.variable_name, last.variable_name, and the lag function.

data yourdata;
by name date;
if first.date <> last.date then;
diff_date=date-lag(date);
diff_value=date-lag(value);
....
....

Thanks,
Romakanta

Re: Camparing two data fields

deleted_user — Tue, 05 Aug 2008 13:22:55 GMT

Thanks Romakanta.