Developers

A forum for collaboration, Q&A, and knowledge sharing on SAS and open source integration
BookmarkSubscribeRSS Feed
Cynthia_sas
SAS Super FREQ
A couple of student Q's from class today:

1) Can a stored process be scheduled via a client scheduler?
(The students mean SPs with %stpbegin/%stpend -- NOT DIStudio jobs -- is WRS the only way?? Could other client schedulers be made to work????)

2) In registering a stored process, a couple students mentioned that the path specification is limited to less than 85 characters. They have a path that is 85 chars and get an error saying something like "Invalid path". If they move SP to higher directory, no problem. So it looks like path is being truncated. Do you know this to be true as a bug and if so, is it planned on being fixed? It seems likely that path names can legitimately be GT 85 characters.

Thanks, in advance, for any feedback,
cynthia
2 REPLIES 2
schering
Calcite | Level 5
I hope I understood question 2 correctly.

I registered the stp with source code location as L:\My Projects\StoredProcessPgms\Misc\_123456789\_123456789\_123456789\_123456789\_123456789 (92 characters)

The stored process ran successfully in Stored Process Web, AMO and EG.
Message was edited by: schering at Jul 26, 2006 3:03 PM
Cynthia_sas
SAS Super FREQ
Thanks for that! What I found out (offline) is that the actual path limit is 256 chars, so we think that there was something else going one for #2 for our folks with the question.

I have heard from a few folks off-line on #1 and the answer is really that the stored processes are not meant to replace whatever existing batch processes you have in place to update files and/or create tables. In Web Report Studio, you CAN schedule a report to update however, and WRS report CAN contain stored processes. But the bottom line is not to think you need to replace all of your existing batch processes with stored processes.

cynthia

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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
  • 2 replies
  • 1161 views
  • 0 likes
  • 2 in conversation