Proc Export

[robertrao]

Hi Team,

When I try to export a dataset I get the following error.

Could you please tell me where the problem is??

Thanks

procexport data=kd.final3

outfile="C:\Data\Projects\Nov-2012\20121112002\12-5-2012.xls"

dbms=excelreplace;

run;

ERROR:
Execute: Unable to insert row

WARNING:
File deletion failed for _IMEX_.FINAL3.DATA.

ERROR:
Export unsuccessful.  See SAS Log for
details.

NOTE:
The SAS System stopped processing this step because of errors.

NOTE:
PROCEDURE EXPORT used (Total process time):

      real time           14.74 seconds

      user cpu time       13.47 seconds

      system cpu time     0.82 seconds

      Memory                            831k

      OS Memory                         16248k

      Timestamp            12/10/2012  9:59:50 AM

[art297]

Take a look at: 37478 - An error can occur when you export large volumes of data from the SAS® System to Microsoft E...

[robertrao]

Hi,

The problem is the volume of data as you mentioned.

But how can split the data....i am dealing with approx 250k records

it is the patients per encounter per service date information...

How can I slit the dataset into 3 halves.or something like that.....

Regards

[Reeza]

Can you export to a XLSX file? XLS files have a limit of ~65k rows.

If not see this macro from sas (I haven't used it).

16587 - Exporting SAS® data sets of more than 65,536 rows to Microsoft Excel

[robertrao]

Hi,

Thanks,

It asks us to download

datasplitter2excel2.sas  (for SAS^®9) from the downloads tab..

Could you please explain .i could not find it on the SAS window

Regards

[Reeza · Accepted solution]

Click the downloads tab. There's a link there, click that. Then find the file it specified. See the attached pictures

.