Create new (date) column by pulling date from Detailed Comment field

[chrisjab]

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.

For example:

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:

- SUBSTR(RIGHT(INPUT(t1.CommentsPrinted,32.)), 10.) 

Any help would be appreciated.

Thanks,

CJ

[Astounding · Accepted solution]

To create a character date, you might try:

scan(t1.CommentsPrinted, -1, ' ')

[BrunoMueller]

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.

[chrisjab]

Thank You !