Convert SQL Code to SAS

VALLY — Tue, 21 May 2019 10:44:45 GMT

I am trying to convert some SQL Server code into a SAS proc SQL format but there are a couple of things I have not figured out how to code

SELECT A.[KEY]

,A.[VOLUME]

,A.[DATE]

,A.[FLAG]

--,[PREV_MONTH] = DATEADD(MONTH,-1,A.[DATE])

,[DIFFERENCE] = CASE

WHEN CAST(A.[VOLUME] AS FLOAT) - CAST(B.[VOLUME] AS FLOAT) IS NULL THEN 0

ELSE CAST(A.[VOLUME] AS FLOAT) - CAST(B.[VOLUME] AS FLOAT)

END

,[SUM_] = CAST(A.[VOLUME] AS FLOAT) + CAST(B.[VOLUME] AS FLOAT)

FROM [ATM Index].[dbo].[CIB_FINALE_2] A

LEFT JOIN [ATM Index].[dbo].[CIB_FINALE_2] B

ON B.[KEY] = A.[KEY]

AND B.[FLAG] = A.[FLAG]

AND MONTH(B.[DATE]) = MONTH(DATEADD(MONTH,-1,A.[DATE]))

ORDER BY 1,3,4

Re: Convert SQL Code to SAS

PeterClemmensen — Tue, 21 May 2019 11:30:04 GMT

Hi and welcome to the SAS Communities 🙂

What do you have so far? And what haven't you figured out yet?

VALLY — Tue, 21 May 2019 13:14:10 GMT

am still struggling ..i will appreciate if you could help