cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JDMTX
‎05-18-2020
  • 62 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Extract User ID and User Name from a Workspace Spawned via Enterpr...

by Fluorite | Level 6 in SAS Enterprise Guide
‎05-08-2013 04:48 PM
‎05-08-2013 04:48 PM
Great idea on the %mduextr macro!!!  It kills me to embedded the metapass in open code though. ... View more

Extract User ID and User Name from a Workspace Spawned via Enterprise ...

by Fluorite | Level 6 in SAS Enterprise Guide
‎05-08-2013 03:32 PM
‎05-08-2013 03:32 PM
I need to obtain the user id and if possible the user name and e-mail address of the user who is running a job in Enterprise Guide via a workspace server. At this time, I am considering using proc metaoperate or a call to the macros dictionary table.  Do I have anyother options and what is the recommended best practice? Many Thanks, JDM ... View more

Re: Using Prompt Manger To Subset Data With Date Values

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-10-2013 02:11 PM
‎01-10-2013 02:11 PM
Astounding, Your approach worked perfectly.  Thanks for the help!!! James ... View more

Re: Scheduling a Stored Process

by Fluorite | Level 6 in Developers
‎01-10-2013 10:58 AM
‎01-10-2013 10:58 AM
The issue boils down to the best approach/practice that can be used to eliminate the storage of user ids/credentials in open code by leveraging either stored processes or the metadata server for jobs that need to be run on a nightly basis.  I currently am limited to the use of the OS Job Scehduler. ... View more

Re: Using Prompt Manger To Subset Data With Date Values

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-10-2013 10:49 AM
‎01-10-2013 10:49 AM
Tom, In this particular usage case, the user of the project needs to be able to select the month that they are interested in and then using this informatin calculate back one month so that we can produce a report that segments the data by current analysis period and the prior month on a dynamic basis. Regards, James ... View more

Using Prompt Manger To Subset Data With Date Values

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-07-2013 04:57 PM
‎01-07-2013 04:57 PM
I have created a dynamic prompt in my project that allows the user to select a date (ex:  15Dec2012) and then this prompt to to subset the data via the use of a query filter.  Is there away to create a second prompt that calculates back exactly one month from the user selected value in the first prompt so that I can create a second data subset that containts only the data for the prior month (ex:  15Nov2012)? Any help is deeply appreciated. Many Thanks, James ... View more

Scheduling a Stored Process

by Fluorite | Level 6 in Developers
‎09-05-2012 03:42 PM
‎09-05-2012 03:42 PM
In a SAS 9.2 environment, is it possible to schedule a stored process to execute via the use of either the In-Process Scheduler or the Operating System Scheduler?  My end goal is to convert a batch job that runs on a nightly basis via the Operating System Scheduler into a scheduled stored process to eliminate the storage of database id's and passwords that currently exist in in open code (odbc libnames, etc).  Any ideas or suggestions? Many Thanks, James ... View more

Source Code Control in EG4.3

by Fluorite | Level 6 in SAS Enterprise Guide
‎02-16-2012 05:55 PM
‎02-16-2012 05:55 PM
Let me clarify that in my case I am using SAS EG 4.3 as my program editor for code that is saved on the server as .SAS (BASE CODE) and either run as scheduled jobs or made available to other users as stored processes.  I need a better process to protect this core code and not the actual .EGP file.  Many Thanks, James ... View more

Source Code Control in EG4.3

by Fluorite | Level 6 in SAS Enterprise Guide
‎02-16-2012 05:29 PM
‎02-16-2012 05:29 PM
Wanted to ask if EG4.3 integrates with Visual Soruce Safe as I now have the need to implement an effective source code control process for a number of key production programs.  I have not had much luck with web searches on the subject other than some brief references to the use of Subversion.  My preferred option is the use of VSS but need some reference materials on the subject of how to integrate this tool into a SAS workflow and client. Many Thanks, James ... View more

Implementation of Date Range Prompt in Query Builder

by Fluorite | Level 6 in SAS Enterprise Guide
‎03-22-2011 04:20 PM
‎03-22-2011 04:20 PM
Can someone adivse how to implement a date range prompt via a filter in the query builder interface in EG 4.3? I understand how to use prompts in open code but it is not clear how the date range prompt macro variables of _MIN and _MAX should be setup via the filter setup screen. Any help would be greatly appreciated. jdm ... View more

Filename UI

by Fluorite | Level 6 in SAS Enterprise Guide
‎03-15-2011 04:39 PM
‎03-15-2011 04:39 PM
Is there a wizard or a user interface component that encompasses the functionality found in the filename statement to enable a user to specify files on remote servers (think web server) that can then be run through the data import wizard and thus surfaced in a project? I am setting up a project for a user who is adverse to anything that even looks like code and wanted to know if such a component, task or workflow existed. Many Thanks, jdm ... View more

Re: Question Concerning SAS Add-In for MS Office 2007 and MS IRM Compa...

by Fluorite | Level 6 in Microsoft Integration with SAS
‎03-03-2011 10:27 AM
‎03-03-2011 10:27 AM
I recive the following error message when opening a Powerpoint presention that has had rights management applied to it. What struck me was that this message does not appear when working with presentations not protected by rights management and wanted to poll the forums community to see what was up as I am new to rights management. System.NullReferenceException: Object reference not set to an instance of an object. at SAS.OfficeAddin.PowerPointAddin.OnPresentationOpen(_Presentation presentation) at SAS.PowerPointAddIn.VstoPowerPointAddIn.OnPresentationOpen(Presentation Pres) ... View more

Re: Question Concerning SAS Add-In for MS Office 2007 and MS IRM Compa...

by Fluorite | Level 6 in Microsoft Integration with SAS
‎02-25-2011 06:04 PM
‎02-25-2011 06:04 PM
RMS is being used in MS Office 2007 (Excel, Outlook, PowerPoint, and Word). Noticed some strange behavior in opening PowerPoint presentation protected with RMS and messages referred to SAS Add-in. ... View more

Question Concerning SAS Add-In for MS Office 2007 and MS IRM Compatibi...

by Fluorite | Level 6 in Microsoft Integration with SAS
‎02-23-2011 05:34 PM
‎02-23-2011 05:34 PM
Does anyone know if the SAS Add-In for Microsoft Office 2007 has been certified to work in a corporate environment where Microsoft IRM has been deployed and is in use by users? Many Thanks…. ... View more

Re: SAS and Use of Date Functions with ODBC Data

by Fluorite | Level 6 in SAS Procedures
‎02-05-2011 04:58 PM
‎02-05-2011 04:58 PM
Peter - Based upon your earlier reply, is the following statement true: "Even if I apply a format like DTDATE9. it is necessary to treat the underlying value as a datetime value when applying a subseting if statment in a data step as it is not possible to use a date constant short of creating a new variable that contains only the datepart or extend a date constant into a datetime constant (example: "&date2:0:0:0"dt)." ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-18-2020 05:44 PM
Likes from
View All
Quick links