This works, Thank you ! ... View more

@torvyle wrote: How does one use this code? Is it only replacing the "/folders/myfolders" with the desired directory?   Thanks You insert the root directories of the trees you want to search in in the DATALINES block of the first data step (replace /folders/myfolders, as that was the data directory used in the no longer available SAS University Edition). ... View more

SAS egp files are actually zips of XML data. Read in the egp using a zip library, replace the instances in the XML of the old path, zip, save back as egp files. Test it on a few programs.   This stuff is best done in another language. I prefer C# but use whatever you want (python, for example). For an experienced developer this is ~1 hour of work.    You could treat the XML as a string and use a regex to do the replace or use an XML engine.   So, in order:   1. Read egp files with a zip library 2. Change XML nodes where path needs replacement. OR, read in whole file as a string and replace the path using regex/string replace function 3. Save file back as an egp using a zip library   HTH, Alan   ... View more

What process are you using to create the flat-file? ... View more

don't you hate it when text is converted to emoticons? 😉 😛 ... View more

SAS is installed but the environment variable _SASHOME is not defined. Consult your IT and describe the problem, that's part of their job. You could do it by yourself, but then it's your responsability if something goes wrong. ... View more

Sure.  First, note that %superq assumes that you will pass the name of a macro variable.  So the proper syntax for your application would omit the ampersand:  %superq(macrolist) Technically %superq(&macrolist) says that &macrolist resolves into the name of the macro variable that you would like to quote ... but I've never seen an application where that is needed. It seems like you are switching logic when counting, to use both blanks and commas as delimiters.  But the loop should still end when %qscan returns a null string.  So the loop would look like this: %do %while (%qscan(%superq(macrolist), &count+1, %str(, )) ne ); The definition of %ASSIGN looks correct, once the ampersand is removed from &macrolist. See how that turns out ... might be done at that point. ... View more