You have fixed a typo, which is good, but that was not what I meant. Now challenge yourself, why your code does not give you any output? if you check 'num', it has the value of 19. ... View more

Yes, you CAN use h.num_items. Fix your buggy code first before you can see it. ... View more

Your description need be elaborated more. There are more than one macro variables in your code, please comment your code in detail, so that people can know where/what/how, then we start from there. ... View more

Check SYMGET() or RESOLVE(). ... View more

@econ wrote: no, in the example i posted in the second data step, the table test.sas7bdat is intact in work. the table test.sas7bdat.lck is created to it's ultimate size. then the data step hangs for about a minute when renaming test.sas7bdat.lck to test.sas7bdat.   and as an example if i was to stop the data step before it finished test.sas7bdat.lck would be deleted and the original test.sas7bdat would remain.   What you are saying does NOT contradicts the comments from @ballardw. It is not the best practice to use the same table names for both input and output in the same data step, however, when you choose to do so, SAS will lock(.lck, readonly?) the original, just in case your process is adrupted unexpectedly. When your buidling process is complete, SAS will take some time to verify it (SAS skip this step when building a different name table), if SAS feels comfortable after verifying, that is when .lck is deleted, and whole process is finally over. In the case your process is NOT a success, the target table failed completely or partially, SAS will delete the failed, and rename .lck back to original.  ... View more

This will generally to be a Macro job: branching SAS code based conditions. Something along the line of the following code may get you going: %macro Apr; /*April 2015*/ if xyz_Date >= '01april2015:00:00:00'dt then do; net_growth = sum(bal_04_2015,-bal_03_2015); end; else do; net_growth = sum(bal_04_2015,-bal_03_2015); end; %mend; %macro May; /*May 2015*/ if xyz_Date >= '01may2015:00:00:00'dt then do; net_growth = sum(bal_05_2015,-bal_04_2015); end; else if xyz_Date >= '01apr2015:00:00:00'dt then do; net_growth = sum(bal_05_2015,-bal_03_2015); end; else do; net_growth = sum(bal_05_2015,-bal_03_2015); end; %mend; %macro Jun; if xyz_Date >= '01jun2015:00:00:00'dt then do; net_growth = sum(bal_06_2015,-bal_05_2015); end; else if xyz_Date >= '01may2015:00:00:00'dt then do; net_growth = sum(bal_06_2015,-bal_04_2015); end; else if xyz_Date >= '01apr2015:00:00:00'dt then do; net_growth = sum(bal_06_2015,-bal_03_2015); end; else do; net_growth = sum(bal_06_2015,-bal_03_2015); end; %mend; %let month=%sysfunc(today(),monname3.); %macro test; %&month %mend; data steps; blah...; %test run; Please note, main Macro 'test' is just to give you some flexibilities if you want to do more than just calling another nested macro. In your case, you can simply call the monthly Macros directly.  ... View more

I see you have already posted here two weeks ago, with less details, I must have overlooked, my bad. So condsider the following: proc sort data=sashelp.class(drop=height) out=no_height; by name; run; proc sort data=sashelp.class(drop=weight) out=no_weight; by name; run; proc sort data=sashelp.class(drop=age) out=no_age; by name; run; data final; set no: indsname=dsname; by name; source=dsname; if _n_>6 then stop; run; data _null_; set final end=last; by name; if first.name then call execute('ods pdf file='||'"h:\temp\name_'||strip(name)||'.pdf";' ); call execute('ods pdf startpage=now; proc print data=final(firstobs='||_n_||' obs='||_n_||'); run;' ); if last then call execute('ods pdf close;'); run; Please note, since your request evolved, so I opted to choose a different merge strategy, rather, it is more like a sorted 'stacking', in order to show the 'source' of your obs.   ... View more