Date:         Mon, 12 Jan 2009 14:43:27 -0800
Reply-To:     Steve James <spj1@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Steve James <spj1@CDC.GOV>
Organization: http://groups.google.com
Subject:      Read Multiline Cell Data in Excel
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

I've got an MS Excel 2003 Workbook with cells that have multiple lines
of data in it.  Lines are separated by a NewLine character.  I want to
read it into SAS and put each line on a new observation

I have

Cell A1
1 = Male
2 = Female
9 = Unknown

OBS    F1
1         1 = Male
2         2 = Female
3         9 = Unknown

Any easy way to do this?

Steve