Changeset 20947 in main
- Timestamp:
- 07/05/20 13:55:54 (7 months ago)
- Location:
- adopters/nm/trunk/src/main/backend_qModules/3.0/infmort
- Files:
-
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
adopters/nm/trunk/src/main/backend_qModules/3.0/infmort/NM_CountBirthPop_data_frame.def
r19939 r20947 111 111 create table rate as 112 112 select tmp.*, pop.* 113 from tmp ,pop114 where113 from tmp left join pop 114 on 115 115 ?popcross1? tmp.%cross1%=pop.%popcross1%; 116 116 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 127 127 create table rate as 128 128 select tmp.*, pop.* 129 from tmp, pop 130 where tmp.%cross1%=pop.%popcross1% and 129 from tmp left join pop 130 on 131 tmp.%cross1%=pop.%popcross1% and 131 132 tmp.%cross2%=pop.%popcross2%; 132 133 quit; -
adopters/nm/trunk/src/main/backend_qModules/3.0/infmort/NM_RateCrudeBirthPop1K_3YrAvg_df.def
r19939 r20947 108 108 create table numbers as 109 109 select tmp.*, pop.* 110 from tmp ,pop111 where110 from tmp left join pop 111 on 112 112 ?popcross1? tmp.%cross1%=pop.%popcross1%; 113 113 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 124 124 create table numbers as 125 125 select tmp.*, pop.* 126 from tmp, pop 127 where tmp.%cross1%=pop.%popcross1% and 126 from tmp left join pop 127 on 128 tmp.%cross1%=pop.%popcross1% and 128 129 tmp.%cross2%=pop.%popcross2%; 129 130 quit; -
adopters/nm/trunk/src/main/backend_qModules/3.0/infmort/NM_RateCrudeBirthPop1K_5YrAvg_df.def
r19939 r20947 108 108 create table numbers as 109 109 select tmp.*, pop.* 110 from tmp ,pop111 where110 from tmp left join pop 111 on 112 112 ?popcross1? tmp.%cross1%=pop.%popcross1%; 113 113 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 124 124 create table numbers as 125 125 select tmp.*, pop.* 126 from tmp, pop 127 where tmp.%cross1%=pop.%popcross1% and 126 from tmp left join pop 127 on 128 tmp.%cross1%=pop.%popcross1% and 128 129 tmp.%cross2%=pop.%popcross2%; 129 130 quit; -
adopters/nm/trunk/src/main/backend_qModules/3.0/infmort/NM_RateCrudeBirthPop1K_data_frame.def
r19939 r20947 110 110 create table numbers as 111 111 select tmp.*, pop.* 112 from tmp ,pop113 where112 from tmp left join pop 113 on 114 114 ?popcross1? tmp.%cross1%=pop.%popcross1%; 115 115 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 126 126 create table numbers as 127 127 select tmp.*, pop.* 128 from tmp, pop 129 where tmp.%cross1%=pop.%popcross1% and 128 from tmp left join pop 129 on 130 tmp.%cross1%=pop.%popcross1% and 130 131 tmp.%cross2%=pop.%popcross2%; 131 132 quit; -
adopters/nm/trunk/src/main/backend_qModules/3.0/infmort/S_ND_CountBirthPop_data_frame.def
r19939 r20947 110 110 create table rate as 111 111 select tmp.*, pop.* 112 from tmp ,pop113 where112 from tmp left join pop 113 on 114 114 ?popcross1? tmp.%cross1%=pop.%popcross1%; 115 115 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 126 126 create table rate as 127 127 select tmp.*, pop.* 128 from tmp, pop 129 where tmp.%cross1%=pop.%popcross1% and 128 from tmp left join pop 129 on 130 tmp.%cross1%=pop.%popcross1% and 130 131 tmp.%cross2%=pop.%popcross2%; 131 132 quit; -
adopters/nm/trunk/src/main/backend_qModules/3.0/infmort/S_ND_RateCrudeBirthPop1K_3YrAvg_df.def
r19939 r20947 108 108 create table numbers as 109 109 select tmp.*, pop.* 110 from tmp ,pop111 where110 from tmp left join pop 111 on 112 112 ?popcross1? tmp.%cross1%=pop.%popcross1%; 113 113 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 124 124 create table numbers as 125 125 select tmp.*, pop.* 126 from tmp, pop 127 where tmp.%cross1%=pop.%popcross1% and 126 from tmp left join pop 127 on 128 tmp.%cross1%=pop.%popcross1% and 128 129 tmp.%cross2%=pop.%popcross2%; 129 130 quit; -
adopters/nm/trunk/src/main/backend_qModules/3.0/infmort/S_ND_RateCrudeBirthPop1K_5YrAvg_df.def
r19939 r20947 108 108 create table numbers as 109 109 select tmp.*, pop.* 110 from tmp ,pop111 where110 from tmp left join pop 111 on 112 112 ?popcross1? tmp.%cross1%=pop.%popcross1%; 113 113 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 124 124 create table numbers as 125 125 select tmp.*, pop.* 126 from tmp, pop 127 where tmp.%cross1%=pop.%popcross1% and 126 from tmp left join pop 127 on 128 tmp.%cross1%=pop.%popcross1% and 128 129 tmp.%cross2%=pop.%popcross2%; 129 130 quit; -
adopters/nm/trunk/src/main/backend_qModules/3.0/infmort/S_ND_RateCrudeBirthPop1K_data_frame.def
r19939 r20947 109 109 create table rate as 110 110 select tmp.*, pop.* 111 from tmp ,pop112 where111 from tmp left join pop 112 on 113 113 ?popcross1? tmp.%cross1%=pop.%popcross1%; 114 114 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 125 125 create table rate as 126 126 select tmp.*, pop.* 127 from tmp, pop 128 where tmp.%cross1%=pop.%popcross1% and 127 from tmp left join pop 128 on 129 tmp.%cross1%=pop.%popcross1% and 129 130 tmp.%cross2%=pop.%popcross2%; 130 131 quit;
Note: See TracChangeset
for help on using the changeset viewer.