Create variable based based on if Date1 is greater than Date2

GMP1978 — Mon, 24 Jun 2019 23:06:22 GMT

I want to create a new variable and return a 1 when Date1 is greater than Date2 and have it formatted as a numeric.

PROC SQL;

CREATE TABLE Direct AS

SELECT RECEIPTS.*

,Case When DATE1 GT Date2 then '1' ELSE '0' end as Date_Compare format=comma8.2

FROM RECEIPTS

QUIT;

Re: Create variable based based on if Date1 is greater than Date2

ballardw — Tue, 25 Jun 2019 13:52:08 GMT

@GMP1978 wrote:

I want to create a new variable and return a 1 when Date1 is greater than Date2 and have it formatted as a numeric.

First, don't put quotes around a value you want as numeric. Quotes define character values.

You can also try

(date1 gt Date2) as Date_compare

SAS will return 1 for true and 0 for false for simple logical comparisons though you may need to think about what you want if either of the two variables is missing

And why do you want comma8.2 format for a value range of 0 and 1???

topic Create variable based based on if Date1 is greater than Date2 in SAS Programming

Create variable based based on if Date1 is greater than Date2

Re: Create variable based based on if Date1 is greater than Date2