10-31-2016 08:30 AM
im having issues with macros
im looking for a macros program that changes the matches the date on the criteria that i define
nov 2016 = oct 2016
Dec 2016= nov 2016
jan 2017=nov 2016
i have a month column and a year column separately
thanks in advances
10-31-2016 08:59 AM
Post example test data of a) what you have, in a datastep, b) what you want the output to look like. Most operations utilising dates you will find, are easier with actual date variables rather than the parts. For this issue, if you have a date then you can use the interval functions to move the date back one month:
Secondly, if you data actually looks like that supplied, then arrays would be used to process multiple variables, not macro.
10-31-2016 09:05 AM
Before we talk about tools, you should invest more time in clearly specifying your data as it is now and your requirements (intended result(s)).
After the issue is clear, the right tool to solve the problem will emerge.