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

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

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

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!

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?

I recently tried "pulling in" a table from one of my libraries and received the following message: "Enterprise Guide cannot open the data file: ODSH.PERSON_DETAIL. Do you want to remove all references to this file from the project?" I only get this message on this one table....other tables can...

Can you use parameters in a query? Posted: May 16, 2007 11:49 AM I know parameters can be used in the WHERE and GROUP portions of a query, but am wondering: Can parameters be used in the "CREATE TABLE..." part of a query, like in the following piece of code: CREATE TABLE HFA987A AS SELECT...

In a sotred process being coded in EG, is there a way, in a query, to obtain the first occurrence of a data field? Something like the following pseudocode.... Create table suchandsuch; first requestedfield fieldb fieldc first fieldd quit; run; In short, say I have 10 occurrences of a record...

I am converting a program from a language called FOCUS to an eventual EG Stored Process. The current program has a lot of parameters that must be entered before executing. My question: Can a stored process have more than one screen of parameters? If so, how would that be done? Second...

Is there a way to obtain a description of tables using code in Enterprise Guide, perhaps something in a Proc SQL? I'm looking to list the fields in a table, and haven't figured out how to do it. Any help is greatly appreciated.

In Enterprise Guide, from within a stored process, is it possible to both export to Excel and to create a report? My stored process code appears to run successfully, but all I get is a report, and no excel file in my specified folder. Here is the piece of code that I am trying to execute...

I have written a stored process that works except for one piece, where it looks like a parameter does not get accepted. Is there a way to trace through the logic of a stored process, and if there is, would someone be kind enough to let me know how? Thank you .... I appreciate the folks on this...

In Enterprise Guide, after I have created a stored process and run it, my parameter screen opens, but not in full size. There are scroll bars on the right and the bottom. My question: how do I, in my stored process, get the parameter screen to open in full size so that there are no scroll...

How might I go about taking SAS's date (from sysdate) and rearrange it into a more attractive appearance for a report header? The format I would like to obtain is as follows: 05 December 2007 If anyone can help this newbie, it would be appreciated. Thank you so much in advance...looking...

I have recently become an administrator of several server machines. However, when I remote into the servers, I don't see Enterprise Manager, I only see Administrative Functions. What I want to be able to do is to get a list of the users and groups on each server. Is there a way, outside of...

I know I'm asking a lot of questions recently, but I'm new to SAS. Anyway, is there, for Enterprise Guide, a report format that includes both a dollar sign and parentheses for negative money amounts? My boss wants the parentheses, and if he didn't, I could use the dollar format. Is it...

Is there a way in SAS to determine what reports, stored processes, queries, etc. are used, and how often they are used? And, possibly, by what users they are being used? Is there something like an activity log that migh show this info, and if there is, where is this activity log and how would...

I am designing a form in MS Word 2003. I'm trying to place two tables next to each other, and having no luck at all. I've tried copying/pasting, moving and so on, but get awful-looking results. I'd love to be able to place tables next to each other, so that the form doesn't have so darn...