About ebad_shakeeb

ebad_shakeeb · ‎06-27-2018

Hi, Thanks for you respond, please have the following ticket No; 7612481615

ebad_shakeeb · ‎06-27-2018

Hi, I have already open a ticket with Support team, but still almost 24 hours i did not get any update or feedback.

ebad_shakeeb · ‎06-27-2018

I have restarted the SAS server and after normal start everything is working normal except SAS CUSTOMER INTELLIGENCE STUDIO, SAS MA Version: 5.41 Problem: Can login to SAS CI but unable to open or create campaign. I have check the log but did not find exact problem, anyone please help it is urgent.

ebad_shakeeb · ‎01-30-2018

proc sql noprint; drop table &outtable; create table &outtable as select a.subs_id as subs_id from &INTABLE b, &OUTTABLE.Tn_3 a where a.subs_id=b.subs_id; quit;

ebad_shakeeb · ‎01-30-2018

it works fine but did not parse the information in the SAS CI

ebad_shakeeb · ‎01-30-2018

Thanks for your replay Mr. Shmuel, Yes i expect the same to have 2 records and the last table created with two, but in the SAS Customer Intelligence Studio interface the node after process and process node both are zero _null_ proc sql noprint; drop table &outtable; create table &outtable as select a.subs_id as subs_id from &INTABLE b, &OUTTABLE.Tn_3 a where a.subs_id=b.subs_id; quit; it create the table but did parse the subs_id to lower node in interface.

ebad_shakeeb · ‎01-30-2018

Thanks for the replay, Yes has the right to delete and it successfully deletes.

ebad_shakeeb · ‎01-30-2018

1: Table mkt.afa_subs_campaign: has the records of all subs who is eligible for marketing campaign (Low Call Rate / Bonus On Recharge), before the eligible subs opt-in for the offer the UIP server check this table either is eligible of not ! 2: Table BICRMMA.SMS_OPT_OUT: has the records of subs they requested to not send us SMS or Offer notification. 3: My input (&INTABLE): is subs that activated their MSISDN since last year and since last 3 weeks they did not recharged or top-up and their state is one-way-block (my input from upper node in SAS Customer Intelligence Studio) 4: My Desire out is (&OUTTABLE): the remaining records (&INTABLE) after deletion of records of mkt.afa_subs_campaign & bicrmma.sms_opt_out from &INTABLE; The issue is that every steps in the macro works fine and no error and warning indication in log file but did not pars the information from process node to temporary cell node or did not show the count on the process node. I have attached log file as well.

ebad_shakeeb · ‎01-30-2018

Thanks for replay... I am getting the input from upper node (Price Plan) and after that need to exclude those subscriber who doesn't want the campaign and SMS and as well as exclude those subs who already have one marketing benefit offer.

ebad_shakeeb · ‎01-28-2018

I have created the store procedure, will calling it doesn't gives me the desire output, which is the deletion records from INTABLE. As Tested only the porblem is with &OUTABLE at last... %global stdcode; %STPBEGIN; %MASPINIT; %Macro InitialNode_Setup; %if &INTABLE EQ %then %MA_Set_Output_Subject_ID(&Subject); %mend InitialNode_Setup; %MACRO S_MERGE; LIBNAME SAS_BASE base "C:\CI\SAS_BASE_LIB"; libname mkt oracle path=mkt SCHEMA=CCMKT USER=CCMKT PASSWORD="*************" dbsliceparm=all; LIBNAME BICRMMA TERADATA SERVER=BITERADATA SCHEMA=DP_BVEW USER=ETICRM PASSWORD="{SAS002}5FF62C162FA4F37B53CC523625AB8AB1" dbsliceparm=all; %LET std_code=&stdcode; proc sql; create table &OUTTABLE.Tn_1 as select a.subs_id as subs_id from mkt.afa_subs_campaign a, &intable b where a.std_code="&std_code" and a.subs_id=b.subs_id; run; %put SQLEXITCODE2=&SQLEXITCODE; %put SQLOBS2=&SQLOBS; proc sql; CREATE TABLE &OUTTABLE.Tn_2 AS select b.subs_id from bicrmma.sms_opt_out a, bicrmma.cc_subs_basic b, &intable c where a.msisdn=b.acc_nbr and b.subs_id=c.subs_id; run; %put SQLEXITCODE1=&SQLEXITCODE; %put SQLOBS1=&SQLOBS; proc sql; create table &OUTTABLE.Tn_3 as select subs_id as subs_id from &INTABLE ; run; %put SQLEXITCODE1=&SQLEXITCODE; %put SQLOBS1=&SQLOBS; proc sql; delete from &OUTTABLE.Tn_3 where subs_id in (select subs_id from &OUTTABLE.Tn_1); delete from &OUTTABLE.Tn_3 where subs_id in (select subs_id from &OUTTABLE.Tn_2); run; proc sql noprint; drop table &outtable; create table &outtable as select a.subs_id as subs_id from &INTABLE b, &OUTTABLE.Tn_3 a where a.subs_id=b.subs_id; quit; %put SQLEXITCODE3=&SQLEXITCODE; %put SQLOBS3=&SQLOBS; %MEND S_MERGE; %MACOUNT(&OUTTABLE); %MASTATUS(&_STPWORK.STATUS.TXT); %STPEND; %S_MERGE; %InitialNode_Setup;

ebad_shakeeb · ‎05-20-2015

Dear RW9, I am now with SAS, and it may take time to be deep in, and as well as the source data in two different DBs (Oracle and Teradata) so somehow i really need to get my result, currently I get the information from Teradata through Customer Intelligence studio and insert the information in Oracle at the same time it should be updated...

