@rajuganesh30- is there anything in your dataset which can trigger extraction or Data refresh is happening for UAT Or PROD environment? If yes then we can change macro variables value dynamically o.w we need to pass macro parameters  ... View more

@Crubal Yes Strip is a char function however datatype will be char    ... View more

data new; date='19APR2018'D; Format date date9.; Date1=month(date); Date2=day(date); New=Strip(put(Date1,$5.))||"-"||Strip(put(Date2,$5.)); run; ... View more

proc sql noprint; select name into : NN1-: NN&sysmaxlong FROM DICTIONARY.COLUMNS where libname="SASHELP" and MEMNAME="ASSCMGR" and Type="num"; %let last=&sqlobs; quit; Options mprint mlogic merror; %macro Z; data want; set sashelp.ASSCMGR; %do I=1 %to &last; &&NN&i.._New=put(&&NN&i,Best32.); %end; run; %mend; %z; ... View more

this might help you   proc sql noprint; select name into : NN1-: NN&sysmaxlong FROM DICTIONARY.COLUMNS where libname="SASHELP" and MEMNAME="ASSCMGR" and Type="num"; %let last=&sqlobs; quit; Options mprint mlogic merror; %macro Z; data want; set sashelp.ASSCMGR; %do I=1 %to &last; &&NN&i.._New=put(&&NN&i,Best32.); %end; run; %mend; %z; ,   ... View more

you are almost there , you have to be very careful while writing any codes for small doubts you  should do trial and error until you get final Output but nevertheless    here you go  Data A; input ID; datalines; 1 2 3 ; Data B; input ID; datalines; 2 3 ; proc sql; create table c as select * From A where id not in (select * from B); quit; ... View more