I am on a cellphone and dont have SAS. The way this is done crosses pgm languages. Use the modulus of 5. For SAS, that is the mod function. Mod(counter, 5) = 0. ... View more

I just uploaded an app (for the extraction of the programs) to github that extracts programs from EG projects. Look at: GitHub - savian-net/SaviApp: A utility to help understand SAS logs, data, and programs   It will extract them out to a work library defined in the json config file (you can also use the UI).   ... View more

There is no good way to move back and forth from tables to JSON. Whenever you work with hierarchical data (JSON, XML, YAML, HTML. etc.) moving to tables is a bit of interpretation. The engine needs to understand intent which is hard.    When working with these structures you can try and work within the SAS libname JSON engine. If you only have a few changes, and the structure remains intact, consider just treating it as a text file and doing a regex replace. If not, roll your own using data step and filenames. Much easier to control the layout. My view is not to allow SAS to intelligently guess what you want: just roll your own.   Try the JSON libname first, however, and see if it does what you want.   BTW, we face the same issue in .NET which is the 'intent' when switching between tables and object-oriented structures like JSON.   ... View more

The limitation is with Excel. You may be running out of memory on your machine. What version of Excel do you have? Excel can handle 1M rows but that is capped by your physical memory on your PC. I am pretty sure it can 'virtually' hold more than that if it is in a DB table somewhere but it gets complex to set up. ... View more

Whoa, Tom's question was fine. Not sure what you are referring to. A CSV or TXT file are 100% unrelated to Excel. If you have Excel tied to open CSV and TXT files, that is a Windows issue, not SAS. I don't understand the question and 100% do not 'spam' people. If you want to see a CSV file that is super large, use something like UltraEdit or Notepad++. Not sure why you want to open a file that large. Excel handles a million rows.  ... View more

No, what it will do is what is known as 'codegen'. Generate the SAS code, see if it matches what you expect, then %include it once you know it generated it properly. This is kind of how the macro engine operates but by pushing the code to a text file, you can see what it is doing. Keep refining it until it looks like it will execute as expected, then %include it in.    It mainly gives you a simple way to debug plain SAS code w/o worrying about macro stuff. Use standard do loop concepts. See my Tips and Tricks on my github site for an example:   savian-net/SasTipsTricks: Tips and tricks learned over 20+ years as a SAS/Microsoft consultant (github.com)   Look at PUTs vs Macros. You may not want to do it this way. I have found that it is far easier to debug than macros.    ... View more

I don't have SAS or I could write up some code for you. Let me tell you how I would approach it so it is easier to debug, IMO. Since I don't have SAS, I am winging it but it should provide an idea. Personally, I hate macros due to their obscurity. Just run a data step and %include back in. Easy to see if your code is valid.    data _null_;      file "c:\temp\MyDataRead.sas" ;      input sourceData;      input month               year               ;      if _n_ = 1 then put "libname myLibs";     put "myLibs" month +(-1)"." year; run;   %include "c:\temp\MyDataRead.sas"; ... View more

You aren't worried about the number of datasets but the number of directories. A libname only has paths, not the individual files. ... View more

Libnames can have multiple entries: LIBNAME TEST ("path1","path2"); ... View more

As others have mentioned, SAS is enormous. How big (I made this awhile back and it is generalized)? :   ~600  Functions ~300  FORMATs ~100  INFORMATS ~600  System options ~400  PROCs I would use The Little SAS Book and learn from that. SAS is very, very approachable. Understand the data step and simple exercises and the rest can be had over time. SAS is way too big to create simple cheat sheets although someone may have. Data step and a handful of procs are very useful.   One other thing, some procs have an entire book written about them. Stay focused on a few simple ones and move into others if needed.   ... View more

You stated that EG 8.3 is installed. You need to find out where. Look through any guides online to find the exe for EG. Here is an example: 4 Ways to Find a Program's Install Location on Windows (makeuseof.com)   It is most likely under C:\Program Files\SASHome\SASEnterpriseGuide\version. I don't have SAS installed so I can't tell you where and it varies by company. Try and locate it using one of the methods mentioned in the above link.  ... View more

File associations are controlled by Windows, not SAS. An option would be to remove the old EG but people like both. I may be missing something, based upon what you have said, but clicking on a file and having it open the assigned application is controlled by Windows file associations. Just fix the association. A way you can do it is to right-click on a file, and choose Open With, Choose Another App, then select EG 8.1 and check the open by default.   You only have to do it once and it will always open with EG 8.1 from there forward. ... View more

Change your file association in Windows. Lots of material online but here is one: How do I change file associations in Windows 10? (fileinfo.com) ... View more

As stated on here before, run PowerShell vs VBScript. There are plenty of examples on using PowerShell and SAS. See if that clears up a number of your questions.   Start there. I wouldn't spend another minute in VBScript. ... View more

Let me share some info to help you understand the limitations. As a consultant, I have seen SAS installations from 1 person to over 2500 EG users. Recently, I was at a site with over 500 SAS/EG  users and 1 or 2 admins. They also had constrained computing platforms. Hence, the admins had no idea what was happening in the dozens of depts across the company.   If an EG user could just schedule jobs, the system would become quickly overloaded. If that person left, the job would continue indefinitely because it would be scheduled at the server.    As I have mentioned to people before, you don't have to be constrained by any UI application's functionality. Use an RPA tool such as AutoHotKey and just do your manual tasks using a simulated user. ... View more