topic Re: i have a date value 201904 and i want Apr19 . how i can do it please suggest me with code. in SAS Programming

i have a date value 201904 and i want Apr19 . how i can do it please suggest me with code.

Sagar_Pawar — Tue, 14 Jun 2022 11:11:41 GMT

maguiremq — Tue, 14 Jun 2022 11:16:21 GMT

Assuming that's the only date pattern you have.

data have;
	date = input("201904", yymmn6.);
	date_want = mdy(month(date), 22, year(date));
	format date yymmn6. date_want date9.;
run;

Kurt_Bremser — Tue, 14 Jun 2022 11:18:47 GMT

We can only supply useful code if we can see the data or have a very clear, unambiguous description of it.

So we need to know, apart from the value you see, the attributes of the variable. Type and assigned display format are essential.

tarheel13 — Tue, 14 Jun 2022 11:20:38 GMT

a=put(18985,monyy7.);