hi , im writing this data aosi.BDI59_PITUACHreg2; if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then shiuch_m1=1; else shiuch_m1=0; if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then test_mira=1; else test_mira=0; if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then www=1; else www=0; if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then mir=1; else mir=0; set aosi.BDI59_PITUACH; run; proc sql ; title "shiuch_m1"; select shiuch_m1,sum(keshel) as keshel from aosi.BDI59_PITUACHreg2 group by 1; quit; proc sql ; title "test_mira"; select test_mira,sum(keshel) as keshel from aosi.BDI59_PITUACHreg2 group by 1; quit; proc sql ; title "mir"; select mir,sum(keshel) as keshel from aosi.BDI59_PITUACHreg2 group by 1; quit; proc sql ; title "www"; select www,sum(keshel) as keshel from aosi.BDI59_PITUACHreg2 group by 1; quit; the output is this shiuch_m1 shiuch_m1 keshel 0 7 1 57 test_mira test_mira keshel 0 0 1 64 mir mir keshel 0 7 1 57 www www keshel 0 7 1 57 please , i think my sas go crazy and im losing my mind help? thanks a lot
... View more