topic Re: How to close file handler?! in SAS Programming

How to close file handler?!

hellohere — Thu, 10 Mar 2022 06:06:59 GMT

Using proc export to dump dataset into an xlsx file. It used to fine. Somehow this time it does not success.

It created a file and cannot be deleted(prompt says it is being used in SAS).

Re: How to close file handler?!

hellohere — Thu, 10 Mar 2022 06:08:17 GMT

The files created shown as vrf_summ_1100_all_2var.$$1

%let outds=vrf_summ_&ts._all_2var;
proc export data=&outds.
outfile="C:\sasOUT\&outds..xlsx"
dbms=xlsx replace; run;quit;

Re: How to close file handler?!

Kurt_Bremser — Thu, 10 Mar 2022 06:10:00 GMT

Does your problem arise in SAS? If yes, post the complete log of the failing step.

If not: what kind of storage do you use for your Excel file?

Re: How to close file handler?!

hellohere — Thu, 10 Mar 2022 06:30:37 GMT

e... just restart SAS and the file is deleted.

Re: How to close file handler?!

hellohere — Thu, 10 Mar 2022 06:35:34 GMT

Now it is fine. It used to "it is not spreadsheet or it is damaged" alike.

MPRINT(BL_SUMM): proc export data=vrf_summ_1100_all outfile="C:\Users\24891\Desktop\sasOUT\vrf_summ_1100_all.xlsx" dbms=xlsx replace; MPRINT(BL_SUMM): WXLX; MPRINT(BL_SUMM): run; NOTE: The export data set has 4752 observations and 8 variables. NOTE: "C:\Users\24891\Desktop\sasOUT\vrf_summ_1100_all.xlsx" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.21 seconds cpu time 0.18 seconds

Re: How to close file handler?!

Kurt_Bremser — Thu, 10 Mar 2022 07:28:17 GMT

Please do always (as in ALWAYS) post logs by copy/pasting into a window opened with this button:

so that all formattng is kept. The "little running man" right next to it is for posting SAS code (it provides coloring similar to the SAS Enhanced Editor).

The behavior of Windows with regards to when open files are closed is erratic, to say the least. It may also be that you have some background activity (malware protection) that automatically scans Excel files when such arrive in the filesystem.