Date:         Wed, 20 Aug 2008 09:42:29 -0700
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: export dataset
Comments: To: ash007 <RamsamyAshley@GMAIL.COM>
In-Reply-To:  A<30d7f4e4-fc53-4718-a1c9-18285c25c894@59g2000hsb.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Excel 2003 and before have a limit of 256 columns and 65536 rows - I
don't know about the new Vista Office Excel.

You can have multiple sheets though, so you can break your data into six
spreadsheets within one workbook sharing a key field.

You can also get around the row limit using pivot table data sources,
but not the column limit to my knowledge.

Paul Choate
DDS Data Extraction
(916) 654-2160
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
ash007
Sent: Wednesday, August 20, 2008 8:09 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: export dataset

hello,

is there a possibility to export a dataset of 1 428 columns into a
excel sheet.

thank to tell me.

ash007.