About JDMTX

JDMTX · ‎05-08-2013

Great idea on the %mduextr macro!!! It kills me to embedded the metapass in open code though.

JDMTX · ‎05-08-2013

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

JDMTX · ‎01-10-2013

Astounding, Your approach worked perfectly. Thanks for the help!!! James

JDMTX · ‎01-10-2013

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.

JDMTX · ‎01-10-2013

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

JDMTX · ‎01-07-2013

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

JDMTX · ‎09-05-2012

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

JDMTX · ‎02-16-2012

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

JDMTX · ‎02-16-2012

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

JDMTX · ‎03-22-2011

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

JDMTX · ‎03-15-2011

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

JDMTX · ‎03-03-2011

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)

JDMTX · ‎02-25-2011

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.

JDMTX · ‎02-23-2011

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

JDMTX · ‎02-05-2011

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

Online Status	Offline
Date Last Visited	‎05-18-2020 05:44 PM

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

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

Re: Using Prompt Manger To Subset Data With Date Values

Re: Scheduling a Stored Process

Re: Using Prompt Manger To Subset Data With Date Values

Using Prompt Manger To Subset Data With Date Values

Scheduling a Stored Process

Source Code Control in EG4.3

Source Code Control in EG4.3

Implementation of Date Range Prompt in Query Builder

Re: Manually Creating Report Distribution Data Sets in WRSDIST

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

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

Re: Using Prompt Manger To Subset Data With Date Values

Re: Scheduling a Stored Process

Re: Using Prompt Manger To Subset Data With Date Values

Using Prompt Manger To Subset Data With Date Values

Scheduling a Stored Process

Source Code Control in EG4.3

Source Code Control in EG4.3

Implementation of Date Range Prompt in Query Builder

Filename UI

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

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

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

Re: SAS and Use of Date Functions with ODBC Data