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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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