What adjustment to the following code could lead to carry out the same only under some specific condition? ODS CSV FILE = "F:\Temp\Test.csv"; PROC PRINT data=WORK.FINALDATA; run; quit; ods _all_ close; In other words, how to have the Test.csv generated only if desired, i.e. judged on the basis of the value of a variable. For example if a macro variable CSVFORM possess the value of 1 or above only then the Test.csv would be generated otherwise only the remaining code would be carried out but Test.csv would not be made. Thanx in advance. ... View more

Hi friends, While looking forward to modify and refine a former code I made a variable to be declared on conditions in the following code: ==== %LET Approach = 'CONTINUOUS'; %LET YrBeg = 2007; %LET YrEnd = 2013; %LET MnBeg = 1; %LET MnEnd = 9; %LET MajDB = FAQ_NF.ConsNFData; %LET WhereClauseA = MIS_MONTH BETWEEN MDY(&MnBeg,1,&YrBeg) AND INTNX("MONTH",MDY(&MnEnd,1,&YrEnd),0,"END"); %LET WhereClauseB = (YEAR(MIS_MONTH) = 2007 AND MONTH(MIS_MONTH) = 😎 OR (YEAR(MIS_MONTH) = 2008 AND MONTH(MIS_MONTH) = 9); %LET WhereClauseC = AND ((UPPER(PRODUCT) = "AUTOS") AND (UPPER(PRODUCT_DESC) = "CAF")) OR   ((UPPER(PRODUCT) = "AUTOS") AND (UPPER(PRODUCT_DESC) NE "CAF")) OR (UPPER(PRODUCT) = "SBL") OR   (UPPER(PRODUCT) = "PIL") OR (UPPER(PRODUCT) = "SECURED") OR (UPPER(PRODUCT) = "UNSECURED"); LIBNAME FAQ_NF 'F:\eLab\SAS_Experiments\FAQ2'; %MACRO ForWhereCl;   %IF &Approach = 'CONTINUOUS' %THEN %LET WhereClause = WHERE &WhereClauseA &WhereClauseC;   %ELSE %LET WhereClause = WHERE &WhereClauseB &WhereClauseC; %MEND; %ForWhereCl; PROC SQL;   CREATE TABLE NET_FLOWS AS SELECT   MIS_MONTH,   PRODUCT,   PRODUCT_DESC,   SUM(POS)/1000 AS TOTAL_OS,   COUNT(POS) AS COUNT_OS,   FROM &MajDB &WhereClause   GROUP BY   MIS_MONTH,   PRODUCT,   PRODUCT_DESC; QUIT; ==== However when I run it the warning Apparent symbolic reference WHERECLAUSE not resolved. is faced. Any suggestion and advice in this regard shall be highly obliged. Thanx in advance. ... View more

I can't seem to find out a way to carryout the process captioned in subject. A similar smaller piece of code I am trying to use is somewhat like the following: DATA _NULL_; %LET Entries = 6; %LET Array Yrs {&Entries} _temporary_ (2007 2008 2009 2010 2011 2012);*List Years; %LET Array Mns {&Entries} _temporary_ (3 3 3 3 3 3);*List Months; PROC SQL;*Create The Initial Table;   CREATE TABLE FAQ AS SELECT * FROM FAQ_NF.DATA_2006_03; *Data of March 2006; QUIT; %MACRO First();   %DO A=1 %TO &Entries.;*Data of only requisite months of years;     %Second(&Mns{&A.},&Yrs{&A.});   %END; %MEND First; %MACRO Second(MTH, YR);   PROC SQL;     INSERT INTO FAQ   SELECT * FROM FAQ_NF.DATA_&YR._%sysfunc(putn(&MTH,z2.));*Refer Data Tables Which Have Names Like 2007_01 ... 2012_09 and are placed in the library FAQ_NF;   Quit; %MEND Second; %First; *Start The process by calling the first macro; ODS CSV FILE = "&OUTP.CSVFILE.csv"; PROC PRINT data=FAQ_RESULTS; run; quit; ods _all_ close; Here the LOG File represents that instead of using each element separately it is using the array's value 2007 2008 2009 2010 2011 2012 in a single reference. Please see if any of you experts can help n advise in this regard. Thanx in advance. ... View more

In an SQL statement I need to have the results returning a custom date format of a field MIS_DATE as YYYY_MM in other words a date like 31JAN2013 being returned as 2013_01. A relevant change in this regard in the following statement shall be obliged: PROC SQL; CREATE TABLE RESULTS3 AS SELECT MIS_DATE AS DATA_MONTH format = YYYY_MM. FROM FAQ; QUIT; The process runs well without any observation in the Log but when I double click the Results3 dataset the same doesnot open and only then comes up the entry in Log: ERROR: Format YYYY_MM not found or couldn't be loaded for variable DATA_MONTH. Thanx in advance. ... View more