This might be what you want
proc freq data=your_data_table;
tables data1 data2 data3 / nocum;
run;
This will generate a frequency table that shows the number of times each value appears in each of the three columns ( data1 , data2 , and data3 ).
If you want to combine the frequencies from all three columns into a single table, you can use the output out= option to write the results to a new dataset, and then use a data step to merge the results from the three columns into a single table. Here is an example of how you can do that:
/* Create a frequency table for each column */
proc freq data=your_data_table;
tables data1 / nocum output out=freq1;
tables data2 / nocum output out=freq2;
tables data3 / nocum output out=freq3;
run;
/* Merge the frequency tables into a single table */
data all_data;
merge freq1(in=a) freq2(in=b) freq3(in=c);
by data_value;
if a then freq=freq1;
else if b then freq=freq2;
else if c then freq=freq3;
run;
This will create a new dataset called all_data that contains a single table with the combined frequencies for all three columns. The data_value column will contain the unique values from all three columns, and the freq column will contain the total number of times each value appears in the table.
... View more
