tag:blogger.com,1999:blog-1275149608391671670.post1516362553375633976..comments2019-11-13T01:12:52.087-05:00Comments on SAS and R: Example 7.18: Displaying missing value categories in a tableKen Kleinmanhttp://www.blogger.com/profile/09525118721291529157noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1275149608391671670.post-18217514508773549892011-09-22T09:03:15.353-04:002011-09-22T09:03:15.353-04:00Really hard to tell, without the data and an idea ...Really hard to tell, without the data and an idea of what you want to get. if can post or send it, I'd be happy to look at it.Ken Kleinmanhttps://www.blogger.com/profile/09525118721291529157noreply@blogger.comtag:blogger.com,1999:blog-1275149608391671670.post-58028102921317145212011-09-20T13:40:38.400-04:002011-09-20T13:40:38.400-04:00I would like to display all "Grade"s in ...I would like to display all "Grade"s in the following example even when data is missing. How could I accomplish thsi? Printmiss in my proc freq doesn't seem to work:<br /><br />/** GRADE 7**/<br />DATA MATH7;<br />LENGTH Grade $30;<br /> SET star;<br /> IF recordtype = '01' and CST_CMA_Math_Rpt='1' and CST_Math_Incl IN ("Y", "R") and TestGrdLvl='07';<br /> IF CST_Math_Incl= "R" THEN CST_MATH_PL ='1';<br /> IF CST_MathTst IN (" ", "0")THEN Grade = "Grade 07"; IF CST_MathTst="3" THEN Grade = "Grade 07 Algebra 1"; IF CST_MathTst ="5" THEN Grade = "Grade 07 Geometry";<br /> IF CST_MathTst ="7" THEN Grade = "Grade 07 Algebra 2"; IF CST_MathTst ="4" THEN Grade = "Grade 07 Int Math 1"; IF CST_MathTst ="6" THEN Grade = "Grade 07 Int Math 2";<br /> KEEP StdNum Grade CST_MathTst CST_Math_PL CST_Math_SS ;<br /> RUN;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1275149608391671670.post-86480780375780584922010-10-25T08:52:30.486-04:002010-10-25T08:52:30.486-04:00I don't think I understand the question. Can ...I don't think I understand the question. Can you provide an example of what the data look like and how you want the table to look?Ken Kleinmanhttps://www.blogger.com/profile/09525118721291529157noreply@blogger.comtag:blogger.com,1999:blog-1275149608391671670.post-74719156962779395012010-10-25T05:02:27.018-04:002010-10-25T05:02:27.018-04:00If one wants to include missing categories (NOT mi...If one wants to include missing categories (NOT missing value in the original data NOR the freq of missing values) in an output dataset, then how does one od that. I don't want to use the weight option, because for that I will have to add some dummy values to my data (or else create another dataset).Anonymousnoreply@blogger.com