topic Re: switching the values of the columns in SAS Enterprise Guide

switching the values of the columns

reddy19 — Fri, 27 May 2011 18:16:15 GMT

Hi,

33822730 12/27/2007 xyz Approval
33822730 2/4/2009 xyz Referral

I have to switch the values of APPROVAL and REFERRAL depending on date.For each id the first date value should be approval and second date value should be Refferal,only if approval and refferal are present for perticular id.

How can acheive this using EG.

reddy

Re: switching the values of the columns

SPR — Fri, 27 May 2011 18:51:13 GMT

Hello Reddy19,

This is a solution:
[pre]
data i;
input id date ANYDTDTE10. field $ Status $ 25-32;
format date date7.;
datalines;
33822730 12/27/2007 xyz Approval
33822730 2/3/2009 xyz
33822730 2/4/2009 xyz Referral
33822730 2/5/2009 xyz
run;
proc sort data=i;
by id date;
run;
data r;
set i;
if FIRST.id and UPCASE(Status) in ("APPROVAL" "REFERRAL") then s="Referral";
else if UPCASE(Status) in ("APPROVAL" "REFERRAL") then s="Approval";
by id;
run;
[/pre]
Sincerely,
SPR

Re: switching the values of the columns

reddy19 — Fri, 27 May 2011 20:57:49 GMT

Through programming i will be able to do it.

But using EG(point and click interface),i'm not able to figure it out...can you please suggest me how i could do this using EG.

Thanks a lot,
reddy

Re: switching the values of the columns

Patrick — Sat, 28 May 2011 05:44:04 GMT

Hi

The query wizard in EG generates SQL code.
Writing logic in SQL where you need to do things on a "first" and "second" row is often tricky. Procedural languages like Base SAS are much better suited for this.

So even with the best (SQL) query wizard it would be rather hard to set up this query.

Why not use the possibilities EG gives you - which in this case would be the programming window.

HTH
Patrick