About sravanece11

sravanece11 · ‎06-25-2019

Thanks a lot,it's working.

sravanece11 · ‎06-25-2019

one dataset with the data of all dates i currently pass as a parameter

sravanece11 · ‎06-25-2019

so what changes should i make in the code such that i should be able to retrive data for all the macros invoked in do loop.( i mean for all the dates provided in do loop)

sravanece11 · ‎06-25-2019

hi i have given sample data,macro code in the attachement,kindly have a look.

sravanece11 · ‎06-25-2019

Hi After running the code that you suggested,iam getting output of only the last date ie 27jun2019. I need output for all the dates provided in the do loop

sravanece11 · ‎06-25-2019

Iam in process of automating SAS code,I have a macro whose input argument is date. For example: %monthly("20jun2019"d) %monthly("21jun2019"d) . . . %monthly("29jun2019"d) I need to automate the above code.i have tried using do loop but it didn't worked.here is the code that I have tried. Data d; Do i="20jun2019"d to "29jun2019"d; Output Call execute ("%monthly",i); End; Run; Kindly let me know how to invoke macro inside do loop or is there any other process to automate the above process.

sravanece11 · ‎06-24-2019

I have a macro for which input arguments are dates. For example: %smart("20jun2019"d) %smart("21jun2019"d) . . . %smart("29jun2019"d) I need to automate the above code,such that if I have start date and end date ,all the respective dates between this start and end dates should be included ,and it should happen in the above mentioned code and it should happen automatically. Kindly help me in the automation of above mentioned code. I tried using below code using do loop but it didn't worked Data s; Do i ="21jun2019"d to "29jun2019"d; Output; Call execute("%smart(i)"); End; Run;

sravanece11 · ‎08-18-2018

Hi, It worked.. but could you please explain why are we using ">." here and what is the use of it? @sas_ wrote: data l2; input ID prescribeddate$ 3-14 drug$ quantity; cards; 1 08/jan/2008 A 28 1 08/feb/2008 A 14 1 08/Mar/2008 A . 1 08/Apr/2008 B 56 1 08/May/2008 B . 2 08/Jan/2008 A 30 2 08/Mar/2009 B . 2 28/Mar/2008 A 30 2 08/Mar/2008 B 14 3 08/Jan/2008 B . 3 08/Mar/2009 B 56 3 08/Mar/2008 A . 4 08/jan/2008 A . 4 08/feb/2008 A . 4 08/Mar/2008 A 14 4 08/Apr/2008 B . 4 08/May/2008 B . ; run; data l3; set l2; retain tot; if quantity>. then tot=quantity; run;

Online Status	Offline
Date Last Visited	‎11-14-2019 04:21 AM

Re: How to invoke a macro inside a do loop

Re: How to invoke a macro inside a do loop

Re: How to invoke a macro inside a do loop

Re: How to invoke a macro inside a do loop

Re: How to invoke a macro inside a do loop

How to invoke a macro inside a do loop

How to run macro inside a do loop

Re: Replacing missing values by previous observation

Re: How to invoke a macro inside a do loop

Re: How to invoke a macro inside a do loop

Re: How to invoke a macro inside a do loop

Re: How to invoke a macro inside a do loop

Re: How to invoke a macro inside a do loop

How to invoke a macro inside a do loop

How to run macro inside a do loop

Re: Replacing missing values by previous observation