Date: Thu, 2 Aug 2001 08:51:29 -0600
Reply-To: Darran Zenger <DZENGER@KLUNE.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Darran Zenger <DZENGER@KLUNE.COM>
Subject: Re: Transform:table excel to SAS
Content-Type: text/plain; charset="iso-8859-1"
Can you get the excel file into SAS with either SAS Access to PC files or
even with DDE you can get it into excel. (Or even convert the excel file to
a CSV file and import it with the Import Wizard or Proc Import.
To transform the data, you can use Proc Transpose.
HTH,
Darran
-----Original Message-----
From: barrere Bendia [mailto:bendiabare@NETSCAPE.NET]
Sent: Thursday, August 02, 2001 8:20 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Transform:table excel to SAS
Hi there. Please Help
I got a table from excel like this:
Table A
Marital status I New York I Main I Philadelphia
---------------I-----------I-----------I----------------
Married I 15 I 23 I 35
Single I 23 I 34 I 71
Widowed I 25 I 61 I 52
---------------------------------------------------------
I would get as SAS Table like this:
Table B
States Marital status Count
--------------------------------------
New York Married 15
New York Single 23
New York Widowed 25
Main Married 23
Main Single 34
Main Widowed 61
Philadelphia Married 35
Philadelphia Single 71
Philadelphia Widowed 52
How to transform Table A to Table B and the reverse way?
Any help would be really appreciated.
Many thanks.
__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/
Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
