Hi @CalebSturges,   It looks like you are really close...  I attempted using EG 5.1 (32-bit w/ HF21) and Excel 2013 (32-bit) and your code works for me with one change...   I commented out this line, since retrieving the DefaultValue property was causing an error, presumably since I didn't specify a default value for the prompt I defined: 'Retrieving parm.DefaultValue causes error because no default value was set 'on the prompt I defined 'MsgBox parm.Name & " parameter has default value of " & parm.DefaultValue MsgBox parm.Name & " parameter" In EG's View->Prompt Manager, make sure you have at least one prompt defined.  For example, I accepted the defaults, which created a text prompt named "Prompt_1".  Then, I created a program in EG with this code:     %put "&Prompt_1"; proc print data=sashelp.class; where sex eq "&Prompt_1"; run; Then, make sure you associate the prompt with the program by clicking Properties on the program, Prompts page, then add the prompt you want to use with that program.  Run the program/project in EG to make sure you get prompted and runs as expected.  If so, delete the SAS results output (so you can easily tell if the project was re-run...  results recreated), save the project and close EG.     Now when I run the VBA code, the value I specify ("M" or "F") is properly passed into the EG project and used in the code for me.   Casey ... View more

The error in the callstack points to a format issue in your options file (ex. %appdata%\SAS\EnterpriseGuide\7.1\EGOptions.xml).  Renaming the EnterpriseGuide directory (in %appdata%\SAS\) as Kurt suggested will do the trick, but if you want to be more surgical, renaming the EGOptions.xml file in that directory (a new one will get created with the default options) should also resolve the issue.   Casey ... View more

Me too! ... View more

If you are using the Map Chart task (in Tasks->Graph), the Data page is where you specify the map data source and your response data source.  The two data sets have to have a column of the same name that identifies the regions in the map.  For example, you would probably use MAPS.UK as the map data source in this case (unless you are looking for different regions).  Your response data source needs to have one record for each region (ID variable) you want to plot response data for, that corresponds to the IDs in the map data source.  The easiest way to get your response data in this format is to join it with the feature table (ex. MAPS.UK2), since it already has corresponding ID column.   Attaching a few overlayed screenshots, showing a process flow joining response data to feature table (MAPS.UK2), then using the result as the response data input along with the map (MAPS.UK) to the Map Chart task, and the end result.     Casey   ps- You can see the code generated by tasks by clicking the Preview code button in the bottom-left corner of the task dialog. ... View more

Whilst we are at it, how about a toggle button that switches the view from Table View (spreadsheet style) to Form View (one record layed out on the screen at a time), like SAS/Display Manager offers under the Viewtable facility ? Dave,   I can see how that (FSEdit-like functionality) would be useful.  Will put it on our list for future consideration.   Btw, Chris Hemedinger created an example custom task ("Observation Editor" task here), that gets close, but not quite as nice as baked right into the data grid.   Casey ... View more

I suggest contacting SAS Technical Support as well.  I still think the fact that "USER" is being used, rather than a real user id, has something to do with it (perhaps the account under which the process is running). ... View more

Thank you for your feedback.  I am sorry for the inconvenience the loss of this functionality has caused.  We knew losing the hide and hold/freeze functionality in the data grid would be painful for some folks and scenarios.  Feedback we have received has confirmed this as well.  It was not something we wanted to do, but a necessary compromise we had to take.  I can't promise when, but we are hoping to be able to add this functionality back to the data grid in a future release.   Casey ... View more

What version of Windows are you trying to do this on?   I also noticed in the log that the user properties look generic:   Property(S): LogonUser = USER Property(S): ComputerName = USER-PC   For example, your user paths contain "USER" (ex. "C:\Users\USER\") rather than a real user id.  I wonder if that is related to who the process is being run under.   Casey ... View more

You can accomplish using EG's automation interface...   -Open your EG project and note the name of the ordered list you want to run (ex. "MyOrderList") and the parent folder (ex. "Ordered Lists"). -Click File->Schedule <projectName>, then click OK in the scheduler dialog to cause an EGScript1.vbs file to be created in the same directory as your EG project.  (EGScript1.vbs is a VBScript file that will use the EG automation interface to open your project, run your project, save it, and then close it.) -Close your project. -Run the EGScript1.vbs file (ex. "cscript.exe EGScript1.vbs")  (Note: If running 32-bit EG on 64-bit Windows, you'll have to use the 32-bit cscript.exe in c:\Windows\SysWOW64...  ex. "c:\Windows\SysWOW64\cscript.exe EGScript1.vbs".) -Open your project in EG and confirm it was run by executing the VBScript file. -After confirming EGScript1.vbs successfully ran your entire project, now we just need to edit it to only run the desired Ordered List.  For example, replace the portion of the EGScript1.vbs that runs the project (commented out below) with code that finds and runs the desired ordered list (example below):   '----- ' run the project '----- 'prjObject.run 'If Checkerror("Project.run") = True Then ' Exit Sub 'End If 'Find and Run the desired ordered list Dim orderedListContainer Dim orderedList Set orderedListContainer = prjObject.ContainerCollection.Item("Ordered Lists") For Each orderedList in orderedListContainer.Items If orderedList.Name = "MyOrderList" Then orderedList.Run() End If Next If Checkerror("OrderedList.Run") = True Then Exit Sub End If -The last step (assuming you really want to be able to do this from a batch file), is to run the VBScript file from your batch file.  For example:   @echo off pushd %~dp0 cscript EGScript1.vbs ... View more

Hi Jo,   You have the latest 7.1 hotfix (HF1), so no, you do not need a hotfx.  However, there have been three releases since 7.1 (7.11, 7.12, and 7.13).  Upgrading to EG 7.13 with latest update (currently HF3) may address the issue.  Without knowing more, I can't promise the issue you describe has been fixed there, but it does sound similar to one we addressed.   Casey ... View more