Thanks Scott for your reponse.
But I am looking for non empty output dataset from proc means for the input empty dataset.
Here is my format for the class variable.
proc format
VALUE $REGION
'A','B','C','E' = 'ATLANTIC REGION'
'G','J','H' = 'QUEBEC REGION'
OTHER = 'REGION ERROR'
;
RUN;
PROC FORMAT;
VALUE MKTSEG
1='COMMERICAL '
2='SMALL BUSINESS'
;
run;
My expected resulst for the empy data set is as follows. All values are not alligned here; I tried my best to make allign. Since I put completetypes and PRELOADFMT. I expect, for any empyt dataset, the proc means to produce all possible values of class variables according to my format and the related var values to be zero or missing .
My target to produce a report either the dataset is empty or non empty. For non empty dataset it is working fine.
For empty dataset, I want to produce a report for my customer, for the following Business type and the region, the values(var ) are zero.
Thanks for the help again
Inp
OSBAL_ LIMIT_COUNTCUST_ LOANNO_
OBS RPTSEG REGION Sum Sum Sum Sum OSBAL_N LIMIT_N N LNO_N
1 COMMERICAL ATLANTIC REGION . . . . 0 0 0 0
2 COMMERICAL QUEBEC REGION . . . . 0 0 0 0
3 COMMERICAL REGION ERROR . . . . 0 0 0 0
4 SMALL BUSINESS ATLANTIC REGION . . . . 0 0 0 0
5 SMALL BUSINESS QUEBEC REGION . . . . 0 0 0 0
6 SMALL BUSINESS REGION ERROR . . . . 0 0 0 0
... View more