How to override output options using EG wizard?

[dfs888]

Hi, I am new to EG4.3 and can't seem to find out how to set the output options.

I am using the Export Wizard to export a csv file but I cannot find out where to change the options.

The output shows missing values as "." but I would rather it be blank in the csv file.

Is there a way to set up the option for missing=' ' or dDo I have to write code?

Thanks

[Doc_Duke]

I don't know a point-n-click option.  You can use the %sas2csv macro so you don't have to write too much code.  --Doc

[art297]

The only dbms option I'm aware of the write missing values as blanks is dbf (i.e., dbase).  If you weren't using EG, I'd suggest recalling the code with function key F4 and just modifying the code.

I'm not sure if the code ends up in the log with EG but, if it does, you could copy and paste it, then modify it to account for this missing values.

Other than that, I'd go with Doc's recommendation.

[dfs888]

Thanks for the insight. Too bad there wasn't a point and click option.