Try this (with your changes):   libname SQLREF ODBC NOPROMPT="server=SVDSQLDCP01;driver=ODBC Driver 13 for SQL Server;trusted_connection=yes;database=DEVAPP10_Shredding" STRINGDATES=NO IGNORE_READ_ONLY_COLUMNS=YES SCHEMA=DBO;    From here: GitHub - savian-net/SasTipsTricks: Tips and tricks learned over 20+ years as a SAS/Microsoft consultant   ... View more

C#, not C++.   Custom tasks live on your side of the equation. You load them via the EG menu.   Chris' examples make it easy to customize. You can copy his code and modify as needed. You have to comply with the contract (i.e. interface). Ex. Martin  object implements IHuman and IMammal and therefore has certain properties and actions.    Your call but a way to fix the issue. Just wanted you to be aware of it. You could do a follow along on a simple task and see what you think.  ... View more

Consider creating a SAS Custom Task. I haven't done this in a while so bear with me.   SAS EG is written in C#. You can make a custom task that takes parameters (custom UI) and loops the tasks. I have built these for SAS clients before who were in a similar position. There is a C# interface you have to implement and then code up whatever you want. You are limited to the Framework but that is more than enough power.   See this page and book on how to do it or refer to examples online. I have C#/SAS examples on my github site as well. There is also a program there that extracts out the SAS code from EG. However, I think a custom task works better (or is at least worth looking into). ... View more

Prelim version that does a bare minimum, for now. I left out the parsing and reporting for SAS code so you can accomplish the bare minimum (extract code):   savian-net/SaviEg: Extracts SAS EG projects into SAS code and does reporting on contents (github.com)   I will add in the other bits over time. They are coded but in a different project. Let me know how it goes.   I also made it x64. .NET 5+ runs on all major platforms so the code could run as portable but I don't have another OS (outside of Windows) installed. If a need arises to support Linux, I can recompile and someone can test it.  ... View more

Will do once ready. I started work last night on making it accessible from the command line.   I will update this thread once ready (next week, hopefully).  ... View more

I have the code to do this. Will try and get it to github as a console app.   It will use .NET 8 if you are interested.    ... View more

Agreed Jim, IML is not free.  ... View more

Since you are new to both, I suggest never using vbs. It is way out of date and will cause security issues. It is slated to be removed by MS and has been deprecated a long time ago: VBScript - Wikipedia   That said, what are you trying to do? There are other ways to handle what vbs did. ... View more

Rename the EGP to a zip extension (ex. MyProject.egp ==> MyProject.zip). Examine the files. They are XML files and one of them will contain the SAS code.   ... View more

The source code is there. You need to run it from source and see where it throws. Look at the binary file and see if you have something such as COMPRESSED in the hex codes. It is impossible for me to guess at what may be causing it since I don't have the data. Open up the file in a good hex editor (UltraEdit, NPP, or 010 Editor which is what I use) and see what is happening. The code will guide you through it. Just step the code.   SAS also changed the xpt layout and I couldn't figure out the new layout (their documentation was off in one area). I don't think you have that but you need to look at the hex and see where things are off.    I looked at the code and the error you are showing doesn't tell me where the error is located (line #) or anything meaningful. There is no way you are blowing up on the value of an int and Observations is a List. Not much I can do to help w/o info and that requires stepping the code to see where it fails.   ... View more

I haven't touched the code in years but it looks like the error is telling you that you are assigning a string to a numeric:   xportLib.DataSets[0].Observations = 'xportLib.DataSets[0].Observations'    I have used it with plenty of datasets with more than 4 columns so the # of columns is not the issue. You need to look at what is contained in the xpt file that is causing the issue. The layout for where to look is contained in that c# code. Ignore reading the actual records and look at the initial file and column metadata. Set your debug on where the Observations are being assigned and see what is being pushed to that statment xportLib.DataSets[0].Observations.      ... View more

I have not. Had to get stuff wrapped up for my client.   Sounds like you have a plan. There may be open source software that does this already so search for that. Anything that can examine zip files should recognize it as a zip in the header. A number of companies use this technique including all Office products (ex. docx, xlsx, pptx, etc.). There are a number of commercial products, for Office, that handle their zips such as GemBox. My guess is there are general programs that can handle egp such as Directory Opus.   You can script something up without too much trouble using PowerShell. Download PowerShell IDE (it may be on your machine). VS Code is also a useful editor for PowerShell. That can save you some time.    Glad it worked out for you.  Ping me if you have any questions.  ... View more

I never expected the whole file, just an example works which is what you have provided. SAS is not the best tool for this kind of work, IMO. You have C# and XPath on your machine as well since they are required for Windows to run.   Let me code up a C# program that does this, command line, and then you can modify to your heart's content in VS Code. Doing it manually is just a PITA and I can use a break from MS Office coding (VSTO).   I have parts of it already so not a big deal. ... View more

I am happy to be more specific. First off, I understand it can be difficult to get started not knowing the first step so I can help with that. A couple of questions, have you worked with C# or PowerShell? Even Python would probably be ok. But let's get a baseline on tech. Are you a programmer or an analyst? Have you worked with xpath by any chance?   To help, take one of your egp files and just change the extension to zip and look at the contents.     I can even write the code for you since I have a small amount of free time. If you have an egp file, save it where I can get it and tell me what change you want. I will code in C# but you can follow along. Once complete, I can place it in github for others.   You can do this in SAS as well. I will lay out a flow and someone else can handle the SAS code. Since I don't have access to SAS, I can't test so no need to try. ... View more

Since SAS datasets are also ODBC compliant, try pulling them vs pushing them. I am not sure whether SAS would still have an issue but a simple Python, C#, PowerShell apparatus may work. You could also just try a binary copy using robocopy (assuming Windows) and set up timeout parameters. PowerShell is also highly efficient.   At the heart of it, the sas7bdat is just a simple file. Don't try to read and export, but just copy. If you need it in a different form, consider the ODBC route. You don't indicate what your final form should be so hard to tell the needs.  ... View more