Changeset 21460 in main


Ignore:
Timestamp:
09/03/20 11:10:18 (4 weeks ago)
Author:
LoisHaggard_NM
Message:

NMBIS Backend QModules - hidd

Location:
adopters/nm/trunk/src/main/backend_qModules/3.0/hidd
Files:
3 added
4 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/3.0/hidd/NM_NumHosp.def

    r21336 r21460  
    2222                ?cross2? %cross2%
    2323                ;
     24                format count 15.0 ;
    2425                output out=tmp (drop=_TYPE_ _FREQ_) sum=count;
    2526        proc sort data=tmp out=sorted; by %cross1%
     
    187188                *This also puts ** in record code column for suppressed rows, and adds footnote;
    188189                        redflag = put('Suppressed', $12.);
     190
    189191                end;
     192
    190193                if popcount=. then redflag=put('', $12.); *no value attribute for missing crossby values;
     194
    191195        proc print data=tmp noobs;  title2 '6. TMP - final dataset to pass to IBIS View app';
    192196        run;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/hidd/NM_RateAAHosp10K.def

    r21336 r21460  
    1818        %LET MULTIPLIER=10000;  *Modify the value of MULTIPLIER on this line to the
    1919                                         desired power of 10;
    20         %LET STDVAR=AgePop;     *Modify the value of STDVAR on this line to the desired age
    21                                          grouping from the list, below. STDVAR name is case-sensitive;
     20        %LET STDVAR=agepop;     *Modify the value of STDVAR on this line to the desired age
     21                                         grouping from the list, below.
     22                                         ++++++++++++++STDVAR NAME IS CASE-SENSITIVE+++++++++++++++;
    2223        %LET NCAT=11;           *Modify the value of NCAT on this line to the age
    2324                                         grouping's number of categories - to create agepop frame;
     
    5556                ?cross2? %cross2%
    5657                ;
     58                format count 15.0 ;
    5759                output out=tmp (drop=_TYPE_ _FREQ_) sum=count;
    5860        proc sort data=tmp out=sorted;
    5961                by %cross1% %cross2% &STDVAR.;
    6062                run;
    61         proc print data=tmp noobs;
     63        proc print data=sorted noobs;
    6264                title1 '---------------------------------';
    63                 title2 '1. TMP - numerator dataset';
     65                title2 '1. Sorted TMP - numerator dataset';
    6466                run;
    6567
     
    114116                run;
    115117        proc print data=new_frame noobs; title2 'new_frame, sorted with nodupkey'; run;
    116         proc sort data=tmp out=sorted; by %cross1% %cross2% &STDVAR.; run;
    117         data newtmp;
    118                 merge new_frame tmp;  *must list frame dataset first, then tmp;
     118        data tmp;
     119                merge new_frame sorted;  *must list frame dataset first, then tmp;
    119120                by %cross1% %cross2% &STDVAR.;
    120                 drop _TYPE_ _FREQ_ ;
    121         run;
    122 
    123         proc print data=newtmp noobs;
    124                 title2 '2. NEWTMP, after frame merged with tmp';
    125                 run;
    126         data tmp;
    127                 set newtmp;
    128         run;
     121        run;
     122
     123        proc print data=tmp noobs;
     124                title2 '2. TMP, after new_frame merged ';
     125                run;
    129126
    130127 ************************* 3. POP ***************************************************;
     
    132129 * recode the agepop total records, cross1 and cross2 totals to -1.                  ;
    133130 ************************************************************************************;
    134         data poptmp; format &STDVAR. %popcross1% %popcross2% 8.;
    135                 set poptmp; run; 
    136131        proc summary data=poptmp;
    137132                var popcount;
    138133                class &STDVAR.  %popcross1% %popcross2%;
     134                format popcount 15.0 ;
    139135                output out=pop (drop=_TYPE_ _FREQ_) sum=popcount;
    140136        run;
    141137        data pop;
    142138                set pop;
    143                 drop _TYPE_ _FREQ_;
    144139                proc print data=pop noobs; 
    145140                   title2 '3. POP - denominator dataset';
     
    157152                from tmp left join pop
    158153                on tmp.&STDVAR.=pop.&STDVAR.
    159                 ?popcross1? and tmp.%cross1%=pop.%popcross1%  
     154                ?popcross1? and tmp.%cross1%=pop.%popcross1%
    160155                ?popcross2? and tmp.%cross2%=pop.%popcross2%
    161156                ;
     
    289284        data tmp;
    290285                set rate;
    291                 else if ((0<n<4) and (.<popcount<5000)) then do;
     286                if ((0<n<4) and (.<popcount<5000)) then do;
    292287                        n = .A;
    293288                        rateper = .A;
    294289                        LL = put('**', 8.0);
    295290                        UL = put('**', 8.0);
    296                         *only 1 val attr allowed, over-write redflag if suppressed;
    297                         redflag = put('Suppressed', $10.);
     291
     292                *Only one value attribute is allowed - so if suppressed, overwrite unstable;
     293                *This also puts ** in record code column for suppressed rows, and adds footnote;
     294                        redflag = put('Suppressed', $12.);
     295
    298296                end;
     297
     298                if popcount=. then redflag=put('', $12.); *no value attribute for missing crossby values;
     299
    299300        proc print data=tmp noobs;  title2 '11. TMP - final dataset to pass to IBIS View app';
    300301        run;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/hidd/NM_RateHosp10K.def

    r21336 r21460  
    2828                ?cross2? %cross2%
    2929                ;
     30                format count 15.0 ;
    3031                output out=tmp (drop=_TYPE_ _FREQ_) sum=count;
    3132        proc sort data=tmp out=sorted; by %cross1%
     
    192193        data tmp;
    193194                set rate;
    194                 if popcount=. and (0<=n<4) then delete; *if unknown row is only suppressed row;
    195                 else if (0<n<4) and (.<popcount<5000) then do;
     195                if (0<n<4) and (.<popcount<5000) then do;
    196196                        n = .A;
    197197                        rateper = .A;
     
    202202                *This also puts ** in record code column for suppressed rows, and adds footnote;
    203203                        redflag = put('Suppressed', $12.);
     204
    204205                end;
     206
    205207                if popcount=. then redflag=put('', $12.); *no value attribute for missing crossby values;
     208
    206209        proc print data=tmp noobs;  title2 '6. TMP - final dataset to pass to IBIS View app';
    207210        run;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/hidd/_HIDD18.cfg

    r20049 r21460  
    6464
    65651 null YearProxy year YearofDischarge num 10 8
    66 1 year Year9 year YearofDischarge num 3 8
    67 
    68661 year Year year YearofDischarge num 0 8
    69671 year YearICD9 year YearofDischarge num 0 8
    70681 year YearICD10 year YearofDischarge num 0 8
     691 icdversion ICDVersion null ICD9vs10 num 0 8
     701 year Year9 year YearofDischarge num 3 8
    71711 month Month null MonthofDischarge num 0 8
    72 1 icdversion ICDVersion null ICD9vs10 num 0 8
    7372
    74732 null AgeGrpProxy null AgeProxy num 10 4
    75742 agegrp4 AgeGrp4 agegrp4 Age num 0 8
    76 2 agegrp4ML AgeGrp4Alt agegrp4ML Age num 0 8
     752 agegrp4ML AgeGrp4ML agegrp4ML Age num 0 8
    77762 agegrp7 AgeGrp7 agegrp7 Age num 0 8
    78772 agegrp8 AgeGrp8 agegrp8 Age num 0 8
Note: See TracChangeset for help on using the changeset viewer.