Date:         Wed, 26 Nov 2003 08:12:39 -0800
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: Pivoted tables in excel
Comments: To: "Katyal, Amit" <amit.katyal@CITIGROUP.COM>

Raj-

There is a pivot table wizard under the Excel "data" drop-down menu that
steps you through the process.

When you export to Excel retain your variable names as column headers and
the pivot wizard will work fine.  Excel handles missing data and dates
differently than SAS, so you need to consider this.

Are you sure you shouldn't be posting to microsoft.public.excel.programming
?


Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: Katyal, Amit [mailto:amit.katyal@CITIGROUP.COM]
Sent: Wednesday, November 26, 2003 2:10 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Pivoted tables in excel

HI,

 I would like to export sas datasets to excel and create pivotedtables in
excel.
 Can u please tell me where can i find more user friendly examples on
pivoted tables.


  thanks & regards
  Raj