BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

I have created a Stored Process with a simple SQL query using PROC SQL function and saved it in a local folder. I opened SAS Management console and defined the Stored Process in the Maps folder which comes under BI Manager. While defining the Stored Process in the Maps folder I have specified the following,

• SAS Server: Stored Process Server,
• SAS Code Repository: <<Path of the Stored Process Local folder>>,
• Source File: <<Stored Process file name>>.

I don’t get the Stored Process file in the SAS Information Map even after defining the server.

Please, Guide me to solve this issue.

Regards,
Sujeev null
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
You might want to work with Tech Support on this one. It will be easier for them to look at your code and screen shots to help you debug this. Click on the link "Contact Us" at the bottom of this page.

cynthia
deleted_user
Not applicable
Hi Cynthia,

Thanks for your guidance. I'll go as per your suggestion.

Regards,
Sujeev
Cynthia_sas
SAS Super FREQ
Hi:
Great! And, just a reminder -- if you plan for your stored process to provide the data for an information map, you must:
1) build the information map
2) write, test and define the stored process
3) LINK the stored process to the information map from inside Information Map Studio.

You will need to explicitly perform the linking steps -- the link does not happen automatically between the information map and the stored process and the information map is not built automatically just because you have defined the stored process.
The folks in Tech Support can help you complete or correct the link step if you have not done this.

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 712 views
  • 0 likes
  • 2 in conversation