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

SAS Data Integration Studio - File Writer Transformation

Reply
Contributor
Posts: 42

SAS Data Integration Studio - File Writer Transformation

How does this transformation work? I m trying to export a csv from DIS. I cant find any information in the manual or anywhere else.

Super User
Posts: 5,426

Re: SAS Data Integration Studio - File Writer Transformation

Unfortunately, this is not one of the best transformations in DI Studio.

This and the File Reader transformations rely quite much on the external file metadata, which leads to some confusion since some options there are named for import (INFILE/INPUT) rather than export.

It takes a little trial and error, but basically it will work like the File Reader.

 

There are some other posts here on the subject that might give some hints?

Data never sleeps
Contributor
Posts: 42

Re: SAS Data Integration Studio - File Writer Transformation

[ Edited ]

What are you searching for? I couldn't find anything helpful. I also dont understand why it has to be such a painful procedure to do something as simple as exporting data into a textfile.

 

I helped myself by creating a user written transformation.

 

proc export data = WORK.OUTPUT
outfile = exprt
dbms=dlm replace;
putnames=yes;
delimiter=';';
run;

 

Whats the problem creating an easy inputmask and make all options clickable...

 

Anyways, is there any documentation on how to use the File Writer?

Respected Advisor
Posts: 4,173

Re: SAS Data Integration Studio - File Writer Transformation

[ Edited ]

DIS is metadata driven so in order to write to any external file you first need a metadata definition of this external file (External File).

It's then this External File metadata definition which drives code generation (so that's the place where you define that it's a .csv and not in the File Writer).

 

You find step by step instructions of how to use the File Writer transformation directly in the help section of DIS.

Capture.PNG

 

You can also get to DIS documentation with a simple Google search like:

site:support.sas.com dis 4.9 file writer

 

Which then returns results like:

http://support.sas.com/documentation/cdl/en/etlug/67323/HTML/default/viewer.htm#p1iseinka4r546n1qv8j...

 

 

If you're an experienced SAS coder then coding directly is sometimes quicker than figuring out how it's done via metadata. User Written code is not good practice and should always be your last resort - which isn't the case here.

Contributor
Posts: 42

Re: SAS Data Integration Studio - File Writer Transformation

Thank you for pointing that out. I searched on the SAS support, but couldnt find it.

Ask a Question
Discussion stats
  • 4 replies
  • 607 views
  • 1 like
  • 3 in conversation