Date:         Wed, 20 Dec 2006 11:11:31 -0800
Reply-To:     jamesgreen55@YAHOO.CA
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         jamesgreen55@YAHOO.CA
Organization: http://groups.google.com
Subject:      Re: Drop data when exporting to Excel
Comments: To: sas-l@uga.edu
In-Reply-To:  <9e2816460612200936jeda30b6i90d9d91575eb0fc3@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

Just curious, why are you using 'DBMS=CSV' if you're creating an Excel
file ???

Try changing it to 'DBMS=EXCEL'... assuming you are licensed for PC
File formats....

Could be that comma's in the data are the culprit?... reply back to
group pls.

James



Joyce wrote:
> Hi All,
>
> I have a problem when exporting dataset into Excel, by using PROC EXPORT.
> Some of the data droping out from the Excel file, but the variable names are
> there. This is happening to the Right Hand Side (Last variables) of the
> Excel file. The First 10-20 variables are correct. The dataset has around 60
> variables.
>
> Something similar to this:
> the dataset structure is:
>
> parm visit trt subj1 subj2.....subj50
>
> AAA   1   A   12    12     ...    15
> ...
> ...
> ...
>
>
>
> I used :
>
> PROC EXPORT DATA=indata OUTFILE='c:\...\out.xls' DBMS=CSV REPLACE;
> RUN;
>
>
> Is there any way to overcome this issue.
> Thanks
> Jo.