topic Re: How to extract year and month from date in SAS? in SAS Programming

How to extract year and month from date in SAS?

lixuan — Wed, 19 Jul 2017 16:39:42 GMT

I have a variable in the form of yymmdd, and I want to extract yymm from it without changing the date format. I konw year() and month(),but I don't know how to get year and month in one variable. thanks a lot.

Re: How to extract year and month from date in SAS?

Kurt_Bremser — Wed, 19 Jul 2017 16:51:41 GMT

You can use the yymm format in a put statement.

Re: How to extract year and month from date in SAS?

lixuan — Wed, 19 Jul 2017 16:54:15 GMT

just like this? but it didn't work.

ym=put(yymm,yymm6.);

Re: How to extract year and month from date in SAS?

lixuan — Wed, 19 Jul 2017 16:56:44 GMT

sorry , i make a mistake. it has been resolved using the code. thank you!

Re: How to extract year and month from date in SAS?

lixuan — Wed, 19 Jul 2017 17:28:32 GMT

but after finished, it's character format instead of date format. my code :

data have;
format dt yymmdd10.;
input dt yymmdd10.;
datalines;
2016-05-21
2017-08-12
2014-03-02
;
run;

data want;
set have;
yy = put(dt,yymmn6.);
run;

Re: How to extract year and month from date in SAS?

Kurt_Bremser — Thu, 20 Jul 2017 06:18:09 GMT

@lixuan wrote:

but after finished, it's character format instead of date format. my code :
data have;
format dt yymmdd10.;
input dt yymmdd10.;
datalines;
2016-05-21
2017-08-12
2014-03-02
;
run;

data want;
set have;
yy = put(dt,yymmn6.);
run;

A SAS data value defines a certain day. When you only have year and month, one usually uses a character variable for display, as a SAS data variable cannot be built without a day value.

If you simply assign the yymm format to your original variable, it will display the way you want to. If you do want to create a new SAS date variable, you will have to set a rule for the day that it will use "internally", and then assign the yymm format to the new variable.

Re: How to extract year and month from date in SAS?

Singla14 — Wed, 06 Sep 2017 09:25:06 GMT

, I have input file having year ( let's say 2015 to 2017 YYYY) .
I am trying to fetch system year ( year(today())
And then compare year from input file to fetched year.
If matches , those rows should come in output.

If comparison for years is not working ..Have tried reading input year in chat..Integer both..But nothing working.
Can some one please help..Urgent

Re: How to extract year and month from date in SAS?

Kurt_Bremser — Wed, 06 Sep 2017 17:44:43 GMT

@Singla14 wrote:
, I have input file having year ( let's say 2015 to 2017 YYYY) .
I am trying to fetch system year ( year(today())
And then compare year from input file to fetched year.
If matches , those rows should come in output.

If comparison for years is not working ..Have tried reading input year in chat..Integer both..But nothing working.
Can some one please help..Urgent

Don't hijack other people's threads, start your own.

Post your code and the log of the whole step.