Joe,

What are you trying to do to the data to get the desired output? How is DEMAND1 created?

Jack

Jack Clark Senior Research Analyst phone: 410-455-6256 fax: 410-455-6850 jclark@hilltop.umbc.edu

University of Maryland, Baltimore County Sondheim Hall, 3rd Floor 1000 Hilltop Circle Baltimore, MD 21250

Confidentiality Notice: This e-mail may contain information that is legally privileged and that is intended only for the use of the addressee(s) named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying of this e-mail, distribution, or action taken in reliance on the contents of this e-mail and/or documents attributed to this e-mail is strictly prohibited. If you have received this information in error, please notify the sender immediately by phone and delete this entire e-mail. Thank you.-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of SUBSCRIBE SAS-L Joe H. Smith Sent: Thursday, April 02, 2009 8:16 AM To: SAS-L@LISTSERV.UGA.EDU Subject: proc sql;

Hi all;

i have data like this...

item demand A 0 B 1 A 5 B 2

I want my output like this

item demand1 A 1 B 0

i have tried using proc sql but i cant do this... can an yone of you help me please..

Thanks & regards