I have a numeric variable which has a range. The variable also has some special values like -999984. Is there a way I can get descriptive statistics on this variable based on automatic groups of 10 set by SAS. for ex:
Groups N Mean Minimum Maximum
-999994 - 0 45
Proc Format is one of the option, however in that case I will need to see range of every variable and create these groups manually. Since I am dealing with 250 variables and every single one of them has a different range, so this is something I am hoping to avoid.
Something that I am hoping is if SAS can decide these groups by itself depending upon the range and then I can summarize it.
I am sure there might be a way, however just I am not able to figure it out by myself.
Look at using PROC SUMMARY to generate the MIN and MAX in a new file. Then MERGE that file back onto your original file. Then using a DATA step, increment in a DO loop from your new TO variables BY 10, creating another new variable which you will then use to run your descriptive statistics.
You may also find the SAS support website http://support.sas.com/ useful with its own SEARCH facility (SAS DOC and technical papers are hosted there), and possibly using the Google advanced search argument below (one one of your own):
generate descriptive statistics value ranges site:sas.com