I want to use the functionality that
PROC FREQ provides in SAS.
PROC FREQ helps in giving the statistics such as frequency, percent, cumulative frequency etc. of a variable or variables. The link attached explains the function in more detail. I am aware that I can use
PIVOT in SQL Server to achieve somewhat the same objective. However, there are certain feature of
PROC FREQ that I cannot find SQL equivalent. To be precise:
table x/norow nocol nocum nopercent missing
This link helped me figure out that
table is basically a cross tabulation technique, so how can I use
pivot in SQL for this? Next, the
missing treats missing values as non-missing. How can I do the same in SQL?
Any thoughts/advice/help much appreciated.