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: 
alagiejatta
‎03-30-2022
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Select var based on sequence of date

by Calcite | Level 5 in SAS Programming
‎10-04-2021 05:21 PM
‎10-04-2021 05:21 PM
So the final product is to show a sequence of event. I will submit a file the shows which event occur first, second, third etc by ID. For A11 the final answer is VR-GH-YZ ... View more

Re: Select var based on sequence of date

by Calcite | Level 5 in SAS Programming
‎10-04-2021 04:43 PM
‎10-04-2021 04:43 PM
If someone has test in all five then all the slots will be filled. I am sorry I forget to include slot5 in the output sample ... View more

Select var based on sequence of date

by Calcite | Level 5 in SAS Programming
‎10-04-2021 04:36 PM
‎10-04-2021 04:36 PM
I have a data set like this ID   vr               bd                 fx                   gh                   A11 1/2/1999 .  6/4/2012        8/1/2021 A12 3/5/2021 . . . A13 3/5/2000 . . 4/17/1988 A14 10/24/1956 12/2/1967 1/6/2001 . A15 7/1/1996 11/7/1990    . 7/21/2001   I wanted a table like this. Varaibles are selected based dates values- earliest date will fill slit1 and latest date fill slot 4. Missing dates are ignored. ID   vr               bd                 fx                   gh                   yz slot1 slot2 slot3 slot4 A11 1/2/1999 .   8/1/2021 9/23/2019 vr gh yz   A12 3/5/2021 . . . 3/5/2000 yz vr     A13 3/5/2000 . . 4/17/1988 . gh vr     A14 10/24/1956 12/2/1967 1/6/2001 . . fx bd vr   A15 7/1/1996 11/7/1990    . 7/21/2001 6/10/2000 bd vr yz gh     ... View more

Re: Splitting Address

by Calcite | Level 5 in SAS Programming
‎05-10-2021 12:19 PM
‎05-10-2021 12:19 PM
Iowa is always spelled out in full (including other states)   There are no 9 digit zip. All are 5 digits   There are only blank separators between address and city name and between most of the elements. The only comma separator is after the state name. Column (:) separators are after the text " Address" and after the text "Phone Number"   Thank you ... View more

Re: Splitting Address

by Calcite | Level 5 in SAS Programming
‎05-10-2021 10:55 AM
‎05-10-2021 10:55 AM
Sorry. City can actually be up to 3 words. Thanks ... View more

Re: Splitting Address

by Calcite | Level 5 in SAS Programming
‎05-10-2021 10:48 AM
‎05-10-2021 10:48 AM
Also, If zip codes is not blank, it is right after a comma ... View more

Re: Splitting Address

by Calcite | Level 5 in SAS Programming
‎05-10-2021 10:44 AM
‎05-10-2021 10:44 AM
So all I really needed from this address column is the City name and Zip code.  1. The city name can be one or two words, followed by State name and then a comma "," 2. Zip codes are only 5 numbers 3. Some address are missing everything except the state name 4. There are addresses from other states, but only interested in those that has Iowa as the state ... View more

Re: Splitting Address

by Calcite | Level 5 in SAS Programming
‎05-10-2021 10:16 AM
‎05-10-2021 10:16 AM
I do not really have any rules in mind. And these examples are real data.     ... View more

Splitting Address

by Calcite | Level 5 in SAS Programming
‎05-10-2021 09:32 AM
‎05-10-2021 09:32 AM
I have an address column in my dataset that I wanted to parse to put city and zip code in their separate columns. Positions differ in many of the addresses. Examples of address types in the data are:   1. Address: 321 E 12th St Des Moines Iowa, 50321phone Number: (515) 515-5151 2. Address: 321 Iowa st Boone Iowa, 50321Phone Number: (515) 515-5151 3. Address: 321 Des Moines st Suite 140 Iowa City Iowa, 50321Phone Number: (515) 515-5151   Thanks ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-30-2022 02:59 PM
Quick links