extract month and year from different date formates

[BrahmanandaRao]

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

[PeterClemmensen]

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;

[BrahmanandaRao]

Thank you peter

for you solution

[PaigeMiller · Accepted solution]

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;

[BrahmanandaRao]

Thank you Miller

if we want extract date and month the which format 

[PaigeMiller]

---

@BrahmanandaRao wrote:

if we want extract date and month the which format 

---

what would it look like?

[BrahmanandaRao]

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 

[PaigeMiller]

---

@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.