I have created a simple macro. You can use it.   %macro tablesize(tablename=); proc sql noprint; select count(*) into :cnt from &tablename.; quit; %if &cnt. ne 0 %then %do; %let &tablename.=&tablename.; %end; %else %do; %let &tablename.=; %end; %mend tablesize; %tablesize(tablename=A); %tablesize(tablename=B); %tablesize(tablename=C); data d; merge &A. &B. &C.; by common_var; run; /*Which of the table is empty its corresponding macro will be initialized to null so they wont be merged in the data step as the macro resoves to null Remember to call macronames insted of tablenames. Remember Not to have any macro variable same name as tablenames*/ Please let us know if it worked for you. ... View more

I believe the problem is with only this part of the code.     /*Joining INVMAST & CADV*/ Proc Sql; Create Table INCADV.INCADV_01 as Select a.*,COALESCE(SUM(b.COUPON_POS_C),0) as COUPON_POS_C,COALESCE(SUM(b.COUPON_WEB_C),0) AS COUPON_WEB_C FROM INVMAST.INVMAST_01 AS a LEFT JOIN CADV.CADV_01 as b On a.INV_DATE = b.INV_DATE Group by a.INV_DATE, a.LOCA_CODE, a.LOCA_NAME, a.ZONE,a.BV_LM,a.IN_CH; Quit;   So the issue is column both present in table INVMAST.INVMAST_01 and CADV.CADV_01, so when you are joining you must be getting an warning message over it. SAS is taking the variable from INVMAST.INVMAST_01 insted of CADV.CADV_01 and hence you are getting error results.   To eradicate the issue select all the columns from table INVMAST.INVMAST_01 with name except the variable COUPON_WEB_C instead of * or rename as following COALESCE(SUM(b.COUPON_WEB_C),0) AS COUPON_WEB_C1   Let us know if it worked for you. ... View more

data test1; input id age ; datalines; 1 25 2 26 3 27 ; data test2; input id age ; datalines; 2 100 ; proc sql; create table test3 as select a.id,ifn(b.age ne ., b.age, a.age) as age from test1 a left join test2 b on a.id=b.id; quit; ... View more

data t; infile datalines dlm="," dsd missover; input i; datalines; 2 3 4 5 ; run; data t1; set t; i1 = i + 1; if i < i1 then put result = 1; else result = 0; run; /*This will work now. You do not need a loop to get increament, SAS Datastep it self is a loop, Advisable to use it always*/ ... View more

If the crash_date are in numeric form just displayed as 11/5/2017 in the dataset then you can try a datastep like following data output; set input; where crash_date in ('05Nov2017'd, '31Dec2017'd, '04Jan2018'd); run; But if the crash_date is characters then the following will work. data output; set input; where input(crash_date,mmddyy10.) in ('05Nov2017'd, '31Dec2017'd, '04Jan2018'd); run; ... View more

proc sql; create table test1 as select t.*, (case when (select count(*) from test where VarB =t.VarA) =0 then 'N' else 'Y' end) as new_var from test t; quit; This will work. It will work like a charm until the size of the DS in small or medium or you have an index on VarB. ... View more

data finale_sheet; merge y1(in=a rename=(Level=Level1)) y2(in=b rename=(Level=Level2)) y3(in=c rename=(Level=Level3)); by id; if Level1=Level2=Level3 then same=1; else same=0; if (input(substr(Level1,2,1),1.)<input(substr(Level2,2,1),1.)) or (input(substr(Level2,2,1),1.) < input(substr(Level1,2,1),1.)) then UP=1; else up=0; if Level2='' then delete=1; else delete=0; if (substr(Level1,4) ne substr(Level2,4)) or (substr(Level2,4) ne substr(Level3,4)) then change=1; else change=0; run; ... View more

data finale(drop= i j k count); set have; length want_dna $200; *This needs to be set to a maximum lenghth; do i=1 to n; count=0; key=substr(DNA,i,1); do j=i to n; if i=j and i ne 1 then do; do k=1 to k=i-1; if key=substr(DNA,k,1) then goto skip; end; end; if key=substr(DNA,j,1) then count=+1; end; if i=1 then do; if count gt 1 then WANT_DNA=key||'-'||put(count,best12.); else WANT_DNA=key; end; else do; if count gt 1 then WANT_DNA=WANT_DNA||'-'||key||'-'||put(count,best12.); else WANT_DNA=WANT_DNA||'-'||key; end; skip: end; run; I have not tested this code, to be updated. ... View more

Corrections to your macro: Hope it helps.     %Macro running_over_all_data(var_name = , value=); data _TEMP; set original_file; keep date tradetim ; IF &var_name=&value; run; *Not Touching your Data step; *if too small number of record --> no running code; Proc Sql noprint; select count(*) into :NOBS from _TEMPl; Quit; *Taking count of the whole table; %IF &NOBS > 5 %THEN %DO; %include "C:\Users\Main analysis code.sas" /lrecl=50000; %END; %Mend; ... View more