About prholland

prholland · ‎09-18-2012

I'm trying to bind a SAS Library to a DataGridView object in an EG Custom Task (VB.NET Express 2010 + EG 5.1). I'm currently using the following code: Public Overrides Function Show(ByVal Owner As _ System.Windows.Forms.IWin32Window) As _ SAS.Shared.AddIns.ShowResult Dim server As String = String.Format("{0}", Consumer.ActiveData.Server) Dim libref As String = String.Format("{0}", Consumer.ActiveData.Library) Dim member As String = String.Format("{0}", Consumer.ActiveData.Member) Dim dlg As WhereViewerForm = New WhereViewerForm(settings) ' set Active Data dlg.TextServer.Text = server dlg.TextLibref.Text = libref dlg.TextMember.Text = member dlg.DataGridView.DataSource = New SasLibrary(server, libref) dlg.DataGridView.DataMember = member ' show form If (DialogResult.OK = dlg.ShowDialog(Owner)) Then ' save the settings from the form settings = dlg.Settings Return ShowResult.RunNow Else : Return ShowResult.Canceled End If End Function I get the following error message: Exception Details: ---------------------------------------- Exception type: System.ArgumentException Message: Child list for field CARS cannot be created. Source: System.Windows.Forms Target Site: EnsureListManager Stack Trace: at System.Windows.Forms.BindingContext.EnsureListManager(Object dataSource, String dataMember) at System.Windows.Forms.DataGridView.DataGridViewDataConnection.SetDataConnection(Object dataSource, String dataMember) at System.Windows.Forms.DataGridView.set_DataMember(String value) at WhereViewer.WhereViewer.Show(IWin32Window Owner) at SAS.Tasks.Toolkit.SasTask.ShowDialog(IWin32Window Owner, ViewType PreferredView) at SAS.Shared.AddIns.Management.AddInProxy.ShowDialog(IWin32Window Owner, ViewType PreferredView) at SAS.EG.ProjectElements.EGTask.Show(IWin32Window Owner) at SAS.EG.MainForm.AddTask(Guid taskGuid, Element inputData, Boolean bIsWizard, String xml, String templateName, String templateNameFullPath) at SAS.EG.MainForm.LaunchTask(Element target, Guid taskGuid, Boolean bIsWizard, String xml, String templateName, String templateNameFullPath) at SAS.EG.MainForm.OnTaskClick(Object sender, EventArgs e) at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ToolStrip.WndProc(Message& m) at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) I know I'm using the wrong method for allocating the library.member to the DataGridView, but what should I use instead? .....................Phil

prholland · ‎11-02-2011

After playing around with the options in EG I have resolved this problem myself! The root of the problem was the default ODS destination of HTML, which is incompatible with CGM files, so switching this off in EG Tools > Options > Result General, and opening the LISTING destination allowed CGM files to be created. This is OK until you actually need to generate HTML files, when you have to go back into Results General to switch HTML back on. Therefore the solution has be added to the specific program: ODS _ALL_ CLOSE; ODS LISTING; * ........... CGM-generating SAS code ..............*; ODS LISTING CLOSE; Provided the HTML destination is not in use, CGM files are generated in the same way they are in SAS batch outside EG. Sorted!!...........Phil

prholland · ‎10-26-2011

I have to run some existing program that create CGM files in EG 4.3, and the GOPTIONS settings are being overridden. I think it is EG trying to help, as CGM is not valid in the ODS HTML destination, but it still produces a CGM, although all the specified hardware fonts have been replaced. Can anyone suggest a way of running the CGM-producing program in EG without major surgery? Thanks in advance..........Phil

prholland · ‎08-25-2010

> This thread was not to be about EG vs DMS, it was > meant to be about a replacement to the DMS aimed at > developers, with the appropriate IDE features, which > EG is not. Chris, Say SAS do create a brand new SAS IDE (SIDE), won't we then have a 3-sided argument: DMS ("I've got all my favourite DMS keyboard shortcuts that I don't want to lose") vs EG ("It may not be perfect, but I can work on remote servers from home") vs SIDE ("This is a really new IDE and different to anything we've used before")? This thread could continue for decades!!...................Phil

prholland · ‎08-24-2010

> .NET is windows only. Maybe good enough to build EG > extensions, but not to replace SAS/AF processes. One > of many good things about sas (including sas/af) is > the Multi Vendor Architecture that allows the same > program to run on a PC, a mini or a mainframe. .Net is Windows only, but there is Mono project on Linux etc that will run a lot of .Net functionality, so theoretically EG could be developed to run on other platforms. However, I would suggest you read my paper, which explains why it is Windows-centric, "Could Enterprise Guide have been written in Java?" at: http://www.hollandnumerics.com/SASPAPER.HTM > Except for simple processes, point-and-click can only > do so much, and can only do it so well. You are > deluding yourself if you think otherwise. Why, as a "real" SAS programmer, are you trying to use the point-and-click features? The editor up to EG 4.2 is the Enhanced Editor in the Windows SAS DMS, and has been enhanced further in EG 4.3. I use EG to work from home on UNIX servers in the UK (close to home) and the US with minimal speed differences and a familiar environment. I've been using SAS software since version 79.5, remember the introduction of SAS/AF in version 5, and I prefer the consistent interface in EG to the wild inconsistencies of the Windows and UNIX DMS. I support SAS's desire to make access to the programming features for the majority of users easier to learn and use. The key question should be: Is SAS supporting EG and dropping DMS? The answer is No! ...........Phil

