topic Re: How to make comparison with date in SAS Programming

How to make comparison with date

toesockshoe — Sun, 08 Jul 2018 23:00:21 GMT

Not sure if this is the correct sub forum? Hopefully someone can redirect me if I'm on the wrong one.

Bascially I want to know how to subset a dataset to only the records dates before 07May2017 (in that exact format). How do I do this? Is there some website where I can find documentation on this? The data type of the field is date. thanks in advance!

Re: How to make comparison with date

novinosrin — Sun, 08 Jul 2018 23:42:14 GMT

data want;

set have;

where date<'07May2017'd;

run;

assumption: your dates are sas date numeric variable

Re: How to make comparison with date

Kurt_Bremser — Mon, 09 Jul 2018 06:17:22 GMT

I recommend reading this paper: https://support.sas.com/resources/papers/proceedings15/1334-2015.pdf. It has everything a beginner needs to know about SAS dates, and then some.

PS it is the second result of a google search for "sas 9.4 date and time values". See Maxim 6.