DATA Step, Macro, Functions and more

Proc Export

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,041
Accepted Solution

Proc Export

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


Accepted Solutions
Solution
‎12-10-2012 12:34 PM
Super User
Posts: 19,817

Re: Proc Export

Posted in reply to robertrao

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

.


pic1.JPGpic2.JPG

View solution in original post


All Replies
PROC Star
Posts: 7,474
Super Contributor
Posts: 1,041

Re: Proc Export

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

Super User
Posts: 19,817

Re: Proc Export

Posted in reply to robertrao

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

Super Contributor
Posts: 1,041

Re: Proc Export

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

Solution
‎12-10-2012 12:34 PM
Super User
Posts: 19,817

Re: Proc Export

Posted in reply to robertrao

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

.


pic1.JPGpic2.JPG
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 272 views
  • 6 likes
  • 3 in conversation