topic Substract date variable which is in character in SAS Programming

Substract date variable which is in character

Babloo — Mon, 15 Oct 2018 14:01:38 GMT

I've the date variable as follows and it is in character. Based on this field I've to create the new field (KNDEIND) and it should be in character and the rule for the new field is PODVERD-1. Could you please help me understand how can I achieve this in one step?

PODVERD	KNDEIND
2017-11-25	2017-11-24

Re: Substract date variable which is in character

Astounding — Mon, 15 Oct 2018 14:08:33 GMT

If you would store dates as SAS intended, you could simply use:

KNDEIND = PODVERD - 1;

However, since the requirement is to use character dates, you need to jump through a couple of hoops:

KNDEIND = put(input(podverd, yymmdd10.) - 1, yymmddd10.);

Re: Substract date variable which is in character

mkeintz — Mon, 15 Oct 2018 14:09:03 GMT

@Babloo

I see that you have over 700 posts to the sas forums, and are labelled a "PROC STAR". I feel that I (and others) are the object of (let's say) a distinct lack of effort. Your question is not even accompanied by a report of your own efforts to solve the problem.

Re: Substract date variable which is in character

VDD — Mon, 15 Oct 2018 14:19:01 GMT

I 2nd @mkeintz response!

Re: Substract date variable which is in character

ballardw — Mon, 15 Oct 2018 14:27:07 GMT

Since subtraction is generally not a character function, or at least folks don't have a universal standard of what it would mean, the obvious bit is turn it into a numeric, do the subtraction or data adjustment and then put the numeric to a character.

kndeind= put ( intnx('day',input(podverd,yymmdd10.),-1),yymmddd10.);