topic Date Format Coversion in SAS Programming

Date Format Coversion

ZZB — Tue, 24 Feb 2015 19:55:08 GMT

Hello,

I have a set of time series of date data (see below). But the type of data is 'Numerical', the Format is 'Best12.' and informat is 12.''. When I use the code 'year(date)', I get wrong outcome. How to manipulate these date data if I want to get '1960 for year and 01 for month of first obs' using codes 'year(date) and month(date)'? Thanks

date

196001

196002

196003

196004

.....

Re: Date Format Coversion

PaigeMiller — Tue, 24 Feb 2015 19:58:29 GMT

year=floor(date/100);

month=mod(date,100);

The YEAR and MONTH functions that you are trying to use only work on data stored as SAS dates, which these are not.

Re: Date Format Coversion

SASKiwi — Wed, 25 Feb 2015 08:43:15 GMT

If you want to make a SAS date from your date number first:

format sas_date date9.;

sas_date = input(date, yymmn6.);

year = year(sas_date);

month = month(sas_date);

Re: Date Format Coversion

naveen20jan — Wed, 25 Feb 2015 08:46:50 GMT

Hi ,

We can also use the below approach .

data have ;

input date ;

year = input(substr(strip(date),1,4),6.);

month= input(substr(strip(date),5,2),4.);

datalines;

196001

196002

196003

196004

;

run;