BookmarkSubscribeRSS Feed
Pandu
Fluorite | Level 6

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

1 REPLY 1

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 563 views
  • 0 likes
  • 2 in conversation