HI ALL DOES ANYONE KNOW HOW TO RUN IT SUCCESSFULLY WHAT IS THE PROBLEM WITH THIS CODE %MACRO SponsorMonthly1(A=,C=); proc sql; create table PortfolioPeriods as SELECT BusinessUnit ,Written.Period ,Written.UWYear ,Written.ExposurePeriod FROM Written WHERE Written.Period >= 201201 AND Written.Pac IN &A AND Written.PolicyNo IN (SELECT MeridianSponsor.MeridianNo as Policy_No FROM MeridianSponsor WHERE MeridianSponsor.Sponsor in &C ; run; %mend; %SponsorMonthly1(A=('GMMAE' 'GMMAM') , C=('A10')); THIS IS MY LOG BUT I DON'T KNOW WHAT IS HAPPENING 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 2 TITLE; 3 FOOTNOTE; 4 OPTIONS LOCALE=en_US DFLANG=LOCALE; NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. 5 DATA _NULL_; 6 RUN; 7 OPTIONS VALIDVARNAME=ANY; 8 OPTIONS VALIDMEMNAME=COMPAT; 9 FILENAME _HTMLOUT TEMP; 10 FILENAME _RTFOUT TEMP ENCODING='UTF-8'; 11 FILENAME _PDFOUT TEMP; 12 FILENAME _GSFNAME TEMP; 13 FILENAME _DATAOUT TEMP; 14 %LET SYSCC=0; 15 %LET _CLIENTAPP=SAS Studio; 16 %LET _CLIENTAPPVERSION=3.6; 17 %LET _SASSERVERNAME=%BQUOTE(SASAPAC); 18 %LET _CLIENTUSERID=%BQUOTE(f022m54); 19 %LET _CLIENTUSERNAME=%BQUOTE(Harry Lui (Kwan Hin)); 20 %LET CLIENTMACHINE=%BQUOTE(10.134.5.173); 21 22 %LET _SASPROGRAMFILE = %BQUOTE(); 23 %LET _BASEURL = %BQUOTE(http://cbrtplpst01.chubb.com:7980/SASStudio/); 24 %LET _EXECENV=SASStudio; ______________________________________________________________________________________________________________________ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 25 DATA _NULL_; 26 CALL 26 ! SYMPUT("GRAPHINIT" _ 49 26 ! ,""); 27 CALL 27 ! SYMPUT("GRAPHTERM" _ 49 27 ! ,""); NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 28 RC=TSLVL('GEOCODE','N'); 29 _ERROR_=0; 30 IF (RC^=' ') THEN DO; 31 CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;"); ___ ________________ 49 49 32 CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;"); ___ ___________________________________ 49 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 33 END; 34 RUN; 35 DATA _NULL_; 36 RC=SYSPROD("PRODNUM002" _ 49 36 ! ); NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 37 IF (RC^=1) THEN DO; 38 CALL 38 ! SYMPUT("GRAPHINIT" _ 49 38 ! ,""); NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 39 CALL SYMPUT("GRAPHTERM",""); 40 END; 41 RUN; 42 %LET _DATAOUT_MIME_TYPE=; 43 %LET _DATAOUT_NAME=; 44 %LET _DATAOUT_TABLE=; 45 %LET _DATAOUT_URL=; 46 %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE; 47 %LET _SASWS_ = %BQUOTE(/u/f022m54); 48 %LET _SASWSTEMP_=%BQUOTE(/u/f022m54/.images/afa6fdb0-2f7c-4146-8a04-51778cf0d01f); 49 ODS LISTING CLOSE; 50 OPTIONS PRINTERPATH=PDF; 51 ODS AUTONAVIGATE OFF; 52 ODS GRAPHICS ON; 53 ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8 FILE=_HTMLOUT (TITLE='Results: Program 1') 53 ! STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE' 53 ! CSS_PREFIX='.ods_afa6fdb0-2f7c-4146-8a04-51778cf0d01f' BODY_ID='div_afa6fdb0-2f7c-4146-8a04-51778cf0d01f' ); 54 ODS RTF (ID=WEB) STYLE=Rtf FILE=_RTFOUT sasdate; NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. 55 ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT; 56 &GRAPHINIT; 57 OPTIONS FIRSTOBS=1; 58 OPTIONS OBS=MAX; 59 OPTIONS DTRESET DATE NUMBER NOTES; 60 %put %bquote(NOTE: ODS statements in the SAS Studio environment may disable some output features.); NOTE: ODS statements in the SAS Studio environment may disable some output features. 61 OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK; 62 63 %MACRO SponsorMonthly1(A=,C=); ERROR: The macro SPONSORMONTHLY1 is still executing and cannot be redefined. ERROR: A dummy macro will be compiled. 64 65 proc sql; 66 create table 67 PortfolioPeriods as 68 SELECT 69 BusinessUnit 70 ,Written.Period 71 ,Written.UWYear 72 ,Written.ExposurePeriod 73 FROM Written 74 WHERE Written.Period >= 201201 75 AND Written.Pac IN &A 76 AND Written.PolicyNo IN (SELECT MeridianSponsor.MeridianNo as Policy_No FROM MeridianSponsor WHERE 76 ! MeridianSponsor.Sponsor in &C 77 78 ; 79 run; 80 81 82 %mend; NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. 83 84 %SponsorMonthly1(A=('GMMAE' 'GMMAM') , C=('A10')); 85 86 87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 88 ODS HTML CLOSE; 89 &GRAPHTERM; ;*';*";*/;RUN;QUIT; 90 QUIT;RUN; 91 ODS HTML5 (ID=WEB) CLOSE; 92 93 ODS RTF (ID=WEB) CLOSE; 94 ODS PDF (ID=WEB) CLOSE; 95 FILENAME _GSFNAME; 96 DATA _NULL_; 97 RUN; 98 OPTIONS VALIDMEMNAME=COMPAT; 99 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK; 100
... View more