topic Re: create a yearmonth variable with YYMMn6. format in SAS Programming

create a yearmonth variable with YYMMn6. format

somebody — Mon, 21 Aug 2017 05:07:45 GMT

I would like to create a new variable that take YYMMn6 format to display yearmonth, taking value from another numeric variable.

For example, the original numeric variable has value 199312, the new variable would display the same value "199312".

So far I have tried:

format new_yearmonth = put(yearmonth, YYMMn6.);
* but this take yearmonth value as date value and convert this to a weird number 245603 or something;

I have successfully converted something similar to yearquarter format with the code:

format yearquarter YYQn6.;
yearquarter = YYQ(year,quarter);
*where year is a numeric variable having value 1993, quarter is also a numeric variable that has value 1, 2, 3, and 4;

So I guess I can also try this method but could not find a function similar to YYQ that takes value of 2 variable year and month. Is there such function?

thanks

Re: create a yearmonth variable with YYMMn6. format

Reeza — Mon, 21 Aug 2017 05:59:10 GMT

This is really confusing. What do you have? What do you want?

Re: create a yearmonth variable with YYMMn6. format

somebody — Mon, 21 Aug 2017 06:13:01 GMT

I have a yearmonth variable whose format is numeric ( value could be 199311 or 201009)
I want a new variable whose format is YYMMn6 and displays values 199311 or 201009.
The purpose is that when I draw graph, there is no gap between 199312 and 199401

Re: create a yearmonth variable with YYMMn6. format

Shmuel — Mon, 21 Aug 2017 07:08:11 GMT

You need first to convert the input numeric variable to a sas date variable.

Sas date contains: year, month and day.

Having input like var = 201706 - the day is absent. You can choose any day to adjust to the input.

In such cases ususally we adjust day=01;

There are many ways to convert your input to a sas date.

In order to display the sas date as yyyymm assign to it the format YYMMN6.

Format new_date yymmn6.;

1) using MDY function - needs to split your input to year and month:

new_date = mdy(mod(var,100), 01, int(var/100) );
/* -------     month        day     year    -------*/

2) alternatively, convert the number given to a string and adjust the day:

new_date = input(put(var,6.),yymmdd8.);

3) The most simple way to convert the input to a sas date - which maybe you used is:

new_date = input(put(var,6.), yymmn6.);
format new_date yymmn6.;

Re: create a yearmonth variable with YYMMn6. format

somebody — Thu, 24 Aug 2017 04:03:50 GMT

Thank you so much. it works perfectly.

Just a quick question. How do we compare the date? for example, if I want dates after 199702? Since it is not numeric, I cannot simply do >199702.

Thanks

Re: create a yearmonth variable with YYMMn6. format

Shmuel — Thu, 24 Aug 2017 04:14:04 GMT

Sas date counts days since 01/01/1960 = 0;

If you convert the two input variables to date it is just simple numeric comparison.

Anyway, as your char-date is in yyyymm format, you can compare them as

alphanumeric strings. If it was in mmyyyy format it will give false results.

Re: create a yearmonth variable with YYMMn6. format

somebody — Wed, 20 Sep 2017 05:41:20 GMT

Hi Shmuel,
While we are on this topic, I would like to create a variable that represent year and has format YEAR4. . This take values from a different variable that already shows years but in numeric format (best8.). How would I do this?
Thanks

Re: create a yearmonth variable with YYMMn6. format

Shmuel — Wed, 20 Sep 2017 06:50:59 GMT

YEAR4. format is applicable with a sas date varibale.

If your variable as a numeric year only (used with BEST4. format) then

convert it with MDY function, adding any month or day and assign the YEAR4. format.