Create a date

[ZosTa]

Hello SAS users

I have the attached kind of data:

I want to create a new variable, "date" which is a combination of the year and the number corresponding to the month (like this, 200810 to represent  Oct 2010)

please assist me.

[Kurt_Bremser]

See my footnotes for how to post data. Excel files are mostly useless for this (unless your problem lies in importing them).

[RW9]

A date variable always has the three components = day, month, year.  If you do not have one then you need to default one in.  You can use ISO dates, which are character:

iso_date=catx('-',put(year,4.),put(month,z2.));

For a numeric, you can have a default, then format it to display differently:

want=mdy(monthvar,1,yearvar);
format want monyy7.;

[Ksharp]

If your variable is date type ,just add a format.

format your-variable  yymmn6.;