BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
robertrao
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

5 REPLIES 5
robertrao
Quartz | Level 8

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
Super User

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
Quartz | Level 8

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
Super User

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

.


pic1.JPGpic2.JPG

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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