topic Create a date in SAS Data Management

Create a date

ZosTa — Thu, 17 May 2018 12:29:54 GMT

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.

Re: Create a date

Kurt_Bremser — Thu, 17 May 2018 12:32:35 GMT

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

Re: Create a date

RW9 — Thu, 17 May 2018 12:38:09 GMT

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

Re: Create a date

Ksharp — Thu, 17 May 2018 12:40:34 GMT

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

format your-variable  yymmn6.;