topic Re: Create new (date) column by pulling date from Detailed Comment field in SAS Enterprise Guide

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

chrisjab — Wed, 14 Jun 2017 15:43:15 GMT

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,

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

Astounding — Wed, 14 Jun 2017 15:55:06 GMT

To create a character date, you might try:

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

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

BrunoMueller — Wed, 14 Jun 2017 15:58:20 GMT

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.

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

chrisjab — Wed, 14 Jun 2017 16:24:39 GMT

Thank You !