While querying the data using Proc SQL from two tables without using aliases, the program seems to run fine without using libref in On clause. How does SAS recognize if the table we are referring to is from work or a particular library(pg1 in the below example)? Ex: proc sql; select Season, Name, storm_summary.Basin, BasinName, MaxWindMPH from pg1.storm_summary inner join pg1.storm_basincodes on storm_summary.Basin = storm_basincodes.Basin order by Season desc, Name; quit;   ... View more

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? ... View more