DATA Step, Macro, Functions and more

improve performance FMQuery macro

Reply
Occasional Contributor
Posts: 15

improve performance FMQuery macro

Hi everyone

I have an instalation of SAS Financial Management 5.3 with SAS 9.3.  We have to extract data loaded into SASDM MySQL database to generate versions of budget and load these versions again to FM.  To do this extraction we are using pre-built macro FMQuery

Process used by FMQuery  is rather inefficient. After set the extraction parameters extraction, fmquery query and extract all combinations of data, even with value 0.  For avoid this, I design a macro program that extract data partially.  When I execute the program, sometimes, process fmquery fails, but when I run fmquery with the combination that cause error, it works fine.

Have you ever used FMQuery to extract data from FM database?

Ask a Question
Discussion stats
  • 0 replies
  • 209 views
  • 0 likes
  • 1 in conversation