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: 
lturian
‎07-17-2020
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Multiple If/Then/Else statements with wildcard

by Calcite | Level 5 in SAS Programming
‎07-11-2020 11:58 AM
‎07-11-2020 11:58 AM
I used the invalue format you provided:    proc format; invalue FIPS '23' '33' '50' '25' '44' '09' = 1 '36' '42' '34' = 2 '55' '26' '17' '18' '39' = 3 '29' '38' '46' '31' '20' '27' '19' = 4 '10' '24' '11' '51' '54' '37' '45' '13' '12' = 5 '21' '47' '28' '01' = 6 '40' '48' '05' '22' = 7 '16' '30' '56' '32' '49' '08' '04' '35' = 8 '02' '53' '41' '06' '15' = 9 ; run; data test2; set test; HOSP_DIVISION = input(substr(HOSPSTCO,1,2), FIPS.); run; ... View more

Re: Multiple If/Then/Else statements with wildcard

by Calcite | Level 5 in SAS Programming
‎07-11-2020 12:57 AM
‎07-11-2020 12:57 AM
I do like formats. But for some reason I'm not getting anything the formatted variables in the new column. I'm just getting "." in all rows. ... View more

Re: Multiple If/Then/Else statements with wildcard

by Calcite | Level 5 in SAS Programming
‎07-11-2020 12:16 AM
‎07-11-2020 12:16 AM
I tried both ways and for some reason I'm not getting anything in the new column. I'm just getting "." in all rows. ... View more

Re: Multiple If/Then/Else statements with wildcard

by Calcite | Level 5 in SAS Programming
‎07-11-2020 12:14 AM
‎07-11-2020 12:14 AM
When I try this, it doesn't output any variable into HOSP_DIVISION. Every row just has "." instead of the desired output. I wonder if the problem lies with the HOSPSTCO data ... View more

Multiple If/Then/Else statements with wildcard

by Calcite | Level 5 in SAS Programming
‎07-10-2020 05:30 PM
‎07-10-2020 05:30 PM
I'm trying to create a new column by grouping variables from a different column to a new output. I'm also trying to identify those variables just by their first 2 digits using a wildcard. When I run the following, the output just puts "1" in the new column for all rows, even if doesn't abide by the intended "if" statement. I'm not quite sure why it does that and fails to have the intended output in the new column. Any help would be greatly appreciated!!   data test; set test; if HOSPSTCO=:'23' or '33' or '50' or '25' or '44' or '09' then HOSP_DIVISION=1; else if HOSPSTCO=:'36' or '42' or '34' then HOSP_DIVISION=2; else if HOSPSTCO=:'55' or '26' or '17' or '18' or '39' then HOSP_DIVISION=3; else if HOSPSTCO=:'29' or '38' or '46' or '31' or '20' or '27' or '19' then HOSP_DIVISION=4; else if HOSPSTCO=:'10' or '24' or '11' or '51' or '54' or '37' or '45' or '13' or '12' then HOSP_DIVISION=5; else if HOSPSTCO=:'21' or '47' or '28' or '01' then HOSP_DIVISION=6; else if HOSPSTCO=:'40' or '48' or '05' or '22' then HOSP_DIVISION=7; else if HOSPSTCO=:'16' or '30' or '56' or '32' or '49' or '08' or '04' or '35' then HOSP_DIVISION=8; else if HOSPSTCO=:'02' or '53' or '41' or '06' or '15' then HOSP_DIVISION=9; run;   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-17-2020 07:24 PM
Quick links