topic Re: extract month and year from different date formates in SAS Programming

extract month and year from different date formates

BrahmanandaRao — Thu, 30 Mar 2023 09:52:06 GMT

data dates_format;
input id dates anydtdte32.;
format dates date9. month_year mmyyyy.;
month_year=substr(dates,3);
datalines;
1 10/1/2022
2 23march2023
3 11-feb-2022
;
run;

Hi guys ,

how to get month and year from different date formats

requiered output:

jan2022

march2023

feb2022

Re: extract month and year from different date formates

PeterClemmensen — Thu, 30 Mar 2023 09:57:40 GMT

Use the MONYY7. Format

data dates_format;
input id dates anydtdte32.;
format dates monyy7.;
datalines;
1 10/1/2022
2 23march2023
3 11-feb-2022
;
run;

Re: extract month and year from different date formates

PaigeMiller — Thu, 30 Mar 2023 09:58:06 GMT

You have assigned a format that you don't want to use for variable DATES. You don't want it as format DATE9. you want it as format MONYY7.

data dates_format;
input id dates anydtdte32.;
format dates monyy7.;
datalines;
1 10/1/2022
2 23march2023
3 11-feb-2022
;
run;

Re: extract month and year from different date formates

BrahmanandaRao — Thu, 30 Mar 2023 10:04:50 GMT

Thank you Miller

if we want extract date and month the which format

Re: extract month and year from different date formates

BrahmanandaRao — Thu, 30 Mar 2023 10:05:44 GMT

Thank you peter

for you solution

Re: extract month and year from different date formates

PaigeMiller — Thu, 30 Mar 2023 10:12:18 GMT

@BrahmanandaRao wrote:

if we want extract date and month the which format

what would it look like?

Re: extract month and year from different date formates

BrahmanandaRao — Thu, 30 Mar 2023 10:16:55 GMT

data dates_format;
input id dates anydtdte32.; 
format dates date9. dates DATE5.;
datalines;
1 10/1/2022
2 23march2023
3 11-feb-2022
;
run;

date and month

Re: extract month and year from different date formates

PaigeMiller — Thu, 30 Mar 2023 10:22:48 GMT

@BrahmanandaRao wrote:

date and month

I asked "What would it look like?", you haven't shown us what the desired output would look like. Show us.