SAS Support Communities

alagiejatta · ‎10-04-2021

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

alagiejatta · ‎10-04-2021

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

alagiejatta · ‎10-04-2021

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

alagiejatta · ‎05-10-2021

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

alagiejatta · ‎05-10-2021

Sorry. City can actually be up to 3 words. Thanks

alagiejatta · ‎05-10-2021

Also, If zip codes is not blank, it is right after a comma

alagiejatta · ‎05-10-2021

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

alagiejatta · ‎05-10-2021

I do not really have any rules in mind. And these examples are real data.

alagiejatta · ‎05-10-2021

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

Online Status	Offline
Date Last Visited	‎03-30-2022 02:59 PM

SAS Support Communities

Re: Select var based on sequence of date

Re: Select var based on sequence of date

Select var based on sequence of date

Re: Splitting Address

Re: Splitting Address

Re: Splitting Address

Re: Splitting Address

Re: Splitting Address

Splitting Address

Re: Select var based on sequence of date

Re: Select var based on sequence of date

Select var based on sequence of date

Re: Splitting Address

Re: Splitting Address

Re: Splitting Address

Re: Splitting Address

Re: Splitting Address

Splitting Address

Follow Us

What is...