BookmarkSubscribeRSS Feed
Harsh11387
Calcite | Level 5
libname xls pcfiles path="&dispout."; 

	proc sql noprint;
		drop table xls.DispositionANew,
                   xls.DispositionBNew, 
				   %if &ds_tte. %then %do;
				    %do a = 1 %to &num_dsd.;
					 xls.Sheet&a.,
					 xls.Sheet&a.E,
				    %end;
				   %end;
	               xls.Info
                   ;
	quit; 


	data xls.DispositionANew;
		set final_dispositionA;
	run;

For above SAS code, I am getting an error while reading excel files(.xls) files. As we have excel files into .xls format so we can't change engine to "XLSX". Currently I am using SAS v9.4 for running code. Kindly see below snippet of error.

 

Any suggestions would be appreciated to fix this code. 

 

ERROR: Unable to locate pcfserver.exe. Please install PC Files Server.
ERROR: Error in the LIBNAME statement.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.DispositionANew has not been dropped.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.DispositionBNew has not been dropped.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.Sheet1 has not been dropped.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.Sheet1E has not been dropped.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.Sheet2 has not been dropped.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.Sheet2E has not been dropped.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.Sheet3 has not been dropped.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.Sheet3E has not been dropped.
ERROR: Libref XLS is not assigned.
WARNING: Table XLS.Info has not been dropped.
2 REPLIES 2
PaigeMiller
Diamond | Level 26
ERROR: Unable to locate pcfserver.exe. Please install PC Files Server.

What does macro variable &DISPOUT resolve to? 

--
Paige Miller
Harsh11387
Calcite | Level 5
/* location and filename of the output */
	%global outfile outpath;
	%let outpath = &top_dir.\Outputs;
	%let outfile = Disposition.xls;

	%global dispout errout;
	%let dispout = &outpath.\&outfile.;	

Please see above mention code for macro variable resolution.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1152 views
  • 0 likes
  • 2 in conversation