oh it is almost done. yes i want to create dummy-obs on file want with 1 and 0. Pls see my prog codes: proc sql; create table want1 as select a.*,cats('ind',put(b.sic2,z2.)) as dummy_sic2,cats('ind',put(obs,z2.)) as dummy_obs from industry.spi5 as a left join industry.sum5 as b on a.sic2=b.sic2 ; quit; data obs1; do dummy_obs=01 to 72; output; end; run; proc sql noprint; select distinct cats('ind',dummy_obs) into : list separated by ' ' from obs1; quit; data obs2; set work.want1; array _y &list ; do over _y; _y=ifn(dummy_obs=compress(vname(_y),,'kd'), 1,0); end; run; I know something is not right about assigning industry dummy of dummy_obs at 1-72 of the file obs1. How should i code properly so that i see ind#01-ind#72 or ind01 to ind72 at the final output want1? I will attach file want1 and obs2
... View more