BookmarkSubscribeRSS Feed
margautz
Fluorite | Level 6

Hello!

 

I am new and I have a trivial issue with the text file output.

 

I put the .csv extension (double quotation mark as the text qualifier and comma as field delimiter), but I could not have an excel output file with one field in each column. It is like a .txt file

e.g.

ID,"name"

0,"AAA"

1,"BBB"

2,"CCC"

 

Thank you for your help!

 

2 REPLIES 2
Jagadishkatam
Amethyst | Level 16

considering that you have the data in a new.txt file as below and you try to create a csv file as jk.csv

 

ID,"name"

0,"AAA"

1,"BBB"

2,"CCC"

 

filename n '~path\new.txt';
data _null_;
infile n delimiter=',';
file '~path\jk.csv';
input;
put _infile_;
run;

Please try and let me know if it helps.

Thanks,
Jag
margautz
Fluorite | Level 6

Hello,

 

thank you for your reply.

 

Yes, I know can I create a csv using SAS, but with DataFlux I expect that I can create it directly.

In the course note of DataFlux there is a description to do that after the "Surviving Record Identification" explanation, but in my case it does not work and I would like to know if it is possible to do that also after the "Clustering".

 

Thank you again 

SAS Innovate 2025: Register Today!

 

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1213 views
  • 0 likes
  • 2 in conversation