I am trying to create one dataset(pos) from 2 datsets (abc , def) like below member    variable  num ----------    ----------   ------ abc           avar1        1 abc           avar2        2 def            dvar1        1 def            dvar2        2 . . .   using ods statement ods output position=pos (keep=member variable num where=(num<=2)); proc contents data=abc varnum; run; ods output close; ods output position=pos (keep=member variable num where=(num<=2)); proc contents data=def varnum; run; ods output close;   My problem is when I run the second ods output staement for 'def' , it overwrites the 'pos' dataset that was created for 'abc' dataset. i want to concatenate the outputs of 2 ods statements vertically into one dataset. ... View more

I am getting a note in the log "NOTE: In a call to the FEXIST routine, the fileref '~/practice_exer/Mth_Rep' exceeds 8 characters, and will be truncated." when I run the below macro   %cr_root_sub_dir(maindir='~/practice_exer/Mth_Rep',subdir='APR2016');   The macro code is :   %macro cr_root_sub_dir(maindir,subdir);  %put _local_;  %if &maindir = %then    %do;      %put 'Root directory is blank';      %goto exit;    %end;  %else    %do;       %if %sysfunc(fexist(&maindir)) %then          %put 'Directory &maindir Already Exists';       %else          %do;             %let newdir = %sysfunc(dcreate(&maindir,'~'));             %let newsubdir = %sysfunc(dcreate(&subdir,&maindir));         %end;     %end; %exit:; %mend cr_root_sub_dir;       ... View more