Hi Can someone share common macro use for generating reports monthly in banking.
No one who works at any bank (except the bank you work for) is going to share his code with you, because it belongs to the bank! You just don't give proprietary code to competitors. Maybe you should ask people at your bank.
Furthermore, since every bank has different databases, even I would share my code with you, it would be totally meaningless as you have different databases.
Now, if you were to try and write a macro yourself and got stuck and couldn't figure out what to do, I'm sure that lots of people here in the SAS communities would be happy to help you.
I have interview tomarrow and they will test my macro skills. The role requirements are:
generating month, weekly, quaterly report, to monitor key risk factor.
the requirement is creating touch less capibilities.
I do know macro but didt use it much. USed SAS 2 years back and I do know we have one code already written and just copy paste. Now I dont have that code so asking what are the common scenario or most commonly used systax
@bumchum wrote:
I have interview tomarrow and they will test my macro skills. The role requirements are:
generating month, weekly, quaterly report, to monitor key risk factor.
the requirement is creating touch less capibilities.
I do know macro but didt use it much. USed SAS 2 years back and I do know we have one code already written and just copy paste. Now I dont have that code so asking what are the common scenario or most commonly used systax
You probably should brush up on date manipulation and date formats as that requirement is going to involve a fair amount of date related activities.
And "touchless" could well mean something like "use todays date to create a report based on data from the previous Sunday to Saturday period" or similar for calendar month or quarter, or fiscal year. Depending on the report requirement might well be doable with a single or two parameters based on the date the program runs and could well be done with no "macro code" but call execute.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.