Proc Report - force to show all across values

MART1 — Mon, 03 Aug 2020 14:26:19 GMT

Hello everyone

I'm trying to display two rows in Proc Report (across) as headers; however, if the cell for one row does not contain any data, the value from the other row won't be displayed either.

Hopefully the below example will explain it better:

data TEST;                                                                                                                            
   input ENTRY $ WD DAY VALUE;                                                                                                                 
   datalines; 

E1 -1 NULL 12
E1 01 20200803 51
E1 02 20200804 45
E1 03 20200805 15
E1 04 20200806 1
E1 09 2020081 32
E1 10 20200814 11
E1 11 20200817 65
;
run;


proc report data=TEST nowd;
column  ENTRY  WD, DAY, VALUE;
	define WD / 'Working Day' across NOZERO ORDER=DATA;
	define DAY /'' across;
	define ENTRY / group 'ENTRY';
	define VALUE / '' group;

quit;

The report won't show WD= -1 because the correspondent DAY is null.

How can I force it to show it anyway?

Many thanks

Re: Proc Report - force to show all across values

ghosh — Mon, 03 Aug 2020 14:34:17 GMT

Just add missing to Proc report

proc report data=TEST nowd missing;

Re: Proc Report - force to show all across values

MART1 — Mon, 03 Aug 2020 15:22:32 GMT

ah it was so easy, any thanks @ghosht!!

topic Re: Proc Report - force to show all across values in SAS Programming

Proc Report - force to show all across values

Re: Proc Report - force to show all across values

Re: Proc Report - force to show all across values