topic Re: Proc Export in SAS Programming

Proc Export

robertrao — Mon, 10 Dec 2012 16:04:57 GMT

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 — Mon, 10 Dec 2012 16:10:39 GMT

robertrao — Mon, 10 Dec 2012 16:28:21 GMT

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 — Mon, 10 Dec 2012 16:46:56 GMT

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).

robertrao — Mon, 10 Dec 2012 17:19:28 GMT

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 — Mon, 10 Dec 2012 17:34:48 GMT

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