BookmarkSubscribeRSS Feed
allurai0412
Fluorite | Level 6

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

1 REPLY 1
Jagadishkatam
Amethyst | Level 16

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 783 views
  • 4 likes
  • 2 in conversation