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