Here are the Column names of our data. I am trying to make a frequency table that has LASTNAME as one column and the frequency of the amount of times that same LASTNAME appears in columns COMMMEM1-COMMMEM5 throughout the whole list of data. Here is what I have tried. data Comm; infile "/home/lincolnstoebner0/SAS/COMMITTEEDATA.csv" dsd; input LASTNAME : $20. COMMMEM1 : $20. COMMMEM2 : $20. COMMMEM3 : $20. COMMMEM4 : $20. COMMMEM5 : $20.; run; proc freq data=Comm; tables COMMMEM1-COMMMEM5 /out=want(drop=percent); run; And here is the output continuing on down in separate freq tables through COMMMEM5. I am trying to get a one freq table with all the variables instead of 5 different freq tables for each variable. I believe this requires an array but am not able to figure out the code needed for the array.
... View more