topic Re: Extract SAS date from character field which is DD-MM-YYYY in SAS Programming

Extract SAS date from character field which is DD-MM-YYYY

dsr001 — Wed, 03 Jul 2019 19:01:50 GMT

Hi,
I need to Extract SAS date from character field which is in the form of DD-MM-YYYY.
Can someone help?
Thanks and Regards

Re: Extract SAS date from character field which is DD-MM-YYYY

novinosrin — Wed, 03 Jul 2019 19:05:01 GMT

data date;
date='02-07-2019';
sas_date=input(date,ddmmyy10.);
format sas_date ddmmyy10.;
run;

Re: Extract SAS date from character field which is DD-MM-YYYY

Reeza — Wed, 03 Jul 2019 19:05:42 GMT

Is that the only portion in the character field? If so, INPUT is easy enough.

x = input(old_x, ddmmyy10.);

If you need to extract it from other text, you likely want regex or COMPRESS(). If you need help with the actual code, you'll need to provide some examples of your data otherwise what we write likely won't work for your data.

@dsr001 wrote:
Hi,
I need to Extract SAS date from character field which is in the form of DD-MM-YYYY.
Can someone help?
Thanks and Regards