data dates; do _date = '01JAN2022'd to '31DEC2022'd; year = year(_date); month = month(_date); year2=_date; month2=_date; output; end; format _date date9. year2 year4. month2 monname3.; run; proc print data=dates; run; Here's a great, but longer and in depth, reference for dates and times in SAS https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 ... View more

In my experience, if you are doing simple, sequential DATA step reads, experimenting with DO loops is a waste of time - stick with just a SET statement as adding DO's will have minimal impact on performance. If you want to optimize your code focus on other areas, especially any really slow processes. ... View more

YES almost same result ... View more

@Suryak wrote: variable incentive amount calculation using Sas code Hello, @Suryak  I point out the obvious: If you keep repeating the same information over and over again, that doesn't help. Telling us more about "variable incentive calculation" might help.   I also now point out the obvious #2. Using an Internet search engine, you will get results in about 10 seconds. Asking here, so far it has been over 2 hours since you asked the question, and no one has any idea how to help you, and no one knows what you mean. ... View more