importing excel and output as text ??/

[allurai0412]

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

[Jagadishkatam]

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