My first thought is E8601 formats, but do peruse the list: http://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#n0verk17pchh4vn1akrrv0b5w3r0.htm ... View more

How big is the data you are talking about?  If its reasonable size and still filling your storage space, then get a bigger storage space.  If its huge data then you might need a whole new infrastructure. As for optimising your code, without seeing any code, knowing anything about your process or system, or knowing anything about your data, I don't see how it is possible to provide any useful information.  Why do you need to sort for instance?  Can the data not be sorted up front.  What about using an index?  How is the sort to be used further along.  How is the data stored, is it locally, network, database etc. ... View more

You need to look at what the procedure in question is doing, and what it is for. Proc sort - this procedure is for sorting data. Proc print - this procedure is for printing data. You do not use proc print to sort, hence when you use the by statement in a proc print, it assumes the data is already sorted, and as it is not then your procedure fails. Unlike SQL (and other languages) data going into procedures is expected to be sorted when using by group processing, if it isn't then you will get warnings/errors.  If you add the option notsorted, then you will get output, but it will block the data in the order it finds it, which is often not the way intended, so use cautiously. So, if your problem is, I want to sort the data, then print it out: 1) proc sort out=sorted 2) proc print data=sorted ... View more

This isn't the place for contract work.  There are other boards out there if you want someone to build you a tool.   Log scanning is pretty simple, open the file (infile) to read in a datastep, then read one by one and search for string using functions like index. For creating json file, in later releases there is things like: https://support.sas.com/rnd/base/Tipsheet_PROC_JSON.pdf Or you could just write out to a plain file using file and put statements. Both those tasks are pretty basic, and there is plenty of tutorials on reading/writing files out there. Do bear in mind that code you find on the internet may be old, not work the way you want etc. ... View more

You could do something like: /* Set up dir list - change for your operating system */ filename tmp pipe 'dir "c:/root_location" /b'; /* Read list of files in and for each one execute a system command to rename */ data _null_; length buff want str $200; infile tmp; input buff $; want=catx("_","client",scan(buff,2,"/")); str=cat('x ',"'",'ren ','"c:/root_location/',strip(buff),'" "c:/root_location/',strip(want),'"'); call execute(str); run; filename tmp clear; Do note, that is based on Windows, and I have nothing to test it on.  But something like that should work.  Its just a matter of pulling in a list of file names, then using call execute to shoot out a rename from to. ... View more