Many thanks, sorry for my basic question I am still learning. You are very kind. ... View more

  %macro test; %if &export_flag = Y %then %do; data jorquec.TRIGGERPAYG; SET JORQUEC.TESTPAYG2; run; %end; %mend; %test; /* Many thanks, now is fine!! */ ... View more

1 The SAS System 08:22 Wednesday, July 24, 2019 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='FINAL_VERSION'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH='D:\SAS\jorquec\Model_rebuild\2019\Manangement Console\Trigger event_PAYG.egp'; 6 %LET _CLIENTPROJECTPATHHOST='RESCZKWTS004'; 7 %LET _CLIENTPROJECTNAME='Trigger event_PAYG.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGPDF TEMP; 15 ODS PDF(ID=EGPDF) FILE=EGPDF STYLE=Pearl; NOTE: Writing ODS PDF(EGPDF) output to DISK destination "EGPDF", printer "PDF". 16 FILENAME EGSR TEMP; 17 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 18 STYLE=HtmlBlue 19 STYLESHEET=(URL="file:///C:/SAS94/software/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 20 NOGTITLE 21 NOGFOOTNOTE 22 GPATH=&sasworklocation 23 ENCODING=UTF8 24 options(rolap="on") 25 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 26 FILENAME EGXLSSX TEMP; 27 ODS EXCEL(ID=EGXLSSX) FILE=EGXLSSX STYLE=Excel 28 OPTIONS ( 29 EMBEDDED_TITLES="no" EMBEDDED_FOOTNOTES="no" 30 ); 31 32 GOPTIONS ACCESSIBLE; ERROR: The %IF statement is not valid in open code. 33 %if &export_flag = Y %then %do; 34 35 data jorquec.TRIGGERPAYG2; 36 SET JORQUEC.TRIGGERPAYG; 37 run; NOTE: There were 1 observations read from the data set JORQUEC.TRIGGERPAYG. NOTE: The data set JORQUEC.TRIGGERPAYG2 has 1 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 564.93k OS Memory 38604.00k Timestamp 24/07/2019 10:25:52 AM Step Count 15 Switch Count 2 Page Faults 0 Page Reclaims 59 Page Swaps 0 Voluntary Context Switches 12 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 136 2 The SAS System 08:22 Wednesday, July 24, 2019 38 39 /* PROC EXPORT DATA=JORQUEC.TRIGGERPAYG 40 OUTFILE='//SASCommon/jorquec/TRIGGERPAYG.TXT' 41 DBMS=dlm 42 REPLACE; 43 delimiter='&'; 44 RUN;*/ 45 46 %end; ERROR: The %END statement is not valid in open code. 47 48 GOPTIONS NOACCESSIBLE; 49 %LET _CLIENTTASKLABEL=; 50 %LET _CLIENTPROCESSFLOWNAME=; 51 %LET _CLIENTPROJECTPATH=; 52 %LET _CLIENTPROJECTPATHHOST=; 53 %LET _CLIENTPROJECTNAME=; 54 %LET _SASPROGRAMFILE=; 55 %LET _SASPROGRAMFILEHOST=; 56 57 ;*';*";*/;quit;run; 58 ODS _ALL_ CLOSE; NOTE: ODS PDF(EGPDF) printed no output. (This sometimes results from failing to place a RUN statement before the ODS PDF(EGPDF) CLOSE statement.) NOTE: Writing EXCEL(EGXLSSX) file: /saswork94/SAS_work467F000089F0_czhrk-dl580nucprod-310-fe/#LN01122 59 60 61 QUIT; RUN; ... View more

Hi  I changed as you suggested, now it works , the export file is created however I still receive this message : ERROR: The %END statement is not valid in open code.       /* STEP 2 */   DATA JORQUEC.TRIGGERPAYG; SET JORQUEC.TESTPAYG; IF  (maxmargin_dt >= (&ONEDT2.)/100) and (maxmodelmart_d = &month_id.) then export_flag='Y';  else export_flag='N';   call symputx('export_flag', export_flag);   run;   *check value of macro variable; %PUT Export_Flag = &export_flag;   /* STEP 3 - PROC EXPORT -*/   %if &export_flag = Y%then %do;    PROC EXPORT DATA=JORQUEC.TRIGGERPAYG  OUTFILE='//SASCommon/jorquec/TRIGGERPAYG.TXT'  DBMS=dlm   REPLACE;   delimiter='&';  RUN;   %end;   ... View more

Many thanks. It was very helpful. ... View more

Thanks many thanks , it is perfect. So glad for your help. ... View more

Many thanks for your suggestion  Just a question   as example   if   maxmodelmart_d ( which is a macro date, I just wrote as number to be easy )  is different from what was saved on Jorquec.test so the  if then do will not run ?   Because is exactly this check that I need, if the actual value of the macro is different from what is saved then don run the proc export.   ... View more

