Desktop productivity for business analysts and programmers

How to override output options using EG wizard?

Reply
Occasional Contributor
Posts: 9

How to override output options using EG wizard?

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

Valued Guide
Posts: 2,111

How to override output options using EG wizard?

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

Esteemed Advisor
Posts: 7,290

How to override output options using EG wizard?

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.

Occasional Contributor
Posts: 9

How to override output options using EG wizard?

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

Ask a Question
Discussion stats
  • 3 replies
  • 160 views
  • 0 likes
  • 3 in conversation