topic Re: Count Manufacture date in SAS Programming

Count Manufacture date

BrahmanandaRao — Sat, 10 Jul 2021 06:50:09 GMT

data ds;
input company $ manufac_date $ mmddyy10. ;
format manufac_date mmddyy10.;
datalines;
Hynduai 24Oct2001
Maruthi 12Mar2008
scoda   02Aug2007
Tata    16Jun2020
;
run;

data ds1;
set ds;
Years=intck('Year',manufac_date,today());
Months=intck('Month',manufac_date,today());
Days=intck('Day',manufac_date,today());
format Years  Months Days manufac_date today mmddyy10.;
proc print;
run;

I want vehicle manufacture information till today

Re: Count Manufacture date

Kurt_Bremser — Sat, 10 Jul 2021 07:19:58 GMT

The INTCK function returns the number of intervals, not a date, so it makes no sense using a date format.

Re: Count Manufacture date

Kurt_Bremser — Sat, 10 Jul 2021 08:00:35 GMT

BTW since dates are counts of days (a fact you know quite well by now), the last function call is unnecessary and can be replaced by a simple subtraction:

days = today() - manufac_date;

which will be slightly faster.

Re: Count Manufacture date

BrahmanandaRao — Sat, 10 Jul 2021 09:21:57 GMT

data ds1;
set ds;
days = today() - manufac_date;
Years=intck('Year',manufac_date,today()); 
 Months=intck('Month',manufac_date,today()); 
/* Days=intck('Day',manufac_date,today()); */
 format Years  Months Days manufac_date today mmddyy10.; 
proc print;
run;

I got output like this

Re: Count Manufacture date

PaigeMiller — Sat, 10 Jul 2021 11:16:38 GMT

By now, @BrahmanandaRao , you should know you need dates to be numeric if you are going to do mathematical calculations (such as, in your case, subtraction). In your data set, your variable MANUFAC_DATE is character. Won't work. Fix the data set.

Re: Count Manufacture date

BrahmanandaRao — Sat, 10 Jul 2021 12:15:10 GMT

data ds;
input company $ manufac_date date9.  ;
format manufac_date date9.; 
datalines;
Hynduai 24Oct2001
Maruthi 12Mar2008
scoda   02Aug2007
Tata    16Jun2020
;
run;

data ds1;
set ds;
Years=intck('Year',manufac_date,today, today()); 
Months=intck('Month',manufac_date,today()); 
Days=intck('Day',manufac_date,today()); 
format Years  Months Days manufac_date today date9.; 
proc print;
run;

Re: Count Manufacture date

PaigeMiller — Sat, 10 Jul 2021 12:17:30 GMT

I believe @Kurt_Bremser explained already why INTCK is not going to work here.

Re: Count Manufacture date

BrahmanandaRao — Sat, 10 Jul 2021 12:41:02 GMT

data ds;
input company $ manufac_date date9. ;
format manufac_date date9.;
datalines;
Hynduai 24Oct2001
Maruthi 12Mar2008
scoda 02Aug2007
Tata 16Jun2020
;
run;





proc SQL;

select company , manufac_date,
intck('Years',manufac_date,today()) as years,
intck('Month',manufac_date,today()) as months,
intck('Day',manufac_date,today()) as days
from ds
;
quit;

Re: Count Manufacture date

Kurt_Bremser — Sat, 10 Jul 2021 13:48:14 GMT

@BrahmanandaRao wrote:

data ds1;
set ds;
days = today() - manufac_date;
Years=intck('Year',manufac_date,today()); 
 Months=intck('Month',manufac_date,today()); 
/* Days=intck('Day',manufac_date,today()); */
 format Years  Months Days manufac_date today mmddyy10.; 
proc print;
run;

I got output like this

READ.

THE.

LOG.

Re: Count Manufacture date

Kurt_Bremser — Sat, 10 Jul 2021 13:52:53 GMT

@BrahmanandaRao wrote:

data ds;
input company $ manufac_date date9. ;
format manufac_date date9.;
datalines;
Hynduai 24Oct2001
Maruthi 12Mar2008
scoda 02Aug2007
Tata 16Jun2020
;
run;





proc SQL;

select company , manufac_date,
intck('Years',manufac_date,today()) as years,
intck('Month',manufac_date,today()) as months,
intck('Day',manufac_date,today()) as days
from ds
;
quit;

Looks good to me.