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: 
huongc2
‎11-23-2020
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Address cleaning

by Calcite | Level 5 in SAS Procedures
‎11-23-2020 09:16 AM
‎11-23-2020 09:16 AM
Ah Thank you. I thought SAS would have function for this that I don't know 😄 ... View more

Address cleaning

by Calcite | Level 5 in SAS Procedures
‎11-20-2020 10:10 AM
‎11-20-2020 10:10 AM
Hi everyone,   I am having some troubles with cleaning these addresses. at first it was easy with some if statement. But since my data is getting bigger, it is not efficient to use if statement anymore. I would love to hear your thoughts about how to clean this field.   I have: Data have; input address $200; datalines; 100 ABC ST RM S02A 102 ABC STREET FLOOR 1 103 ABC ST APT 3 HOMELESS 1035 CD AVENUE FLOOR 2 108 SOMETHING ST # 2FL 115 VISA VISTA DR APT 212 APT 212 1155 LOOK AVENUE APT 205 12 BORED AVE APT 2 1214 TIRED STREET APT 428 127 HAPPY STREET FLOOR 2 1397 SOMEWHERE STREET FIRST FLOOR 142 SOMETHING ST APT 3 200 RAINBOW AVE UNIT 202 ;   I don't want any Unit or floor or apt number in the clean address. So I want the address field that would look like this: 100 ABC ST 102 ABC STREET 103 ABC ST 1035 CD AVENUE 108 SOMETHING ST 115 VISA VISTA DR 1155 LOOK AVENUE 12 BORED AVE 1214 TIRED STREET 127 HAPPY STREET 1397 SOMEWHERE STREET 142 SOMETHING ST 200 RAINBOW AVE   Thank you so much! ... View more

Re: How to create the min and max of the date with conditions

by Calcite | Level 5 in SAS Programming
‎11-16-2020 12:55 PM
‎11-16-2020 12:55 PM
OMG, it works perfectly and soooo fast. Thank you so much!!!!!! ... View more

Re: How to create the min and max of the date with conditions

by Calcite | Level 5 in SAS Programming
‎11-16-2020 11:02 AM
‎11-16-2020 11:02 AM
Hi,   Below is my log. I tried with a small subset first:   NOTE: The query requires remerging summary statistics back with the original data. NOTE: Table WORK.MIN_MAX created, with 3367 rows and 8 columns. quit; NOTE: PROCEDURE SQL used (Total process time): real time 15:38.36 cpu time 15:43.67 ... View more

Re: How to create the min and max of the date with conditions

by Calcite | Level 5 in SAS Programming
‎11-16-2020 10:10 AM
‎11-16-2020 10:10 AM
Good morning! Thank you soooo much for helping me on this. I edited my post as suggested.   Regarding the codes, the first step works so well on my data! But as you mentioned at the end, I might have to do some tricks to get the second step works since my data is large. (40,000 obs).   I wonder after creating the counts data, maybe I could group by patient and admission_count, then do first.admitted_date and last.discharge_Date to capture their min and max? do you think it would work? Do you have any other suggestions in this case?   Again, thank you so much for helping on this. I just learned a new function "lag" from you. I am so happy that it works so well (and fast). ... View more

How to create the min and max of the date with conditions

by Calcite | Level 5 in SAS Programming
‎11-13-2020 02:13 PM
‎11-13-2020 02:13 PM
Hi, I am having one problem that I could not figure out how to do this.    Below is an example of the data I have: data have; input patient $ admitted_date :mmddyy10. discharge_date :mmddyy10. disposition $50.;format admitted_date discharge_date yymmdd10.; datalines; A 3/2/2020  3/15/2020 transferred to other hospital A 3/15/2020 4/2/2020  home B 5/3/2020  6/27/2020 transferred to other hospital B 6/27/2020 6/29/2020 home C 8/1/2020  8/25/2020 died D 5/15/2020 6/1/2020  transferred to other hospital D 6/1/2020  7/2/2020  home A 6/2/2020  6/25/2020 died B 8/1/2020  8/2/2020  transferred to other hospital B 8/2/2020  8/15/2020 transferred to other hospital B 8/15/2020 8/25/2020 died;   Patient got to the hospital and maybe they got transferred to other hospitals because of the low bed capacity. I only want to capture them as 1 admission to the hospital (if they got transferred). However, they could get admitted again after that, their admission_count will be 2 (or even 3,4,5 times if they had to go to the hospitals again) . From the data above, I want something like this:   Patient admitted date discharge_date disposition Min(admitted_date) Max(discharge_date) admission_count final_disposition A 3/2/2020 3/15/2020 transferred to other hospital 3/2/2020 4/2/2020 1 home A 3/15/2020 4/2/2020 home 3/2/2020 4/2/2020 1 home B 5/3/2020 6/27/2020 transferred to other hospital 5/3/2020 6/29/2020 1 home B 6/27/2020 6/29/2020 home 5/3/2020 6/29/2020 1 home C 8/1/2020 8/25/2020 died 8/1/2020 8/25/2020 1 died D 5/15/2020 6/1/2020 transferred to other hospital 5/15/2020 7/2/2020 1 home D 6/1/2020 7/2/2020 home 5/15/2020 7/2/2020 1 home A 6/2/2020 6/25/2020 died 6/2/2020 6/25/2020 2 died B 8/1/2020 8/2/2020 transferred to other hospital 8/1/2020 8/25/2020 2 died B 8/2/2020 8/15/2020 transferred to other hospital 8/1/2020 8/25/2020 2 died B 8/15/2020 8/25/2020 died 8/1/2020 8/25/2020 2 died   Please help! I don't know how to do this 😞   Thank you so much! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-23-2020 12:37 PM
Quick links