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: 
moreilly
‎04-17-2017
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: counting across observations and variables by group

by Fluorite | Level 6 in SAS Programming
‎04-14-2017 06:53 PM
‎04-14-2017 06:53 PM
try keeping the bene_id identifier   proc sql;     create view sum_view as     select bene_id ,sum(other_service) as sum_other_service,            sum(office_visit) as sum_office_visit,     from claim_data;     group by bene_id; quit; ... View more

Re: look back period: SQL code?

by Opal | Level 21 in SAS Programming
‎03-31-2017 03:54 PM
‎03-31-2017 03:54 PM
I don't know what you mean by standardized date. If your dates are SAS dates, this would work:   data want; set have; back_pn_6_mo_event = back_pn and intck("MONTH", claim_date, trigger_date, "CONTINUOUS") <= 6 ; run; If your dates are not SAS dates, then make them so. ... View more

Re: Merging Issue

by Calcite | Level 5 in SAS Programming
‎03-29-2017 02:13 PM
‎03-29-2017 02:13 PM
That did it!  Thank you! ... View more

Re: How to count the frequency of a value by unique ID's

by Opal | Level 21 in SAS Programming
‎03-24-2017 09:14 PM
‎03-24-2017 09:14 PM
Some of your syntax is off. I think you want something like:   proc sql; select count (distinct sex) as n_id from sashelp.class where age gt 12 ; quit; Art, CEO, AnalystFinder.com ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-17-2017 09:15 PM
Quick links