ebad_shakeeb · ‎05-20-2015

Thanks Dears, For select 10 random numbers through SAS, i couldn't find so i have create a view in Oracle and call the data of that view in SAS. ORACLE, for every iteration it passes the 10 random rows. select * from (select * from io_campaign a where a.campaign_id='CAMP1545' and a.n_type='CONTROL' and a.exec_date=trunc(sysdate) order by DBMS_RANDOM.RANDOM) k where rownum <=10; SAS, ranuni function it assign a value at once so the loop was continuously process, with a warning. WARNING: A value expression of the SET clause references the data set being updated. select x.subs_id from (select a.subs_id,ranuni(count(*)) as nn from mkt.io_campaign a where a.campaign_id="CAMP1545" and a.n_type='CONTROL' and datepart(exec_Date)=today()-3 and monotonic() le 7)x);

ebad_shakeeb · ‎05-19-2015

Thanks a lot dear.

ebad_shakeeb · ‎05-19-2015

Dears, I am new with SAS Macro, i have created a basic procedure in oracle, and need to have it in SAS as well, Oracle Procedure, Declare w1 number := 0; w2 number := 0; w3 number := 0; w4 number := 0; BEGIN LOOP update io_campaign a set a.n_type='T' where rowid in ( select rowid from io_campaign b where b.n_type='T' and rownum <=5 order by DBMS_RANDOM.RANDOM); COMMIT; update io_campaign a set a.n_type='C' where rowid in( select rowid from io_campaign a where a.n_type='T' rownum <=5 order by DBMS_RANDOM.RANDOM); commit; select a.TOTAL_W1, a.TOTAL_W2, a.TOTAL_W3, a.TOTAL_W4 into w1, w2, w3, w4 from precision_factor a where a.campaign_id='CAMP1539' and A.N_TYPE='PRECISION_FACTOR' AND A.EXEC_DATE=TRUNC(SYSDATE); EXIT WHEN W1 between 0.97 AND 1.03 and W4 between 0.97 AND 1.03 and W2 between 0.97 AND 1.03 and W3 between 0.97 AND 1.03 ; END LOOP; END; In SAS I have it like below and it is not working %Macro abc; libname mkt oracle path=mkt SCHEMA=XXXXX USER=XXXXX PASSWORD="XXXXXX"; proc sql; %let w1 = 1.5; %let w2 = 0.96; %let w3 = 1.23; %let w4 = 0.34; %let a = 1.03; %let b = 0.97; select a.TOTAL_W1, a.TOTAL_W2, a.TOTAL_W3, a.TOTAL_W4 into :w1, :w2, :w3, :w4 from mkt.precision_factor a where a.campaign_id="CAMP1545" and A.N_TYPE='PRECISION_FACTOR' AND datepart(A.EXEC_DATE)=today(); %DO %WHILE((&w1 between '&b' and '&a' ) and (&w2 between '&b' and '&a' ) and (&w3 between '&b' and '&a' ) and (&w4 between '&b' and '&a' )); update mkt.io_campaign set n_type='T' where subs_id in ( select x.subs_id from (select a.subs_id,ranuni(count(*)) as nn from mkt.io_campaign a where a.campaign_id="CAMP1545" and a.n_type='C' and datepart(exec_Date)=today()-3 and monotonic() le 7)x); update mkt.io_campaign set n_type='C' where subs_id in ( select b.subs_id from (select a.subs_id,ranuni(count(*)) as nn from mkt.io_campaign a where a.campaign_id="CAMP1545" and a.n_type='T' and datepart(exec_Date)=today()-3 and monotonic() le 7)b); select a.TOTAL_W1, a.TOTAL_W2, a.TOTAL_W3, a.TOTAL_W4 into :w1, :w2, :w3, :w4 from mkt.precision_factor a where a.campaign_id="CAMP1545" and A.N_TYPE='PRECISION_FACTOR' AND datepart(A.EXEC_DATE)=today(); %put &w1 &w2 &w3 &w4; %END; run; %MEND abc; and receiving following ERROR ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: (&w1 between '&b' and '&a' ) and(&w2 between '&b' and '&a' ) and (&w3 between '&b' and '&a' ) and (&w4 between '&b' and '&a' ) ERROR: The condition in the %DO %WHILE loop, (&w1 between '&b' and '&a' ) and(&w2 between '&b' and '&a' ) and (&w3 between '&b' and '&a' ) and(&w4 between '&b' and '&a' ), yielded an invalid or missing value, . The macro will stop executing. ERROR: The macro ABC will stop executing.

Online Status	Offline
Date Last Visited	‎06-27-2018 10:24 AM

Re: SAS Customer Intelligence Studio can not open saved campaign

Re: SAS Customer Intelligence Studio can not open saved campaign

SAS Customer Intelligence Studio can not open saved campaign

Re: Output store procedure

Re: Output store procedure

Re: Output store procedure

Re: Output store procedure

Re: Output store procedure

Re: Output store procedure

Output store procedure

Re: Do while with Multi-Conditions

Re: Do while with Multi-Conditions

Re: SAS Customer Intelligence Studio can not open saved campaign

Re: SAS Customer Intelligence Studio can not open saved campaign

SAS Customer Intelligence Studio can not open saved campaign

Re: Output store procedure

Re: Output store procedure

Re: Output store procedure

Re: Output store procedure

Re: Output store procedure

Re: Output store procedure

Output store procedure

Re: Do while with Multi-Conditions

Re: Do while with Multi-Conditions

Re: Do while with Multi-Conditions

Do while with Multi-Conditions