When the month changes, a calendar week can be split into two technical weeks: TWa (part of the week in the previous month) and TWb (part of the week in next month)   In a technical week, we would like to separate data based on months. For example: Transition week - 5th week of 2023 have 2 days from Jan month(30th & 31st) and 5 days from Feb month(1st to 5th) Data needs to be separated based on week along with month but should not aggregate the whole week data in a transition week as shown below. Please suggest us the appropriate code for the technical week issue. ... View more

Hi ,   I am executing a EG code and the job is running fine and data is loading as expected but i could see error symbol at the top (job level, see the attachment which i market as 1 ).   Also there is no error in log (see the attachment which i market as 2.)   I though its a server or EG issue but other jobs are running fine.   I request you to please suggest me how to resolve this .. Thank for your help.     ... View more

Hi, I have a dataset as below: i want to write a query when calander_week is same and repli_flag 1, 0 then i want to pick Repli_flag 0 values and need to drop repli_flag 1.   Thanks in advance ... View more

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 ... View more

Hi All,   I have two source tables and as per the requirement i need to convert char to num and keep the values as 01 insted of 1. for that i have written below query and executed in Enterprise guide and its running successfully. The problem is whan i executing same job in IDPortal it is getting error:   please take alook on below query and error:   PROC SQL;  CREATE TABLE st.Final (DROP= _NAME_ ACTUAL LOWER UPPER ERROR STD _RECONSTATUS_ prebfovr lowbfovr uppbfovr stdbfovr sProject) as select * from stg.final_CREAM as a left join in.GROUP_LOAD as b on a.sBrand=b.sBrand and a.sFSGroup =b.sFSGroup and scan(a.CL4_NAME,1,'_')=b.CL4_NAME and a.Dist_Channel =INPUT(b.DISTR_CHAN,Z2.); ERROR: The informat Z was not found or could not be loaded.   looking forward for your help and support. ... View more

Hi,   i want to see what are the formats available in a catalog.   looking forward for your help,     ... View more

Hi All,   I have a variable name Policy_no and the values are   Policy_no 56789/k0256 58796548/k908 4785/Nk02   I want to read the value before /      or  want to delete  (/k0256)   finally i want to read as below  56789      58796548      4785   Thank you in advance ... View more

I have a data set with variable name called description.   Description="The mobile is produced by Apple"   From the above string, i want to extract from by Apple the length is not consistence but i wanted to extract from by.   Thanks in advance. ... View more

Hi,   I have a library called datatime. In this library i have a dataset names like   data_history_collection_01 data_history_collection_02 data_history_collection_03 data_history_collection_04 data_history_collection_05 data_history_collection_06 data_history_collection_07   Problem: every month the above table is generating with new version.  Solution:I need to extract the new version of dataset when ever its creates. that means recent dataset.   Thanks.   ... View more