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
Click the downloads tab. There's a link there, click that. Then find the file it specified. See the attached pictures
.
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
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
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
Click the downloads tab. There's a link there, click that. Then find the file it specified. See the attached pictures
.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.