This is a vanilla JS demo app to show how to build a SAS-Powered file upload process. The app has a logon screen, then an input box (so the user can provide a target directory path), and a file picker.
The file is sent to SAS where the path is verified, the file is written, and a directory listing is returned.
If the file is greater than 5mb it is sent to SAS in chunks, with a progress bar displayed. A video demonstrating this process is available here: https://www.youtube.com/watch?v=rf9myXovrsk
If the user logs out of SAS whilst an upload is in progress, then the app will prompt for credentials on the next request. The "redirect" flow is implemented, which is compatible with 2FA and other more complex authentication mechanisms.
This app can be deployed as a streaming SAS app by running the code below. Be
sure to set the value of appLoc to your preferred parent folder location in
metadata (SAS 9) or SAS Drive (Viya).
%let apploc=/Public/app/fileuploader;
filename mc url "https://raw.githubusercontent.com/sasjs/fileuploader/master/stream.sas";
%inc mc;The link to open the app will be shown in the log.
It is also possible to upload files using SAS Studio, into your home directory (you can set symlinks to other locations).
If your use case is simply about loading data into SAS, you might want to consider https://datacontroller.io (lets you load excel and CSV files into any SAS table or database with full audit trail - it's also free for up to 5 users).
To deploy this app, first install the SASjs CLI - full instructions here.
Next, run sasjs add to prepare your target (instructions).
Then run the below to deploy the backend (SAS) services:
npm install
sasjs cbd -t YOURTARGET
If you don't have the ability to sasjs add due to not having access to a client / secret, you can instead run sasjs cb and execute the resulting sasjsbuild/build.sas script in SAS Studio V to create the backend services.
Open index.html and make sure the value for appLoc is the same as that used when deploying the backend (sasjsconfig.json).
Also, update the <script> tag so that SASjs is pointing to a CDN (or copy the file from node_modules into the src folder and use a relative reference).
The frontend (src folder) is deployed to your SAS Web server (/var/www/htdocs folder) - you can upload manually, or using the supplied NPM script in package.json.
To be able to run the deploy script, two environment variables need to be set:
SSH_ACCOUNT - your SSH account, this is of the form [email protected]
DEPLOY_PATH - the path on the server where sasjs-tests will be deployed to, typically /var/www/html/<some-subfolder>.
You can run the script like so:
[email protected]
DEPLOY_PATH=/var/www/html/my-folder/file-uploader
npm run deploy
If you have any problems, please just raise an issue! And if you find it useful, we'd appreciate a STAR.
For more information on the SASjs framework, see https://sasjs.io