07-31-2012 04:49 PM
Hi everyone...sorry for the simplistic question, but I am a brand new (and I do mean new!) user to SAS. Just trying to pull some data and create an output showing number of records in each category. Example of data to be pulled:
Line of Business
When I retrieve the data and sum by Member Count for each Physician Association, I then need to know how many of those Physician Associations fall under the following categories:
0 - 100 members
101 - 500 members
501 - 1000 members
1001 - 5000 members
5001 or greater
Is there a simple way to modify the query to accomplish this task?
07-31-2012 05:22 PM
Assuming you have created a table or dataset with the counts per association I would normally use procs format and freq.
Instead of modifying query add as one way:
proc format library=work;
0 - 100 = ' 0 - 100 members'
101 - 500 = ' 101 - 500 members'
501 - 1000 = ' 501 - 1000 members'
1001 - 5000 = '1001 - 5000 members
5001 - high = '5001 or more members'
/*assuming MemberCount holds the sum of members for each association, use your variable name*/
proc freq data=<your data set name>;
table MemberCount ;
format MemberCount members.;
08-01-2012 08:54 AM
Thank you for your reply. I copied the code and pasted below for what I have so far and all it does is group the data by Physician Association with their total member count. Are you saying I should add all of the code in your reply (starting with proc format library=work; to the end run; statement) to the bottom of my code to make it work?
CREATE TABLE WORK.QUERY950 AS SELECT DISTINCT SF_PROF_MEMBERDATA_201206.activity_date,
FROM SERVFUND.SF_PROF_MEMBERDATA_201206 AS SF_PROF_MEMBERDATA_201206
GROUP BY SF_PROF_MEMBERDATA_201206.activity_date, SF_PROF_MEMBERDATA_201206.master_ipa, SF_PROF_MEMBERDATA_201206.sf_lob;