Desktop productivity for business analysts and programmers

Searching through multiple years that are the same

Occasional Contributor
Posts: 8

Searching through multiple years that are the same

I guess I have to create a macro or something, but I want to build a stored procedure or model so that the user can search through up to 10 years worth of purchase card data for a merchant name. Can someone help me get started on how to do this? I also have to pull the card holder name from another list of tables...
Posts: 8,716

Re: Searching through multiple years that are the same

I'm not sure what you mean by a "stored procedure or model". In SAS Enterprise Guide, if you design a project, with a Query to extract data, you could use the Parameter Manager to prompt users for the year or the merchant or both.

SAS does not have "stored procedures" such as RDBMS systems have. However, SAS does have "stored processes" which work within the context of the SAS Platform for Business Analytics to allow multiple Platform clients (including EG) to run stored processes (which are SAS programs that are registered in the metadata and can also have parameters or prompts to control the program output.)

Many SAS Statistical procedures use a MODEL statement -- I am not sure what you mean by "model" in your question.

Perhaps if you could explain a bit more about how you are using EG and SAS (local EG and local SAS; local EG and SAS on a Server; EG as part of the BI Platform -- with the BI Server or Enterprise BI Server configuration) and where your data is coming from ("flat" file; regular SAS dataset; other external file; SAS dataset defined in the BI Platform Metadata; other SAS datasource (such as an Oracle table, Sybase table, etc), it would be possible for someone to get you pointed in the right direction.

Super Contributor
Super Contributor
Posts: 365

Re: Searching through multiple years that are the same

Hello Marilyn934,

I you could also supply an example of input data and desired output then the advice will be more specific.

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation