SAS BASE

Pandu — Thu, 03 Mar 2022 07:07:01 GMT

Hi ,

I have a query like below.

PROC SQL;
CREATE TABLE T_REPLI_RC10_HIST AS
SELECT t1.*,t2.MAX_Week_Commencing
FROM &_INPUT1. t1
LEFT JOIN T_REPLI_RANGE t2 ON (t1.Customer_ID = t2.Customer_ID) AND (t1.PROD_Group = t2.PROD_Group)
WHERE t1.Week_Commencing >= t2.MIN_Week_Commencing AND t1.Week_Commencing <= t2.MAX_Week_Commencing AND strip(t1.Env) = strip(tranwrd("&SCENARIO.","PRD","P"));
QUIT;

i want to delete rows when t1.Week_Commencing <= t2.MAX_Week_Commencing.

Hoe can i mention that in the above code? thank you for your help in advance

Re: SAS BASE

Kurt_Bremser — Thu, 03 Mar 2022 07:41:12 GMT

Inverse the condition in your WHERE clause (> instead of <=).

topic Re: SAS BASE in SAS Programming

SAS BASE

Re: SAS BASE