Many thanks for your  help. These are my answers: Does your data set have only one row?  Yes just one row  as below: my dataset called JORQUEC.TEST has just one row with 3 variables: ID   maxmargin_dt   maxmodelmart_d 1       30JUN2019       359   Your If condition would evaluate for multiple lines of your data so it's possible that some will be true and some will be false?  No it will evaluate just one line. What version of SAS do you have?  9.4 Is this block of code within a macro already? yes How much do you know about macros? almost nothing I am struggling with this . Is there a reason you have a file with an extension of CSV with & as the delimiter?  No it could be any kind of file .   Let me clarify better my objective: Step1: I check two diferent  tables and extract the maximum date from those, with this information save a data set Jorquec.test Step2:  Step3: ( most difficult for me) I need to check if those dates maxmargin_dt is equal to previous month ( a macro month that I called ONEDT2  , I really dont know if it is correct ) and maxmodelmart_d is different from ( a macro called monthid), if both conditions are true then create a file that could be an empty file as well as I just need to create this file because this would be my trigger for another process.   Does it make sense now for you?     /*-----------------SAS  CODE ------------------*/   %let today=%sysfunc(today()); %let currdt=%sysfunc(datetime()); %let month_id = %str(%')&MONTHID1.%str(%');/*'340';*/       data _null_; date2=intnx("month",&today.,-1,'end'); call symput('ONEDT2',"1"||substr(put(date2,DDMMYYN.),7,2)||substr(put(date2,DDMMYYN.),3,2)||substr(put(date2,DDMMYYN.),1,2)); %put &ONEDT2.;   mthid1=intck('month','01jan1990'd,&today.)+1-1; call symput('MONTHID1',put(mthid1,3.)); %put &MONTHID1.;   run; /*STEP 1 */   Proc SQL; connect to teradata  (user=&teradata_user. password=&teradata_pwd. server = 'edwprod' database = 'nuc_pl_user_view');   Create  table JORQUEC.TEST as select * from connection to teradata(    select a.ID,  a.maxmargin_dt, b.maxmodelmart_d from  (     select   1 as ID,   max(month_end_dt) as maxmargin_dt from nuc_pl_user_view.pg_margin_stack) as A left join ( select   1 as ID, max(month_id) as maxmodelmart_d  from  Insights_rm.Consumer_Model_Mart) as B on a.ID = b.ID    ); disconnect from teradata ; QUIT;   /* STEP 2 */   DATA JORQUEC.TEST2; SET JORQUEC.TEST; IF  (maxmargin_dt = &ONEDT2.) and (maxmodelmart_d <> &month_id.) then do;   end;   /* STEP 3 - PROC EXPORT -*/    PROC EXPORT DATA=JORQUEC.TEST  OUTFILE='//SASCommon/jorquec/TRIGGER_PAYGO.CSV'  DBMS=dlm   REPLACE;   delimiter='&';  RUN;         ... View more

Sorry,  I didn' t understand I used" if then do as" my first option, then you suggested me to use "where " , please don't be critical . I am new on SAS, English is not but mother language so just be patient .   Someone could please help me ? I just want a code with If then do that just do the Proc Export if all conditions are true.      DATA JORQUEC.TEST2; SET JORQUEC.TEST; IF  (maxmargin_dt = &ONEDT2.) and (maxmodelmart_d <> &month_id.) then do;   end;      PROC EXPORT DATA=JORQUEC.TEST  OUTFILE='//SASCommon/jorquec/TRIGGER_PAYGO.CSV'  DBMS=dlm   REPLACE;   delimiter='&';  RUN;   ... View more

   Hi I have already read help documentation the problem is that this  where condition is not working properly as condition , I mean SAS is running proc export even the condition is not true .  So please could someone really help me ? Many thanks,   This are the results in my data jorquec.test ID  maxmargin_dt maxmodelmart_d 1 30JUN2019 359   So I wrote the code below using maxmodelmart_d = 360 , I expected that prox export does't create a file because one of the conditions is false however he created a file  test2.csv !!!   ----SAS  CODE ---   proc export    data=jorquec.test(   where=( maxmargin_dt = '30Jun2019'd and maxmodelmart_d =360) )       outfile='//SASCommon/jorquec/TEST2.csv'       dbms=dlm        replace;    delimiter='&'; run; ... View more

    Thanks but I still have more errors         proc export data=jorquec.test( where=( maxmargin_dt = '30Jun2019'd and maxmodelmart_d is =359) ) outfile='//SASCommon/jorquec/TEST1.csv' dbms=dlm replace; delimiter='&'; run;        LOG File errors:                                                            ERROR 22-322: Syntax error, expecting one of the following: MISSING, NOT, NULL, ^, ~.     ERROR 76-322: Syntax error, statement will be ignored.   36               outfile='//SASCommon/jorquec/TEST1.csv' ERROR: Syntax error while parsing WHERE clause. ... View more

Hi,    thanks for your collaboration, I repalace with my macro data  however now it doesn't work I received a message  Error 22-7 "Invalid option name And"   It seems he doesn't recognize the comand "and" inside where ()   proc export data=jorquec.test(where=(maxmargin_dt = &ONEDT2.) and (maxmodelmart_d is <> &month_id.)) outfile='//SASCommon/jorquec/TEST1.csv' dbms=dlm replace; delimiter='&'; run;     ... View more