Starting with The FREQ Procedure qual_flag Frequency Percent Cumulative Frequency Cumulative Percent C71_80 C81_90 C91_95 C96_10 MIGRATE 13183 37.72 13183 37.72 11362 32.51 24545 70.23 4506 12.89 29051 83.13 3980 11.39 33031 94.51 1917 5.49 34948 100.0 In SAS 9.1 data sampledown; length sampfactor xyz 8; set finalsample; xyz = ranuni(35); select(qual_flag); when('C71_80') factor = 13183; when('C81_90') factor = 11362; when('C91_95') factor = 4506; when('C96_10') factor = 3980 ; when('MIGRATE') factor = 1917; otherwise put 'ERROROROROROR'; end; sampfactor = 1950 / factor; if xyz le sampfactor then output; run; proc freq data=sampledown; table qual_flag; run; would always give output with distribution of qual_flag very close to 1,950 in all levels. Now in SAS 9.4 I'm getting distribution like The FREQ Procedure qual_flag Frequency Percent Cumulative Frequency Cumulative Percent C71_80 C81_90 C91_95 C96_10 MIGRATE 1937 20.15 1937 20.15 1885 19.61 3822 39.76 1968 20.47 5790 60.24 1905 19.82 7695 80.06 1917 19.94 9612 100.00 Any idea why?
... View more