topic Re: DataFlux text file output in SAS Data Management

DataFlux text file output

margautz — Wed, 10 Feb 2016 12:49:39 GMT

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!

Re: DataFlux text file output

Jagadishkatam — Wed, 10 Feb 2016 15:02:25 GMT

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.

Re: DataFlux text file output

margautz — Wed, 10 Feb 2016 15:15:24 GMT

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