Search results for query: *

I've got a parameter in a stored process that can have multiple selections, and code that Cynthia suggested is works for building the parameters I then use in subsequent Proc SQL processing. The code is as follows (and yes it's in a sotred process): %let campuscodescls =...

Here is what SAS tech support has to say about my two questions: There is no feature to do a 'find' within the stored process manager within EGuide at the current time. We've had requests for this so hopefully this will be added in a future release. Also, there is no way to print your code...

Oh well.... it just seems odd for such an apparently powerful software platform that things are so darn confusing/difficult! Thanks for replying....I appreciate it.

I'm using the proc export function to try exporting. "The server would need access to that location. If that can be done, then modify to code to save the excel file to the more appropriate location." .... that's the probelm.... I don't know how to code my job tin order to point it to my...

I currently have SAS running on three servers.... I can create and run a stored process that exports an Excel file. However, the Excel file is saved to my server. What I want to do is instead have my process export that file to a local computer. My reason for wanting this is I don't think...

Shows how much I don't know about SAS .... I meant, when I open a stored process and get into its code, it doesn't look like the find function or print function work. Sorry, I didn't mean the code editor window in SAS/EG. Meant from within a stored process. My background too is from the...

Will your suggestions work if you are in the SAS Code Editor Window?

Hi, Chris, Even if your suggestions don't help, I appreciate your willingness to take the time and effort to provide information and advice. SAS is frustrating me to no end..... I come from a Microsoft (Access, Excel, SQL), FOCUS and Visual Basic background, with a smattering of JCL and...

In EG, how do you search for and find something within your code? The way my EG was installed, it doesn't appear to have any kind of menu bar at the top where I might be able to activate a 'Find' function. My second question is, when you are in EG, and working in your code, how do you print...

Hi, Klaz.... If you could write out some code as an example to do that, I'd love to see it. Thanks!

Hi, Chris, One method I found is located in the SAS website, under samples. Here is its link: http://support.sas.com/ctx/samples/index.jsp?sid=848&tab=output Another method came from a white paper from SUG31, and here is its link: www2.sas.com/proceedings/sugi31/149-31.pdf Sorry I don't...

Anyone ???

Disregard this posting. I figured it out.

Has anyone out there ever tried creating mailing labels from a stored process? If so, would you share your discoveries? I think the hardest part is going to be columnizing the printed output. Thank you.

In Management Console, is there some way of finding out what a user is doing? At my company, recently, we've had our SAS Servers hang, and it would be great to diagnose what different users were doing that might cause the server hangs. Thanks in advance!

Thanks, Klaz, I'll try your suggestions. And, I appreciate your answering my question. It's nice to have folks take the time to help other less knowledgable folks!

In a macro I'm trying to write, I've got the macro working so that it makes a good WHERE clause that my Proc SQL code uses successfully. My question now is, if, in my parameter selection, I select a value of "none".... how do I translate that in my macro step so that my WHERE clause "goes...

In other languages, like Visual Basic or FOCUS, you can write code that'll allow you to jump from one part of the code to another part. Can you do the same thing in a SP? i.e., ...If WOMBAT eq 1 then goto x else if WOMBAT = 2 then goto Z, else goto Y. Can that sort of thing be done?

Guess what??? I got the problem fixed! Turns out that we receive script files from a software vendor that can at any time modify the structure of our Oracle or SQL tables; well, our Administrator had received a script that had erased two fields in the offending table, and my SAS EG was looking...

My problem is, I don't know at this point in time how to run "Base SAS" or where even to find the SAS 9.1 editor..... sorry to sound so ignorant, but I haven't been immersed in SAS long enough yet. Therein lies my frustration and why I ask such basic questions. How do I find if I even have...