Macro reports in bank

Reply
Occasional Contributor
Posts: 9

Macro reports in bank

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

 

 

PROC Star
Posts: 1,450

Re: Macro reports in bank

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.
Respected Advisor
Posts: 2,843

Re: Macro reports in bank

[ Edited ]

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
Occasional Contributor
Posts: 9

Re: Macro reports in bank

Posted in reply to PaigeMiller

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

Super User
Posts: 13,358

Re: Macro reports in bank


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.

Ask a Question
Discussion stats
  • 4 replies
  • 309 views
  • 8 likes
  • 4 in conversation