BookmarkSubscribeRSS Feed
bumchum
Calcite | Level 5

Hi Can someone share common macro use for generating reports monthly in banking.

 

 

4 REPLIES 4
Quentin
Super User
I think this question is too general. The macro language is used to generate SAS code. If you have code that generates a monthly report, and every month you need to change parts of it to reflect the current month, that might be a candidate for using the macro language to generate dynamic code.
PaigeMiller
Diamond | Level 26

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.

--
Paige Miller
bumchum
Calcite | Level 5

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

ballardw
Super User

@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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1603 views
  • 8 likes
  • 4 in conversation