prholland · ‎05-12-2010

I've just had to replace my Vista laptop with 64-bit Windows 7. I've re-installed SAS 9.2 and that works fine, but EG 4.2 gives the following error message when started: "SAS Enterprise Guide has encountered a problem. We recommend that you save your work and restart SAS Enterprise Guide." "System.IO.FileNotFoundExceptionCould not load file or assembly 'Microsoft.web.Services3, Version=3.0.0.0, Culture=neutral, PublicKey Token=31bf3856ad364e35' or one of its dependencies. The system file could not be found." Can EG 4.2 be installed on 64-bit Windows 7?........Phil

prholland · ‎04-21-2010

Scott, %SGDESIGN starts an external Java interactive application that interfaces to interactive SAS, and so is never likely to be available for EG users, as they have no direct interface to the server where SAS is running. On the other hand it would be technically feasible to create an EG Custom Task which has similar functionality to %SGDESIGN using .NET. Would that work for you?.............Phil

prholland · ‎02-26-2010

sree, When EG complained that the project file was corrupted on opening, I tried to open it with WinZip, and when that failed I eventually opened it with UltraEdit. However, any text editor that can display hex character would work just as well. Currently I'm saving EG project files locally, then syncing them at the end of each day to the network share with FreeFileSync, which tells me when it is not successful. .......Phil

prholland · ‎02-25-2010

If you submit zip files to Blackboard 8, can they be downloaded then opened with WinZip? It may be a generic issue with zip files. .........Phil

prholland · ‎02-22-2010

You can get 99.8% percentiles from the Tables > "Basic confidence intervals" in Distribution Analysis (PROC UNIVARIATE). You can then "Save output statistics to a data set". .........Phil

prholland · ‎02-22-2010

You should be able to save the results data from Summary Stats in a SAS data set, which you'll be able to use elsewhere. ........Phil

prholland · ‎02-22-2010

I've not been able to get PCTL() to work in PROC SQL. It seems to require multiple arguments to work correctly. 😞 .....Phil

prholland · ‎02-22-2010

This is a check to see if anyone has ever corrupted a EG 4.1 project file when a network share you are writing to is lost? I'm running EG 4.1 on Vista Business and writing the project file to a Solaris 9 remote server, which has Windows-compatible network shares. The corrupted project files appear to be created filled with '00'x, then overwritten from the top with the project data, which is not completed, but error messages are not necessarily issued. I'm now having to save my EG projects locally, then sync them with the network versions at the end of each day. Is this an EG or Vista problem? .......Phil

prholland · ‎01-28-2010

Lori, I think you've found out that the INTCK function only returns integer values. This is because it counts period boundaries, and not durations. For example: INTCK('MONTH', '30Mar2009'd, '05May2009'd) = INTCK('MONTH', '05Mar2009'd, '30May2009'd) = 2 because it has counted 2 month boundaries on 01Apr2009 and 01May2009 in each case. In the same way the INTNX function increments dates to the corresponding boundary date. For example: INTNX('MONTH', '05Mar2009'd, 2) = INTNX('MONTH', '30Mar2009'd, 2) = '01May2009'd Hope this clears up any confusion..........Phil

prholland · ‎07-10-2009

My initial development is based on an network of EG-local code nodes, which are self-sufficient, so I could run them individually, if necessary. However, the network forces me to run them in a sensible order. I normally limit the number of programs on each Process Flow to less than a dozen, and keep the output names unique, otherwise the flow becomes unmanageable. Working in a pharms environment generally means that I have to save these programs to a server at some point, so the EG environment, with its program links, is then used to help me run them in their dependency order, but also include document links to help me find things again in the future. Full details of this can be found in my SAS book, "Power User's Guide to SAS Programming", at www.hollandnumerics.com, and my paper "Running Clinical Trials Programs with Enterprise Guide", at www.hollandnumerics.com/SASPAPER.HTM. ...........Phil

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

Re: How does EG tell which DLL file to load for an add-in?

Re: How does EG tell which DLL file to load for an add-in?

How does EG tell which DLL file to load for an add-in?

Re: Passing text to the settings property from Main and Form classes i...

Passing text to the settings property from Main and Form classes in EG...

Re: Is there a quick way to get the site number of the active server?

Re: Trying to bind SAS Library to DataGridView in Custom Task

Re: Is there a quick way to get the site number of the active server?

Is there a quick way to get the site number of the active server?

Re: Trying to bind SAS Library to DataGridView in Custom Task

Re: Is there a quick way to get the site number of the active server?

Re: Missing Dates appear as Dot. How can i replace them to blank

Trying to bind SAS Library to DataGridView in Custom Task

Trying to bind SAS Library to DataGridView in Custom Task

CGM and Enterprise Guide

CGM and Enterprise Guide

Re: Poll: EG for programmers or not?

Re: Poll: EG for programmers or not?

Can EG 4.2 be installed on 64-bit Windows 7?

Re: EG and SG Procedure Integration

Re: Corrupting EG 4.1 project files when network share is lost

Re: EGuide Projects and BlackBoard

Re: Using Query builder to create percentile stats

Re: Using Query builder to create percentile stats

Re: Using Query builder to create percentile stats

Corrupting EG 4.1 project files when network share is lost

Re: Intck function (is it possible to not round number and display dec...

Re: Survey - what's your EG style?