How can I create a list of current stored processes that indicates when they were last accessed and all the tables that are being used for each of the stored processes?  I'm needing; name & location of SP Date and user that last executed SP All tables used within the SP   ... View more

How can I create a list of our current SAS Stored Process that will indicate when each were last accessed and all the tables that are being used for each of the stored processes?    I can get a listing of the stored processes that list name, description, location, creation and modified date, but I need to know when last accessed. We are wanting to do some cleanup, but not sure which ones to keep and which are no longer in use.  Here's a sample of what I'm looking for...   Name Description Location Created Modified Last Accessed Tables Used SP 01 Description 1 /location of Stored Procedure MM/DD/YYYY MM/DD/YYYY MM/DD/YYYY Table 01             Table 02             Table 03               SP 02 Description 2 /location of Stored Procedure MM/DD/YYYY MM/DD/YYYY MM/DD/YYYY Table 01             Table 02             Table 04 ... View more

I am having a problem getting my data to display in EG or a Stored Process using Proc Print. I’m able to query my data, and Send To Excel – which tells me it’s the proc print. The error I’m getting is ‘ERROR: Invalid characters were present in the data.’ In some of my fields within the names would be the company’s trademarks. When I pull this information into EG, it will display in the field as a triangle with a question mark in the middle   (Field�Name – should have an ` above one of the letters). However, when I go to do a report display with a proc print or proc report I get the error.   I’m running version 7.15 (7.100.5.5850) (64-bit) – this was not an issue before we did our upgrade. Is there something different I need to do now with this version? I’ve tried adding this code to my field when I select my data from the tables, but it still does not work; Compress(fieldname,,’kw’)   ... View more

In 7.3 I want to be able to select a Yes / No option, then based on that I will lauch my various reports.  How can I accomplish this?  Do I have to bring in a data set with these options or how can I create a customized selection which would be yes/no or Month/Year or Calendar/Fiscal whatever my combo that I want/need for the various reports I want to launch. ... View more

I'm very new to SAS Va, so bear with me if this is an easy one.   I have a text field where the user can enter in a value which in turn my report filters based on that.  I want the ability to be able to enter multple values in a text box - is this possible?  My list is too large to do in any other type of control, that's why I initially chose the text input.  ... View more