topic How to override output options using EG wizard? in SAS Enterprise Guide

How to override output options using EG wizard?

dfs888 — Thu, 09 Feb 2012 00:46:30 GMT

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

How to override output options using EG wizard?

Doc_Duke — Thu, 09 Feb 2012 02:07:58 GMT

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

How to override output options using EG wizard?

art297 — Thu, 09 Feb 2012 02:14:58 GMT

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.

How to override output options using EG wizard?

dfs888 — Thu, 09 Feb 2012 15:39:30 GMT

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