How to convert an XML file name to a valid sas filename on a Unix server

alepage — Tue, 30 Jan 2024 20:37:45 GMT

Hello,

I have unzipped a xml file which name is Virage Survey.xml but as you are awarded of, it is not a valid, so how to convert this file name to a valid SAS file name. Can we also rename this file.

Re: How to convert an XML file name to a valid sas filename on a Unix server

Ksharp — Thu, 01 Feb 2024 03:06:14 GMT

/*You could rename these files by RENAME() funtion.*/
%let path= c:\temp\ ;  *the folder included "Virage Survey.xml" ;
data _null_;
rc=filename('x',"&path.");
did=dopen('x');
do i=1 to dnum(did);
 fname=dread(did,i);
 rc=rename(cats("&path.\",fname),cats("&path.\",compress(fname,'._','kad')),'file');
end;
did=dclose(did);
run;

topic How to convert an XML file name to a valid sas filename on a Unix server in SAS Enterprise Guide

How to convert an XML file name to a valid sas filename on a Unix server

Re: How to convert an XML file name to a valid sas filename on a Unix server