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!
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.
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 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.