Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

importing excel and output as text ??/

Reply
Frequent Contributor
Posts: 97

importing excel and output as text ??/

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

Attachment
Trusted Advisor
Posts: 1,131

Re: importing excel and output as text ??/

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

Thanks,
Jag
Ask a Question
Discussion stats
  • 1 reply
  • 238 views
  • 4 likes
  • 2 in conversation