topic Re: CALCULATIONS IN SAS in New SAS User

CALCULATIONS IN SAS

DSC2010 — Wed, 27 Feb 2019 19:13:22 GMT

I am trying to run the following case statement in SAS but keep getting an error:

,CASE

WHEN ((MM,&EOY.) - (MM,Start_Date)) > Term_Length__months_ THEN 'Term_Length__months_'

ELSE ((MM,&EOY.) - (MM,Start_Date)) END AS Flow_Months_2019

,CASE

WHEN ((MM,&EOY.) - (MM,Start_Date)) > Term_Length__months_ THEN '0'

ELSE Term_Length__months_ - ((MM,&EOY.) - (MM,Start_Date)) END AS Flow_Months_Contract

ERROR 79-322: Expecting a (.

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, ), *, **, +, -, '.', /, <, <=, <>, =, >, >=, AND, EQ, EQT,

GE, GET, GT, GTT, LE, LET, LT, LTT, NE, NET, NOT, OR, ^, ^=, |, ||, ~, ~=.

Re: CALCULATIONS IN SAS

rudfaden — Thu, 28 Feb 2019 12:46:19 GMT

Please post a minimal working example

Re: CALCULATIONS IN SAS

PaigeMiller — Thu, 28 Feb 2019 12:59:38 GMT

Show us the log of the entire PROC SQL, and the preceding PROC or DATA step, where this error happens. Click on the {i} icon and paste the log into the window that appears — DO NOT SKIP THIS STEP.

Re: CALCULATIONS IN SAS

Tom — Thu, 28 Feb 2019 16:13:28 GMT

No wonder SAS is confused. Your code looks really strange to me also.

What does this mean?

((MM,&EOY.) - (MM,Start_Date))

Re: CALCULATIONS IN SAS

ballardw — Thu, 28 Feb 2019 17:24:36 GMT

Making a complete guess that

(MM,&EOY.)is intended to do something like calculate the number of months(??) from a given value to "end of year" then the actual calculation is missing. In MM and &EOY. are supposed to be date values then perhaps you are missing a function like INTCK.

If the values are NOT SAS date values then you need to provide:

values of MM, &EOY. and START_date and make sure we can tell whether the values are character or numeric.

If the values ARE supposed to be SAS date values then you need to tell us what this is supposed to actual do as the likely functions involved, INTCK or possibly INTNX, require an INTERVAL, such as 'month' to use.