importing excel and output as text ??/

allurai0412 — Thu, 24 Jan 2013 09:29:57 GMT

hi ,

I have some fileds(included only frist row) in the excel format.

I would like to have in text (text output2) file (required format) .....

I am unable to change it to txt format (text output2) , as it is confusing me in spaces an zeros.

Please find my import file (excel input) (WITH variables position in text file)

outputtextfile(text output2)

please help..

Regards

ALLU

Re: importing excel and output as text ??/

Jagadishkatam — Thu, 24 Jan 2013 11:42:53 GMT

Hi Allu,

Please try the below code

libname mylib "location";

data _null_;

set work.excel;

file "location\file.txt";

put @1 ISIN_NO @20 credit_units @40 f3;

run;

Thanks,

Jagadish