Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vuppalanchi

    Can we use sas functions within a macro code

    Hi Klaz, Thank you very much for you help on this one. The code worked wonders. Just a few things I changed in the code you have provided is that I have removed . from .&mon3 as it was giving syntax errors and also we need not give the libref's in the macro initialization...
  2. vuppalanchi

    Can we use sas functions within a macro code

    The following program works for a single month. data libname.outputdata; set libname.inputdata (keep=tdate); if month(tdate) in (01,02,03,04,05,06,07,08,09,10,11,12) then all_mon_trans=1; else no_trans=1; select(MONTH(tdate)); when(01) current_mon_trans=1; when(12)...
  3. vuppalanchi

    Quartile

    You can use proc summary which displays all the summary statistics by default including the quartiles but this may be too much of output to look at. To avoid this, you can use proc univariate in which you can request specific statistics like Q1 and Q3 so that you get to see only what you want.
  4. vuppalanchi

    Can we use sas functions within a macro code

    Isn't the run statement optional as the data step is followed by a proc step. Even if I add the run statement its not working as the error is showing near the MONTH() function.
  5. vuppalanchi

    Can we use sas functions within a macro code

    Hello there, I have been trying to use the sas inbuilt function MONTH to extract the month of a particular transaction date. And I need to write same set of steps for all the 12 months and therefore tried using macro. I am not sure how SAS recognizes functions within a macro. I have...

Part and Inventory Search

Back
Top