We have a data set (called STATE) that contains an ID variable and up to five states (two letter codes) where an individual may have visited last year. Three observations from this data set are shown:...

We have a data set (called STATE) that contains an ID variable and up to five states (two letter codes) where an individual may have visited last year. Three observations from this data set are shown:

As you can see, "XX" was used as a missing value. Write a program to (a) read these records and replace the values of "XX" with blanks, and (b) compute frequency counts showing how many people visited each state. Present the frequency list in decreasing order of frequency (use the ORDER~FREQ option of PROC FREQ). Run the following program to create data set STATE: