SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DataFlux text file output

Reply
Occasional Contributor
Posts: 17

DataFlux text file output

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!

 

Trusted Advisor
Posts: 1,131

Re: DataFlux text file output

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
Occasional Contributor
Posts: 17

Re: DataFlux text file output

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 

Ask a Question
Discussion stats
  • 2 replies
  • 285 views
  • 0 likes
  • 2 in conversation