cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vanaml
‎06-21-2017
  • 8 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS count of records grouping by a varable

by Calcite | Level 5 in SAS Programming
‎06-15-2017 06:37 AM
‎06-15-2017 06:37 AM
Thank you, I will keep the dataset in mind in the future.  Btw, I still get _type_ and _freq_ columns in the outout screen. How do I get rid of them and only show Hospital and number of observations? Can I use drop here? ... View more

Re: SAS count of records grouping by a varable

by Calcite | Level 5 in SAS Programming
‎06-15-2017 06:02 AM
‎06-15-2017 06:02 AM
Thank you for your response. Sorry missed data earlier. I provided the sample data in the previous post now. Do you mean  dont need data step? If I only use the first proc step,  get N, Mean, median and standard deviation in the result set. How do  ignore them and only keep the number of observations/ count for each hospital? ... View more

Re: SAS count of records grouping by a varable

by Calcite | Level 5 in SAS Programming
‎06-15-2017 05:56 AM
‎06-15-2017 05:56 AM
Sorry, this s how the sample data looks like: BenefUserID HospId 108 HopID-399 114 HopID-279 117 HopID-32 141 HopID-45 147 HopID-258 148 HopID-846 159 HopID-499 186 HopID-490 192 HopID-399 194 HopID-138 195 HopID-399 224 HopID-13 242 HopID-231 247 HopID-45 250 HopID-154 ... View more

SAS count of records grouping by a varable

by Calcite | Level 5 in SAS Programming
‎06-15-2017 05:49 AM
‎06-15-2017 05:49 AM
In the attached data set , I am trying to find the hospital that has got more number of patients? The solution that  have below seems to be long. Can someone please suggest the best/ easy way to solve this? Thank you.     proc means data=mylib1.claim nway order =freq; class Hospid; var BenefUserID; output out =temp;   data temp1; set temp; where _stat_= "N"; drop _freq_ _type_ _stat_; ... View more

Re: Need help with SAS proc Mode

by Calcite | Level 5 in SAS Programming
‎06-15-2017 04:27 AM
‎06-15-2017 04:27 AM
Thank you so much. Appreciate your help. ... View more

Re: Need help with SAS proc Mode

by Calcite | Level 5 in SAS Programming
‎06-15-2017 03:55 AM
‎06-15-2017 03:55 AM
Thank you. That helps. My other question is, in what kind of cases we use "proc means mode" ? ... View more

Re: Need help with SAS proc Mode

by Calcite | Level 5 in SAS Programming
‎06-15-2017 03:19 AM
‎06-15-2017 03:19 AM
Thank you very much. I am now starting to learn SAS and have been exploring multiple options. Can this be done using Mode too? Or in what kind of cases Mode is used? Can you please clarify?   Thank you ... View more

Need help with SAS proc Mode

by Calcite | Level 5 in SAS Programming
‎06-15-2017 03:03 AM
‎06-15-2017 03:03 AM
BenefUserID BenefPriID BenefRelToPriID 702 PID-176 Brother 2301 PID-1070 Husband 1398 PID-1089 Others 2143 PID-1341 Wife 2484 PID-1441 Daughter 2663 PID-1474 Child 976 PID-1115 Sister 1942 PID-791 Mother-in-law 300 PID-302 Sister 2795 PID-872 First Child 2532 PID-914 Sister 374 PID-1418 Self 918 PID-1043 Wife 1096 PID-878 Sister 2672 PID-865 Wife 1263 PID-125 Husband 1965 PID-1399 Second Child 2849 PID-184 Others   The above is my sample dataset and I would like to find out the most common BenefRelToPriID. I believe I need to use Mode option. I am new to SAS programming and I am lost in the syntax. Can someone please help me with the syntax?   Thank you. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-21-2017 05:19 PM
Likes given to
View All
Quick links