About AllanBowe

AllanBowe · ‎11-30-2021

It kills the session in all cases except for Stored Process sessions - as we found that this could leave orphan multibridge sessions and kill the server for some SAS 9 environments. In this case, we take a unique approach - we open a macro but don't close it! This means the rest of the code does not get executed (and the STP session ends "normally") Something like this: filename skip temp; data _null_; file skip; put '%macro skip();'; comment '%mend skip; -> fix lint '; put '%macro skippy();'; comment '%mend skippy; -> fix lint '; run; %inc skip;

AllanBowe · ‎11-29-2021

My team have built two free / semi-free tools that can help you with this particular task: 1) File uploader. A SASjs web app that lets you upload any file to any location on a Viya server - https://github.com/sasjs/fileuploader 2) Data Controller. Free for 5 users, you can drag & drop excel files directly into any (matching) SAS table. https://datacontroller.io

AllanBowe · ‎11-29-2021

If you'd like to do this recursively (ie, to include subdirectories) you can try this macro: https://core.sasjs.io/mp__deletefolder_8sas.html Example usage: %let rootdir=%sysfunc(pathname(work))/demo; %mf_mkdir(&rootdir) %mf_mkdir(&rootdir/subdir) %mf_mkdir(&rootdir/subdir/subsubdir) data "&rootdir/subdir/example.sas7bdat"; run; %mp_deletefolder(&rootdir)

AllanBowe · ‎11-29-2021

If you'd like to do this recursively, you can try this macro: https://core.sasjs.io/mp__dirlist_8sas.html Usage: %mp_dirlist(path=/some/location, outds=myTable, maxdepth=MAX) data work.results; set work.mytable; where file_or_folder='file'; run;

AllanBowe · ‎11-29-2021

Within the SASjs framework we constantly have a need for conditional aborts. So, we wrote a macro for it: https://core.sasjs.io/mp__abort_8sas.html Example usage: %mp_abort(iftrue=(&somecondition=1) ,mac=&sysmacroname ,msg=%str(Some Condition Failed) )

AllanBowe · ‎11-29-2021

For reference we recently published a macro that will (binary) copy ALL files in a particular directory, and recursively so: https://core.sasjs.io/mp__copyfolder_8sas.html

AllanBowe · ‎10-27-2021

I changed my VPN to USA and it works now. Registered! See you there.

AllanBowe · ‎10-27-2021

Nice. We have a similar macro in the SASjs/core library: https://core.sasjs.io/mp__cleancsv_8sas.html

AllanBowe · ‎10-27-2021

sounds great! The link doesn't work for me though..

AllanBowe · ‎10-21-2021

thanks for sharing!

AllanBowe · ‎10-13-2021

Hi Aaron, If you're looking for a 'ready made' solution to what you describe, I would refer you to https://datacontroller.io If you're looking for an 'admin not necessary' approach to building & deploying web apps, you can also consider the SASjs framework - specifically, the 'streaming app' capability. This compiles a frontend into a series of STPs, obviating the need for a web server (and requisite access rights). Happy to jump on a call to explain further.

AllanBowe · ‎10-13-2021

@tomrvincent - the macro has been upgraded since then. Use the 'GETATTRS' argument to get size/date/ownership (doesn't have nested subfolders though) %mp_dirlist(path=/tmp,outds=myTable, getattrs=YES) docs: https://core.sasjs.io/mp__dirlist_8sas.html

AllanBowe · ‎10-12-2021

You may be able to do this without X command - here is a "pure sas" unzip macro: https://core.sasjs.io/mp__unzip_8sas.html

AllanBowe · ‎10-06-2021

You could probably achieve it in one line, using this macro: https://core.sasjs.io/mp__zip_8sas.html

AllanBowe · ‎10-01-2021

Thanks @Oligolas - indeed, that was the approach I used to fix my issue: https://github.com/sasjs/core/pull/84/files#diff-60df2277f57ab4c7bbd043138958de8dc28e6ccddfddb9e8501bd52facf6e585R56 Interesting to see that the problem applies to sashelp.vtabcon also. And nice idea with the subquery. Also credit to @yabwon who investigated behind the scenes, which resulted in a vastly refined / simpler question.