Hi Eyal - we have produced multiple solutions for this issue.  You may wish to take a look at the SASjs Adapter which handles the polling of the Viya Job:  https://adapter.sasjs.io You could even consider creating your own 'middleware' REST API to call Viya.  We have done this for a client who needed to accept SOAP requests and process them in Viya.  We used NodeJS to convert the request to a Viya call (using SASjs Adapter) and provide the appropriate response. The library also handles issues such as token authentication and refresh.  It's all MIT open source: https://github.com/sasjs ... View more

Hi Gregor - my team have produced a tool for this and it's free for up to 5 users - https://datacontroller.io Just drag & drop your excel into the browser, and the dates are extracted automatically (and correctly) using our OEM licence of https://sheetjs.com The underlying (CSV) data is then sent to SAS for review & approve before being applied to your target dataset / CAS table / database.   Feel free to PM or comment if you'd like more details. /Allan ... View more

Some additional options for uploading data to "SAS Studio":   1.  Drag & Drop into Data Controller -> https://datacontroller.io 2.  Deploy a Viya web for uploads, eg:  https://github.com/sasjs/fileuploader 3.  Build something using the SASjs Server REST API:  https://server.sasjs.io ... View more

You can stream ANYTHING you like!  Generally I'd look to create the file, then just stream it as it is, rather than using ODS but it should still work. I had a realisation about this - are you creating the Jobs manually (not using SASjs)? If so, have you set the option to remove the automatic JES macros?  `_addjesbeginendmacros=false`   These work similarly to the `stpbegin` and `stpend` macros in SAS EBI, and can affect the usability of the _webout destination. ... View more

This macro will recursively scan a directory and produce an output table with a file listing and their corresponding md5 hashes.   https://core.sasjs.io/mp__hashdirectory_8sas.html So if there is a change of any data in any of the files, you can can identify it by the change in the hash value.   This feature is used by the SASjs "fs sync" function as documented here:  https://cli.sasjs.io/fs This lets you synchronise a remote (SAS) directory with a local (desktop) one. ... View more

Hi jins - am happy to try and help but it may be easier to do this through a screen share.  Feel free to book a convenient slot with me using this link:  https://4gl.uk/book   We can then report back with the solution should we find one. ... View more

The `_program=/should/be/the/path/to/your/job/in/sas/drive` WITHOUT a .sas extension ... View more

There is an excel download option in Data Controller for SAS - here is the SAS code behind the download service:  https://code.datacontroller.io/getrawdata_8sas.html   It uses this macro directly: https://core.sasjs.io/mp__streamfile_8sas.html Here's an extract: filename &outref filesrvc parenturi="&SYS_JES_JOB_URI" name='_webout.xls' contenttype='application/vnd.ms-excel' contentdisp="attachment; filename=&outname"; This works fine for DC customers.  How exactly are you "running" the code?  Are you deploying it as a Job and opening the URL using the JES Web App with the appropriate _PROGRAM parameter? Or calling via the JES REST APIs? ... View more

Thanks Danny!  Those are nice hacks. In the end I actually used an 'out of the box' solution - I used SAS to create a `.github/workflows/release.yml` which triggered an action to create the tag as part of the push to main.   The source code is all here:  https://github.com/sasjs/core/blob/main/sasjs/utils/create_sas_package.sas#L177 ... View more

For the future you might want to consider the use of SASjs for documenting your SAS jobs. If your developers follow the approach, you can generate Data Lineage diagrams (inputs/outputs) directly from the program headers.   Here are the docs:  https://cli.sasjs.io/doc/ ... View more

If you'd like the "point and click" ability to edit formats in a catalog, you are welcome to try out this tool (built by my team):  https://docs.datacontroller.io/formats/ It's free for up to 5 users, you can edit formats directly, upload from excel, download in various formats, run filters, and even configure jobs to run after a format is updated. ... View more

Yes, that's one way of doing it! We have a bunch of demo SAS web apps you can check out here: https://github.com/search?q=topic%3Asasjs-app+org%3Asasjs+fork%3Atrue&type=repositories There is also a support group: https://matrix.to/#/#sasjs:4gl.io ... View more

Hi @jimbobob - great question!   The strange looking filename is a special destination that - when used in combination with the parmcards statement - allows you to write arbitrary content to a fileref (in a very similar way to cards / datalines to a data set)   We use it in SASjs as a convenient way to deploy multiple stored processes in a single SAS program.   ... View more

You are correct that an md5 (or equivalent) hash checksum is the right way to check if a file has been corrupted or in any way modified.   Since m6 (thanks @yabwon for bringing this to my attention) there is also a function native in SAS that can do a full-file checksum.  It is called  hashing_file()  and can even be used in pure macro, eg:   %put %sysfunc(hashing_file(md5,/path/to/file.blob,0));  If you would like to hash an entire directory (of directories) of datasets, you are welcome to use this macro:  https://core.sasjs.io/mp__hashdirectory_8sas.html   ... View more