What is File > Print? I'm no SAS programmer 😞 ... View more

Thank you, this helps me with a different issue! 🙂 ... View more

I marked another response as the solution (before you wrote your own), but I saw yours too so I just want to say thank you! 🙂 ... View more

Firstly, thank you for your solution. Secondly, I'd like to know one more thing - I guess I can join tables CI_CELL_PACKAGE & CI_CTL_GRP_CELL_X_TEST_CELL via cells, and know the exact ID's of the population that has been exported through the combination of campaign_cd, communication_cd, treamtment_cd, response_tracking_cd, row_create_date (feel free to correct me if I'm wrong/inaccurate). Is there a better way to find those ID's? I'm asking because, from what I've seen, I can hold certain groups from being exported, and the cell will be marked in those tables you've mentioned, but that cell got a population according to a certain select block in CIS which, each day, slightly changes its population. So I need a good practice for finding those ID's. ... View more

Hey, Then I see no difference between your screenshot and an attemp I've made DATDIF(DATEPART(<<A.X>>),DATEPART(<<B.Y>>),'Actual') I'll ask my SAS Support for any malfunctions then...! ... View more

Hey,   Firstly, thank you for your help.   I've made several attemps with DADIF, trying to create another calculate item (in Information maps because that's where my client asks caculated items to be created), but I failed miserably because my expressions don't pass validation. Also, I checked https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/p1gz65986b9jqin19zk9xqbi7ns3.htm and I didn't see 'Actual' as a possible inserted parameter, though It does appear in a code example but that's outside of CIS as far as I know. ACT/ACT seems related to this topic. A bit more info that might help: X is a field in table A with date format 2013-07-24 Y is a field in table B with date format 2013-07-24 (same format) Perhaps it is not possible to use two fields from two different tables? Here are some of my attempted expressions for DATDIFF(Y,X,'Actual'): DATDIF(DATEPART(<<A.X>>),DATEPART(<<B.Y>>),'ACT/ACT') DATDIF(DATEPART(<<A.X>>),DATEPART(<<B.Y>>),'Actual') DATDIF(<<A.X>>,<<B.Y>>,'ACT/ACT') DATDIF(<<A.X>>,<<B.Y>>,'Actual') DATDIF(<<'2021-07-07'>>,<<'2021-08-08'>>,'ACT/ACT') DATDIF(<<'2021-07-07'>>,<<'2021-08-08'>>,'Actual') ... View more

I wasn't aware of this option. Problem solved, thank you!! 🙂 ... View more

@DavidHD  I've found the logic object (called Gate). It has either an AND logic or OR logic. After several checks - Sadly, AND means, as you've mentioned, that all of the converging paths must be completed successfully in order to continue. OR means any can be completed successfully in order to continue. Is there any way to cause the Gate to wait for all converged paths to finish (either with errors or successfully), and then continue? Keep in mind "Continue running the flow and change the flow state after the flow is complete" is already on. ... View more