Changeset 20962 in main
- Timestamp:
- 07/05/20 14:15:38 (7 months ago)
- Location:
- adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/birth
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/birth/EPHT_Count_data_frame.def
r19939 r20962 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; -
adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/birth/EPHT_Percentage_data_frame.def
r19939 r20962 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/_EPHT/birth/EPHT_RateCrude1K_data_frame.def
r19939 r20962 86 86 create table rate as 87 87 select tmp.*, pop.* 88 from tmp ,pop89 where88 from tmp left join pop 89 on 90 90 ?popcross1? tmp.%cross1%=pop.%popcross1%; 91 91 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 102 102 create table rate as 103 103 select tmp.*, pop.* 104 from tmp, pop 105 where tmp.%cross1%=pop.%popcross1% and 104 from tmp left join pop 105 on 106 tmp.%cross1%=pop.%popcross1% and 106 107 tmp.%cross2%=pop.%popcross2%; 107 108 quit;
Note: See TracChangeset
for help on using the changeset viewer.