topic Re: SAS EG DATA OUTPUT in New SAS User

SAS EG DATA OUTPUT

yesidgranadosv — Thu, 15 Aug 2019 15:56:10 GMT

I have the courage to FECHA_INGRESO

fecha ingreso = SUBSTR(t1.fecha_ingreso, 1, 20)

which delivers as a result 2014-04-03 00:00:00

I want to have this same date removing the ' - ' and ' : '

you can tell me what function I can use for this

Re: SAS EG DATA OUTPUT

Reeza — Thu, 15 Aug 2019 15:59:28 GMT

Use COMPRESS()

I would recommend storing your dates as SAS dates and using formats instead of characters.

There's a great reference on dates and times in the Community Library on this site.

@yesidgranadosv wrote:

I have the courage to FECHA_INGRESO

fecha ingreso = SUBSTR(t1.fecha_ingreso, 1, 20)

which delivers as a result 2014-04-03 00:00:00

I want to have this same date removing the ' - ' and ' : '

you can tell me what function I can use for this

Re: SAS EG DATA OUTPUT

PeterClemmensen — Thu, 15 Aug 2019 16:01:59 GMT

So you have a character 'datetime value'. Do you want this to be an actual numeric datetime value?

Re: SAS EG DATA OUTPUT

Kurt_Bremser — Thu, 15 Aug 2019 16:02:23 GMT

You can use the compress() function to remove certain unwanted characters.