About clover

clover · ‎06-30-2020

Hi ballardw, thanks for your reply. Yes, I formatted the data before I run frequency, and get the same frequency table as yours. However, what I want is the table Patrick got, indicating 9 as missing, not ' ' in the frequency table. If there is no way doing that in format, I will just re-code the data.

clover · ‎06-30-2020

Hi Patrick, I am doing the same thing as you. I tried different examples and find out that: if the original data has a missing value, as the example you gave(1,2,9, and .), then there would be no problem, '9' will be given to missing. if the original data doesn't have missing value, as the example I gave (1,2, and 9), then '9' will be given to ' ' in the frequency table.

clover · ‎06-29-2020

I have a numerically coded variable, the frequency table is: value frequency 1 33 2 22 9 11 I want to format it so that 1='YES',2='No', 9 is missing do I applied a proc format: proc format; value myformat 1='Yes' 2='No' other=' '; run; After I applied this format to my data and run the proc freq again, the frequency table becomes: value frequency Yes 33 No 22 11 it counts the ' ' as an independent category, not missing value However, what I want is : value frequency yes 33 no 22 frequency missing:11 Is there a way to do that by only using format, instead of editing original data? Thanks!!!!

Online Status	Offline
Date Last Visited	‎02-04-2021 01:43 PM

Re: proc format problems

Re: proc format problems

proc format problems

Re: proc format problems

Re: proc format problems

proc format problems