You can use the INTNX function to increment a value as you have shown using parameter arguments telling SAS how to increment. Though it's unclear what drives the number of output observations you want to generate, I would suggest a DO / END programming paragraph such as:
FORMAT MY_START_DATE MY_DERIVED_DATE MMDDYYS8. ;
MY_START_DATE = TODAY();
DO I=1 TO 6;
MY_DERIVED_DATE = INTNX('MONTH',MY_START_DATE,I);
Suggested Google advanced search argument on this topic:
sas dates intnx site:sas.com
Message was edited by: sbb
Thanks a lot for your kind information.But this coding does not work shows error that an invalid argument to INTNX .I could not able to find the site of INTNX function .Let me know the site. I shall grateful for early reply.
Message was edited by: Leena
Until you share "your version" of the code, we cannot comment on any type of error you might be getting. I typically test sample code before posting a reply. Suggest you reply with the SAS log output showing your SAS execution -- all of the code, not just a subset.