About RobK777

RobK777 · ‎07-24-2013

Hi Patrick, Thanks for the reply. Your suggestion regarding two joins one not being a pass-trough appears to be working. I turned on _tree option to examine execution SQL and it appears that SAS/ACCESS is translating SAS SQL to native SQL before executing the query. It is an interesting approach, however it may limit some functionality relating to native DB2 sql, but non the less it is a viable option. Thanks again. Rob

RobK777 · ‎07-24-2013

Hi Paul, Thanks for your input yet again... We are looking only to browse metatdata related notes, extended notes, documents, etc... Appreciate your offer to send over a copy, I would like to have a look at. As for now I think we'll concentrate on a custom solution to develop complete metatdata data dictionaries. I have to a send a wish list to SAS for future releases. Kind regards, Rob

RobK777 · ‎07-22-2013

Hello, Does anyone have any experience structuring a JOIN transformation (or other SQL transformation) for DB2 WITH statement in DI? Other than user written SQL I can't find a feasible replacement. Please note that DB2 create query and global temporary tables are not allowed in our environment. Any suggestions are greatly appreciated. Regards, Rob

RobK777 · ‎07-17-2013

Hello, Using EG 5.1 I'm trying to figure out how to see detailed column metadata. Management Console and DI have the capabilities to browse/edit column properties and subsequently view notes, documents and extended attributes. Does anybody know if this capability is available in EG or if there is a plug-in which may handle such a request. Kind regards, Rob

RobK777 · ‎07-09-2013

Hi Paul, Thanks for your reply. I have been looking at your company's plug-in the past and it looks quite useful. Thanks for the info and Chris' blog, I'll have a look at it, The issue that we foresee is the need for in house expertise to develop and maintain third party code for the purpose of reporting on metadata. I've been looking at sas metatdata datastep functions and proc metatdata and it appears that we can achieve similar results using BASE, therefore it would seem like a logical solution going forward. It would be great if SAS developed more detailed reports for the next release of DI to allow more flexibility and depth. We'll add it to our wish list. Regards, Rob

RobK777 · ‎07-08-2013

Hello, I'm attempting to find a method of generating custom metadata reports in DI. I used the standard "out-of-the-box" and it is it a nice feature. However, I would like to have a drill down capability to column level where you could see properties associated with the column. The idea to it utilize metadata as an actual data dictionary. I've been doing some research regarding this functionality and I understand that you can write Java plugin to enhance current report. Wondering if SAS has custom plugins already created to provide such functionality or if there's an easier way to do it without the need to use Java. I guess proc metatdata with custom html could replicate the plug in. Regards, Rob

RobK777 · ‎07-02-2013

Thanks for the input, greatly appreciated. We found limitations even when using DI generated code. When importing back into DI, it would not produce the same results. Libraries and input tables were pre-registered. DI did not register/recognize input DB2 tables only register output SAS tables. Obviously this affected mappings and subsequently lineage capabilities. Patrick, point taken about "quality" of source code. I feel that the sample code I'm working with is clearly structured and well written. No complex macros or looping involved. Kind regards, Rob

RobK777 · ‎06-28-2013

Hello, We are evaluating DI Studio (v 4.4) capabilities. Specifically, the Import SAS Code process. Client would like to investigate the possibility of importing BASE code into DI to automatically generate a job and create metadata. We are interested in the following: Is it possible to automatically create/register source and target DB2 tables within the job Is it possible to automatically create mappings within transformations I understand that this may be a lot to ask for from the tool. Any suggestions/observations are welcomed. Regards, Rob

RobK777 · ‎01-29-2013

Thanks SASKiwi. I figured it out. Turns out it was a permissions issue on a Metadata folder. R

RobK777 · ‎01-29-2013

Hi, I'm having an issue with dynamic prompts performing look ups on tables. Libname and tables are assigned via a library and users can access the data from sas programs. Library is pre-assigned. Issue comes up with dynamic prompts on the same tables. Users can open SP. No message in EG but fields are not populated. The prompt GUI comes up with the following message in SMC Unable to find physical table I have checked relevant permissions on: - stored process - reference tables and libraries Any help is appreciated. Thx, R

RobK777 · ‎01-07-2013

Thanks Tim. The stored process method works brilliantly. Again Thank You.

RobK777 · ‎01-04-2013

Hello, I'm trying to establish if it possible to create cascading prompts in EG 5.1 based on date range values. Essentially I need user to pick a date range and a list will dynamically populate a drop down with a list of items. I have seen papers discussing dependencies between two drop downs and how to dynamically populate, however, I'm not sure if it is possible with a date range. Any suggestions or examples are greatly appreciated. Thx, Rob

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: DI - DB2 WITH Statement

Re: Detailed Column Level Metadata

DI - DB2 WITH Statement

Detailed Column Level Metadata

Re: DI - Metadata Reports

DI - Metadata Reports

Re: DI - Import SAS Code Functionality

DI - Import SAS Code Functionality

Re: Dynamic Prompts - Permissions

Dynamic Prompts - Permissions