SAS Support Communities

Thank you!   ... View more

Hmmmm....the proc freq still doesn't work. Is there something wrong with the data step? 105 /*proc contents data='H:\PCORI\Deliveries\pcori_preg_diag_final.sas7bdat';*/ 106 /*run; */ 107 108 proc freq; 109 category; -------- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 110 run; ... View more

Thank you for your speedy reply. The code you shared worked!:)   ... View more

I have no idea how that smiley face showed up in my code! ... View more

This is extremely helpful! Thanks for taking the time to share this. Best, Mary ... View more

I was trying to convert the alphabetic characters to numeric. Are you saying that converting the alphanumeric variables to numeric isn't possible with a statement like this,   else if Gradeb='9th' or Gradeb='10th' then GradeNu3=2;   How else might I go about creating a numeric variable from this Gradeb variable?   Thank you! Mary ... View more

Thank you!   ... View more

This is only slightly better.   The SAS System   The FREQ Procedure Frequency Percent Row Pct Col Pct Table of GradeNu3 by Grade GradeNu3 Grade(Grade) 10th 11th 12th 9th College/Technical school Ungraded Total 1 17 6.85 14.05 100.00 26 10.48 21.49 100.00 78 31.45 64.46 100.00 0 0.00 0.00 0.00 0 0.00 0.00 0.00 0 0.00 0.00 . 121 48.79     2 0 0.00 0.00 0.00 0 0.00 0.00 0.00 0 0.00 0.00 0.00 1 0.40 100.00 100.00 0 0.00 0.00 0.00 0 0.00 0.00 . 1 0.40     5 0 0.00 0.00 0.00 0 0.00 0.00 0.00 0 0.00 0.00 0.00 0 0.00 0.00 0.00 126 50.81 100.00 100.00 0 0.00 0.00 . 126 50.81     Total 17 6.85 26 10.48 78 31.45 1 0.40 126 50.81 0 0.00 248 100.00 Frequency Missing = 29   ... View more

Yes, indeed I did! Thank you for catching that.   I put that in and re-ran this code:   /*Create a new file*/ data oahbl_Recode_20190620; /*Set the file to be accessed*/ set OAH_BL; Gradeb=left(trim(Grade)); If Gradeb<='8th' then GradeNu3=1; else if Gradeb='9th' or Gradeb='10th' then GradeNu3=2; else if Gradeb='11th' or Gradeb='12th' then GradeNu3=3; else if Gradeb=' ' then GradeNu3=.; else if Gradeb='High school graduate or GED' then GradeNu3=4; else if Gradeb='College/Technical school' then GradeNu3=5; run;   And end up with the output below: Table of GradeNu3 by GradeGradeNu3 Grade(Grade)10th 11th 12th 9th College/Technicalschool Ungraded Total125TotalFrequency Missing = 29 17 6.85 14.05 100.00 26 10.48 21.49 100.00 78 31.45 64.46 100.00 0 0.00 0.00 0.00 0 0.00 0.00 0.00 0 0.00 0.00 . 121 48.79     0 0.00 0.00 0.00 0 0.00 0.00 0.00 0 0.00 0.00 0.00 1 0.40 100.00 100.00 0 0.00 0.00 0.00 0 0.00 0.00 . 1 0.40     0 0.00 0.00 0.00 0 0.00 0.00 0.00 0 0.00 0.00 0.00 0 0.00 0.00 0.00 126 50.81 100.00 100.00 0 0.00 0.00 . 126 50.81     17 6.85 26 10.48 78 31.45 1 0.40 126 50.81 0 0.00 248 100.00   I checked the raw data and there should be records in groups 3 and 4. Thank you and please excuse the centering of my desk!! ... View more