SAS-L archives -- November 2001, week 1 (#126)

Date:	Fri, 2 Nov 2001 12:05:39 -0500
Reply-To:	gregory.john.toland@CENSUS.GOV
Sender:	"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:	gregory.john.toland@CENSUS.GOV
Subject:	SQL Help (Flatten Data)
Content-type:	text/plain; charset=us-ascii

I have the following fictious data:

CATEGORY STATECODE ------------------ -------------------- Poverty 45 Farms 45,39 Cold 01,02,05,09 Hot 04,05

Using Proc SQL how can I flatten out the data such the results of the PROC SQL are:

CATEGORY STATECODE ------------------ -------------------- Poverty 45 Farms 45 Farms 39 Cold 01 Cold 02 Cold 05 Cold 09 Hot 04 Hot 05

Any help would be great! :)

Gregory J Toland Sr. Systems Architect CHM, Inc. (301) 457-8058 tolan002@census.gov