01-04-2017 06:47 AM
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?
01-04-2017 08:51 AM - edited 01-04-2017 08:52 AM
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
Whats the problem creating an easy inputmask and make all options clickable...
Anyways, is there any documentation on how to use the File Writer?
01-04-2017 10:59 PM - edited 01-04-2017 11:05 PM
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.
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:
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.