topic Re: Generate year from sas date (YYMMDDN8.) in SAS Procedures

Generate year from sas date (YYMMDDN8.)

LanMin — Fri, 13 Mar 2015 22:16:07 GMT

Dear all,

in my sas data I have a variable date YYMMDDN8.

e.g. 19821031

I want to generate year and month variables

year =1982

month=10

I tried and failed with the following:

data test;

date=19821031;

sasdate=input(put(date,8.),yymmddn8.);

year=year(sasdate);

month=month(sasdate);

run;

could you make some suggestions?

thanks,

Lan

Re: Generate year from sas date (YYMMDDN8.)

ballardw — Fri, 13 Mar 2015 22:55:04 GMT

Is the variable a sas variable with that format?

If so then you only need

Year = year(variable);

Month= month(variable);

Or is it a generic number with a value like 19821031?

then try yymmdd8.

Re: Generate year from sas date (YYMMDDN8.)

Tom — Fri, 13 Mar 2015 23:00:06 GMT

How to convert depends if your variable is

1) Character. '19821031'

2) Numeric: 19,821,031

3) Numeric with a date format attached: such as DATE9. (31OCT1982), YYMMDD10. (1982-10-31) or MMDDYY10 (31-10-1982) , etc .

4) Numeric with a datetime format attached: such as DTDATE9. (31OCT1982).

The YEAR() and MONTH() function assume number 3.

Your assignment statement to set an example value assumes number 2.

Your example INPUT() function assumes number 1, but it should also work for number 2, it will just generate a note that it converted the number 19,821,031 to the string '19821031' so that the INPUT() function could operate on it.

If you have number 4 then you need to use the DATEPART() function to convert from DATETIME value to a DATE value before applying the YEAR() or MONTH() function.

Also note that if you actually have a number you can use INT() and MOD() functions to convert.

year = int(date/10000) ;

month = int(mod(date,10000)/100) ;

Re: Generate year from sas date (YYMMDDN8.)

slchen — Fri, 13 Mar 2015 23:02:47 GMT

data test;

date=19821031;

sasdate=input(put(date,8.),yymmdd8.) ;

year=year(sasdate);

month=month(sasdate);

format sasdate yymmddn8.;

run;

Re: Generate year from sas date (YYMMDDN8.)

Patrick — Fri, 13 Mar 2015 23:12:53 GMT

Except from an amendment to the informat your code worked fine for me "as is"

data test;

date=19821031;

sasdate=input(put(date,8.),yymmdd8.);

year=year(sasdate);

month=month(sasdate);

run;

Re: Generate year from sas date (YYMMDDN8.)

OS2Rules — Fri, 13 Mar 2015 23:51:04 GMT

Hi:

Change the format in the input statement to "yymmdd8." and try again.

Worked for me.

Re: Generate year from sas date (YYMMDDN8.)

LanMin — Fri, 13 Mar 2015 23:54:54 GMT

Thanks to everyone !

my date variable is numeric, with lengthn8 , yymmddn8 format, I did what Patrick suggested, it works in his example, but for my data set , it did not work .note he was using yymmdd8. , my format is yymmddn8. I am not sure if that is a problem.

Re: Generate year from sas date (YYMMDDN8.)

art297 — Sat, 14 Mar 2015 00:53:13 GMT

If you already have a variable that has a SAS date, and (e.g.) let's assume it is called DATE, then all you need is:

year=year(date);

month=month(date);

The format is totally irrelevant to what you are trying to do.

Re: Generate year from sas date (YYMMDDN8.)

LanMin — Sat, 14 Mar 2015 01:37:59 GMT

Hi Arthur,

My date variable is not sas date,

I rerun my code based on Patrick and OS2rules advice. I think the error was caused by missing values for some observations for date variable.

I try to drop missing dates (note: it is numeric). this did not work

drop if FDATES=.;

below is without dropping missing

106 data test;

107 set source.ib;

108 sasdate=input(put(FDATES,8.),yymmdd8.);

109

110 year=year(sasdate);

111 month=month(sasdate);

112 run;

NOTE: Invalid argument to function INPUT at line 108 column 12.

FPEDATS=19811231 CUSIP=80556710 ANALYS=008474 sasdate=. year=. month=. _ERROR_=1 _N_=1

NOTE: Invalid argument to function INPUT at line 108 column 12.

FPEDATS=19811231 CUSIP=80556710 ANALYS=008474 sasdate=. year=. month=. _ERROR_=1 _N_=2

NOTE: Invalid argument to function INPUT at line 108 column 12.

FPEDATS=19820331 CUSIP= ANALYS=030130 sasdate=. year=. month=. _ERROR_=1 _N_=3

Re: Generate year from sas date (YYMMDDN8.)

LanMin — Sat, 14 Mar 2015 02:27:55 GMT

Hi everyone,

please allow me to correct my last post, I thought it was missing date value that is causing the error, but it is not.

my date variable name is FPEDATS

PROC CONTENTS shows :

1	FPEDATS	Num	8	YYMMDDN8.	Forecast Period End Date, SAS Format

25 data test;

27 set source.ib;

28 sasdate=input(put(FPEDATS,8.),yymmdd8.);

29 run;