this is the log file:
139 proc sql; 140 create table1 as 141 select distinct 142 a.clientreportid 143 ,a.clientuci 144 ,a.sexatbirthid 145 ,2020-birthyear as Age 146 ,a.transgenderid 147 ,a.providerid 148 ,a.povertylevelpercent 149 ,a.HousingStatusId 150 ,stateid format=st. 151 ,birthyear 152 ,case 153 when ethnicityid eq 1 then 6 154 when ethnicityid ne 1 then newrace else . 155 end as racenew 156 ,case when genderid in(6,7,8) then 3 157 when genderid in(4,5) then . else genderid end as Gender3 158 ,a.ethnicityid 159 ,a.genderid 160 from A 161 162 ,(select distinct 163 clientreportid 164 ,providerid 165 ,case when count(*) gt 1 then 7 else raceid end as newrace /*Find multi race clients*/ 166 from clientreportrace 167 group by providerid, clientreportid) as B 168 169 ,(select distinct 170 orgid as Providerid 171 ,stateid 172 ,orgName 173 from report) as C 174 where a.providerid eq b.providerid and a.clientreportid eq b.clientreportid and a.providerid 174! eq c.providerid 175 ; NOTE: The query requires remerging summary statistics back with the original data. NOTE: Table Table created, with 744103 rows and 14 columns.
176 quit; NOTE: PROCEDURE SQL used (Total process time): real time 2:38.51 cpu time 4.79 seconds
... View more