Hello,    I am trying to clean character strings - I would like to pull out and keep only the characters between the first set of quotes.    Here is an example: {"I34.0":1,"I48.0   I would like the result to be I34.0   Thank you! ... View more

I would like to calculate weighted averages across 37 weeks, where each average includes all previous weeks, inversely weighted by their distance from the current week.    My data is in wide format where each observation is one person, with variables wk1 - wk37 as weekly values.    This is what I would like to accomplish: data test; avg1 = .; avg2 = wk1; avg3 = (( wk2*(2/3) + wk1*(1/3)) / 2); avg4 = (( wk3*(3/4) + wk2*(2/4) + wk1*(1/4)) / 3) ; avg5 = (( wk4*(4/5) + wk3*(3/5) + wk2*(2/5) + wk1*(1/5)) / 4); avg6 = (( wk5*(5/6) + wk4*(4/6) + wk3*(3/6) + wk2*(2/6) + wk1*(1/6)) / 5); avg7 = (( wk6*(6/7) + wk5*(5/7) + wk4*(4/7) + wk3*(3/7) + wk2*(2/7)) + wk1(1/7)) / 6); avg8 = (( wk7*(7/8) + wk6*(6/8) + wk5*(5/8) + wk4*(4/8) + wk3*(3/8) + wk2*(2/8) + wk1*(1/8) / 7; etc. ....   Thank you! ... View more

Hello,   I have one formatted variable (interaction_type2) and I can't figure out how to get SAS to recognize the formatted terms to create new variables or to subset? This code returns missing values for both new variables, because SAS is looking for the unformatted value. Can someone explain this to me? Thanks!   Proc format; Value $interaction '01'='Ambulatory patient services' '02'='Day surgery patient' '03'='Emergency patient' '04'='Home visits' '05'='Hospice' '06'='Imaging' '07'='Inpatient' '08'='Inpatient psych' '09'='Inpatient rehab' '10'='Labs and diagnostics.nonimaging' '11'='Letter / Email' '12'='Not recorded' '13'='Nursing home / Assisted living' '14'='Observation patient' '15'='Office or clinic patient' '16'='Other orders' '17'='Other patient type' '18'='Other physician advice' '19'='Palliative care' '20'='Prescriptions and refills' '21'='Skilled nursing facility inpatient' '22'='Swing bed' '23'='Unknown patient type' '24'='Urgent care' '25'='Long term acute care' '26'='Other Reports / Results' '27'='Telephone / Online';   Value $providerrole '01'='ADMITTING' '02'='ATTENDING' '03'='BILLING' '04'='CONSULTING' '05'='DISCHARGING' '06'='ORDERING' '07'='OTHER' '08'='PERFORMING' '09'='REFERRING' '10'='SCHEDULING'; format interaction_type2 $interaction. provider_role2 $providerrole.; run;   data encounter; set m.provider_2007_to_2017_tr; if specialty in ("Family Medicine" "Internal Medicine" "Primary Care" "Cardiology" "Emergency Medicine") ; if interaction_type2 in ( 'Office or clinic patient' ) then outpt = 1; else if interaction_type2 in ( 'Ambulatory patient services' 'Day surgery patient' 'Emergency patient' 'Inpatient' 'Inpatient psych' 'Inpatient rehab' 'Observation patient' 'Skilled nursing facility inpatient' 'Swing bed' ) then inpt = 1; /*format interaction_type2 $interaction. provider_role2 $providerrole.; */ run;   ... View more