Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dbdinc
  • Order by date
  1. dbdinc

    How to build a sting for Proc SQL

    ...my question: how can I modify that type of code to instead of picking an entire piece of data in a field, to perform LIKE checking ("If FIELDA LIKE *widget* OR FIELDA LIKE *wadget* or FIELDA LIKE *whatsis* " ?) I can't change my parameter criteria to do this, because the same parameter...
  2. dbdinc

    Two (2) questions about Enterprise Guide

    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...
  3. dbdinc

    Two (2) questions about Enterprise Guide

    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.
  4. dbdinc

    Export Excel file from SAS Server to local PC

    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...
  5. dbdinc

    Export Excel file from SAS Server to local PC

    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...
  6. dbdinc

    Two (2) questions about Enterprise Guide

    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...
  7. dbdinc

    Two (2) questions about Enterprise Guide

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

    Two (2) questions about Enterprise Guide

    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...
  9. dbdinc

    Two (2) questions about Enterprise Guide

    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...
  10. dbdinc

    How to create mailing labels

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

    How to create mailing labels

    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...
  12. dbdinc

    How to tell what a user is doing

    Anyone ???
  13. dbdinc

    How to create mailing labels

    Disregard this posting. I figured it out.
  14. dbdinc

    How to create mailing labels

    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.
  15. dbdinc

    How to tell what a user is doing

    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!
  16. dbdinc

    Set up a parameter value to be blank

    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!
  17. dbdinc

    Set up a parameter value to be blank

    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...
  18. dbdinc

    Can you jump around in a stored process?

    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?
  19. dbdinc

    "...cannot open the the data file..."

    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...
  20. dbdinc

    "...cannot open the the data file..."

    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...

Part and Inventory Search

Back
Top