Date:         Tue, 29 Aug 2006 06:44:16 -0700
Reply-To:     baobaoke <baobaoke@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         baobaoke <baobaoke@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Odd CSV export from the result after PROC TRANSPOSE
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hi,

I have a data matrix as below:

ID    Field         Value
1     Gender        M
2     Age            24
2     Height          6"
4     Age            25
5     Height         5'11"
5     Gender         F

after PROC TRANSPOSE, it's perfectly converted to what I want:

ID      Gender      Age         Height
1           M
2                         24             6"
4                         25
5           F                             5'11"

The trouble came whan I tried to export the result into a CSV file,
which is a completely mess. It might be caused by the data format of
these variables as they are all set to be Text format with length of
16. Or it might be some other reason?

Appreciate it.