topic Re: Programming 1: Exporting data into excel workbook, usage of libref. in Programming 1 and 2

Programming 1: Exporting data into excel workbook, usage of libref.

palvani — Tue, 25 May 2021 18:41:53 GMT

libname xl_lib xlsx "&outpath/storm.xlsx" ;

data xl_lib.storm_final;
set pg1.storm_final;
drop Lat Lon Basin OceanCode;
run;

*libname xl_lib clear;

Question: As per the demo in the course, this code should not generate any output data displayed in SAS studio as we are writing the same to excel workbook. clearing the libref at the end of the program is to remove reference to the library. why am I able to see output data if I don't clear libref and if I clear the libref, output data is not generated?

Re: Programming 1: Exporting data into excel workbook, usage of libref.

Reeza — Tue, 25 May 2021 18:47:01 GMT

What do you mean by "see output data"? No data will be written to the RESULTS window, but you will get a data set in your XL_LIB library.
Your second libname statement is commented out, so does not execute, which means your libref stays around.

If your libref is de-assigned/cleared the file still exists on your computer/in the folder but SAS won't have direct access via the libname.

Re: Programming 1: Exporting data into excel workbook, usage of libref.

palvani — Tue, 25 May 2021 18:57:43 GMT

My question is how does clearing libref influences whether any data is visible in Output Data window in SAS studio?
I have commented the libname statement as part of testing so pl ignore that.
Results window is empty as we are not printing any data here.

Re: Programming 1: Exporting data into excel workbook, usage of libref.

palvani — Tue, 25 May 2021 19:02:48 GMT

Thanks Reeza. I think i get it. If I dnt clear the libref, SAS displays data from newly created dataset in Output Window.

Re: Programming 1: Exporting data into excel workbook, usage of libref.

Reeza — Tue, 25 May 2021 19:07:55 GMT

Clearing a libref means that you no longer see it under Libraries and it does not show up in the OUTPUT Data window either since the library is now un-assigned.

Re: Programming 1: Exporting data into excel workbook, usage of libref.

Reeza — Tue, 25 May 2021 19:10:04 GMT

This behavior will vary based on the SAS interface to some degree as well.
Base/Foundation has no output data tab in the first place.
EG does, but that could also be suppressed via other options.

For Studio, with default SAS settings, you're correct.