Hi All, Is it possible to use code in a process node to update a table in the InfoMap? I need the table in the infomap to be refreshed before I call data from that table in the comms node. I get an error when I try: The below is an extract from the code I use. The customer_ref table has already been created. These steps work fine in SAS eGuide. data single_row_data; set customer_ref; by customer_id TimeStamp; if first.customer_id; run; proc sql; create table MKTADHOC.VOM_CUAD_SINGLE_ROW_DATA AS SELECT * FROM WORK.SINGLE_ROW_DATA; QUIT; proc sql; create table &outTable as select cdtls.Customer_ID as Customer_ID from SASMAR.MA_CUSTOMER cdtls inner join SINGLE_ROW_DATA srd on cdtls.customer_id=srd.customer_id ; quit; %macount(&outTable); Where the MKTADHOC table is readable in the infomap. I need data in this table to be updated as I need to output some data fields in this table relevant for members present in the campaign. This error comes up: Error in the stored process or a called macro - vendor code: 1012. I'm not a coder. And not a SAS expert. I've tried to use the below somewhere as well, but I do not think it makes a difference. %stpbegin; %maspinit; options dsnferr; If you can let me know what the problem is that would be great. Thanks, MV
... View more