topic OPTIONS MISSING='' does not work in IMap in ODS and Base Reporting

OPTIONS MISSING='' does not work in IMap

SanjayM — Tue, 05 Apr 2011 09:54:17 GMT

Hello,

I am using OPTIONS MISSING='' for a dataset which has balance.

When used in EG it works when the dataset is opened. the missing values are shown as blanks.

However, when the same dataset is created through an SP which is used in an IMap, the missings are not shown as blanks.

Regards
Sanjay

Re: OPTIONS MISSING='' does not work in IMap

SanjayM — Tue, 05 Apr 2011 10:01:52 GMT

To make it more clear

SP Code is
OPTIONS missing='';
data wrstemp.a_delete;
length a 8;

a=1234.543;output;
a=.;output;
a=10;output;
run;

This SP creates a dataset in wrstemp.

An Information Map uses this dataset to display the data which is using the above SP in the IMap.

This Imap is then selected in Web Report Studio as data and displayed.

The above code is just an example to describe the issue.

Re: OPTIONS MISSING='' does not work in IMap

Cynthia_sas — Tue, 05 Apr 2011 15:20:49 GMT

Hi:
This is not an ODS or Base Reporting procedure issue. The MISSING option in Base SAS works to alter the DISPLAYED value of a missing variable value -- such as when you use PROC PRINT, PROC REPORT, PROC MEANS, PROC FREQ, etc. The MISSING option does NOT change the internally stored value of the missing value -- it is the internally stored value that your information map is using.

Your best bet for help with an Information Map and Web Report Studio question is to work with Tech Support. I believe if you had OPTIONS MISSING=' '; (quote space quote) BEFORE a PROC PRINT, then your displayed results in a stored process would show a blank instead of missing. However, I do not believe your existing code will work as you expect.

Tech Support can gather version and configuration information from you and can test a similar stored process in the same enviroment.

cynthia

Re: OPTIONS MISSING='' does not work in IMap

Ksharp — Thu, 07 Apr 2011 09:31:01 GMT

Do you try to use proc formate ?

Ksharp

Re: OPTIONS MISSING='' does not work in IMap

Ksharp — Thu, 07 Apr 2011 09:36:31 GMT

Do you try to use proc formate ?

Ksharp