06-14-2017 11:43 AM
I am pulling comments that end with a date in the following format MM/DD/YYY and I'm trying to pull the dates to create a separate date column. I tried multiple formulas and I'm still not getting an output.
From the comments below, I am trying to pullout the dates:
- 10 Cans of Soda Safeway 05/10/2015
- 3 pounds of Salmon Whole Foods 06/17/2017
One of the formulas I used is the following:
Any help would be appreciated.
06-14-2017 11:58 AM
Use the SCAN function with a negative index to get the rightmost text and then use the INPUT function with the proper informat to convert the char value to a SAS date value.
Need further help from the community? Please ask a new question.