Hi,
I have a table with a large number of columns(>100) and want to use sql to calculate the frequency of particular responses for each column in the list (where these frequencies do not include the missing data in the category).
I know this shouldn't be too difficult, but would prefer to write a sql statement that does not list all the column names individually or specify the responses to be counted for each of the variables.
I do have another table with all of the column names.
Any thoughts?
Thanks,
Jane L.
I have a table with a large number of columns(>100) and want to use sql to calculate the frequency of particular responses for each column in the list (where these frequencies do not include the missing data in the category).
I know this shouldn't be too difficult, but would prefer to write a sql statement that does not list all the column names individually or specify the responses to be counted for each of the variables.
I do have another table with all of the column names.
Any thoughts?
Thanks,
Jane L.