Hi, I have scowered resources and board posts but can't find something to fit my needs. I am writing a PROC TABULATE code to print a table with each data set that has an identical structure, irrespective of the data being output. I have one variable and four classes: Yields (var 'ym_yld_a') by BOPKEYSECTOR > by provinces > by currencies. I need ALL currencies to be part of the table, even if my output doesnt produce data for a given currency. Here is my code: - it is very simple - i have tried variations in the ORDER= to make all currencies to be printed even with missing values, but no luck. Does anyone know if this is something can be done? Ive added two photos: 1) what I currently get, usually. 2) the format I want printed, and populated with whatever data is being derived by the program. THANKS! I will continue to work on this but any help is tremendous! PROC TABULATE
DATA=YM.TG_POS_200805_S7;
FORMAT=BEST12.;
VAR YM_YLD_A;
CLASS RTTM_INT / ORDER=UNFORMATTED ;
CLASS BOPKEY_SECTOR / ORDER=UNFORMATTED;
CLASS province / ORDER=UNFORMATTED;
CLASS CURR / ORDER= UNFORMATTED;
TABLE
/* ROW Statement */
BOPKEY_SECTOR *province *CURR ,
/* COLUMN Statement */
RTTM_INT *(YM_YLD_A * Sum={LABEL="Sum"} );
;
RUN;
... View more