Date: Wed, 20 Dec 2006 11:11:31 -0800
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: Drop data when exporting to Excel
Content-Type: text/plain; charset="us-ascii"
Just curious, why are you using 'DBMS=CSV' if you're creating an Excel
Try changing it to 'DBMS=EXCEL'... assuming you are licensed for PC
Could be that comma's in the data are the culprit?... reply back to
> 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
> 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;
> Is there any way to overcome this issue.