topic file extension change in SAS Procedures

file extension change

shankar_kumar — Thu, 19 May 2011 12:33:11 GMT

Hi Everyone

I am working on SAS enterprise Guide in WINDOWS XP environment.

As part of my automation work, I need to convert some of the excel files (.xls, .xlsx) to .csv files due to some issues in handling .xls and .xlsx files directly.

Do you know any way in SAS using which I can convert file in one extension to another - of course as per the operating environment which in my case is XP?

Appreciate your co-operation.

Thanks
Shankar

Re: file extension change

Ksharp — Fri, 20 May 2011 02:29:55 GMT

That is easy.Assuming all your xls file in c:\temp
[pre]

filename csv pipe 'dir c:\temp\*.xls* /b';
data _null_;
file 'c:\rename.bat';
infile csv length=len;
input name $varying100. len;
str='rename '||strip(name)||' '||strip(scan(name,1,'.'))||'.csv';
put str;
run;
x 'c:\rename.bat';
x 'del c:\rename.bat';
run;
[/pre]

Ksharp

Re: file extension change

DouglasMartin — Fri, 20 May 2011 16:56:11 GMT

That is just going to rename them, not convert them.

Re: file extension change

Ksharp — Mon, 23 May 2011 00:18:43 GMT

Maybe you need to use Google to search some software which can convert xls into csv automatically.

Ksharp