About AllanBowe

AllanBowe · ‎06-08-2020

You should take the "app" and "cs123secret" and base64 encode (eg using a site like this - https://www.blitter.se/utils/basic-authentication-header-generator/) and use the result, eg: "YXBwOmNzMTIzc2VjcmV0" in your variable.

AllanBowe · ‎06-08-2020

Variable 1 (token_url) -> this is simply the url of your SAS Viya Server. If you are running directly on Viya, this would / could be "localhost. Postman just needs to be able to find "/SASLogon" here. Variable 2 (encoded_id_secret) - this is the base64 encoded output from "${CLIENT_ID}:${CLIENT_SECRET}" (Basic Authentication). So, client_id + ":" + client_secret, base64 encoded. There are online generators to help you create this, eg: https://www.blitter.se/utils/basic-authentication-header-generator/ Variable 3 (OAUTH username / password) - this is the regular username / password you use to log into Viya. Hope this helps. By the way, this approach (with embedded username / password) is known as "implicit" flow. The alternative (authorization_code) is quite similar - this article may help: https://communities.sas.com/t5/SAS-Communities-Library/Token-Management-in-HTML5-Viya-Apps/ta-p/652388

AllanBowe · ‎05-28-2020

Just use LUA, where there are no limits! (just memory limits). Here's an example of creating a variable which is 100k characters wide: proc lua; submit; local demo local example='A' local a=1 repeat example=example..'1234567890' a = a + 1 until( a >100000 ) print(string.len(example)) endsubmit; quit;

AllanBowe · ‎05-25-2020

So in the end we tried all the compute contexts and this one worked: "Import 9 service compute context"

AllanBowe · ‎05-25-2020

We have successfully: * set up a client / secret / access token * obtained a list of contexts from `/compute/contexts` * performed a POST request to `/compute/contexts/{contextId}/sessions` The response indicates that the request was successful, JSON is returned eg: { "owner": "xxx", "state": "pending", "attributes": { "homeDirectory": "/opt/sas/viya/config/var/run/compsrv/default/92c0b34e-b423-4694-857e-de8d1cc724f3", "sessionInactiveTimeout": 900 }, "serverId": "92c0b34e-b423-4694-857e-de8d1cc724f3", "applicationName": "new3FDA16F449B42DE9", "creationTimeStamp": "2020-05-25T15:54:07.000Z", "stateElapsedTime": 0, "sessionConditionCode": 0, "links": [ { "method": "GET", "rel": "self", Note the state - *pending*. Subsequent GET requests to this session return: {"errorCode":5800, "message":"The compute service failed when communicating with another service or server.", "details":["traceId: a1001428b644db83" ,"path: /compute/sessions/92c0b34e-b423-4694-857e-de8d1cc724f3-ses0000" ],"links":[],"version":2,"httpStatusCode":500} We tried this on the "SAS Studio compute context" and the "sharedcompute" context we created (pooled compute). How do we get more information? What could be the cause of the session not being properly fired up?

AllanBowe · ‎05-16-2020

Bit of a biased post as we built the site, but https://sasensei.com is geared towards those who already have some SAS knowledge and would like to build on those basic concepts. There are plenty of Stats questions but not so many on Clinical Trials mind..

AllanBowe · ‎05-16-2020

This is a short article to provide supporting and background info for my SGF 2020 virtual presentation, "Build a HTML5 Web App Using SAS". This was originally planned as a HoW (Hands On Workshop), and the workshop (1 hour) is still available for those who are interested, they are free, we run them occasionally whenever there is enough interest. Just send me a PM. The presentation itself talks about the SASjs framework, which was launched in 2020 as a cohesive approach for building Web Apps on SAS. The components are: MacroCore (SAS Macro Library for backend SAS dev) SASjs (JS adapter for frontend/backend communication with SAS) sasjs-cli (NPM tool for building the backend in an 'opinionated' way) It kicks off with an example of building a single-page-app in just 2 lines of SAS code! You can try this yourself, if you have SAS 9 and a Stored Process Server (and internet access from SAS): filename playme url "https://sasjs.io/game"; %inc playme; After running the above, open the url that is displayed in the log. You will have your own space invaders game: Another feature of the SASjs CLI tool is that it lets you compile your frontend into web services, thereby avoiding the need to access the SAS web server. This isn't a recommended approach, however - sometimes it's the only available approach. The video itself is available below: The paper can be found here, and the slides are here. Other links: https://sasjs.io - information on building web apps with SAS https://github.com/sasjs/adapter - adapter for SAS-JS communication https://github.com/sasjs/cli - CLI tool for SAS projects https://github.com/sasjs/core - Macro Library for Application Development https://github.com/sasjs/react-seed-app - Seed app using React https://github.com/sasjs/angular-seed-app - Seed app using Angular https://github.com/sasjs/minimal-seed-app - Seed app with minimal code https://js.cards - quiz game to test your JS skills! https://sasensei.com/flash/45 - A-Z of building web apps with SAS https://sasensei.com/questions/filter?tags_any=[13] - quiz on building SAS web apps https://datacontroller.io - Example of a commercial HTML5 SAS web app https://www.youtube.com/watch?v=vSNBea_M8yU - Build a Viya web app in 5 mins https://www.youtube.com/watch?v=hUpBqExNec4 - using sasjs-cli to build a SAS backend We'll continue to open source our tooling and technology for building Web Apps on SAS 9 and Viya. Comments are welcomed!

AllanBowe · ‎05-11-2020

This was exactly my approach. I put uniquely named tables in the CASUSER library and `proc fedsql` with the sessref option to join them. Thanks!

AllanBowe · ‎05-09-2020

I'm running a Job Execution Service as the backend for a HTML5 web app using a shared service account on SAS Viya 3.5 as described here. The challenge is, that my app is attempting to left join a WORK table with a large CASLIB table, which then fails with: ERROR: The maximum allowed bytes (104857600) of data have been fetched from Cloud Analytic Services. Use the DATALIMIT option to increase the maximum value. I'd rather not increase the limit, as the table could be very large. Instead I'd like to push my WORK table into CAS and perform the join there, returning the subset I need. The challenge is, that my app will have many users, potentially running this join concurrently. My current plan is to create tables in the shared CASUSER library that are named using an md5() hash, thereby virtually guaranteeing uniqueness and avoiding a naming clash. Whilst I'll certainly clean up this table afterwards, my concern is whether some unforeseen bug will prevent the cleanup operation. It would be better to create this table in a location that would be automatically cleared (like SASWORK). Is there such concept of a CASWORK library? (implied here but that still ends with a proc delete)

AllanBowe · ‎04-29-2020

Should you decide to go ahead and purchase a BI server (or Viya) licence you may wish to investigate Data Controller (https://datacontroller.io). It is exactly what you ask for (an interface for entering data) and includes: * Data Quality rules at source * Data Approval (sign off the changes before they are applied) * Data Audit (who changed what, when, and why) * Data Search (search full tables) * Data Upload (excel or CSV) * Data Dictionary * Data Catalog * Data Workflows (run SAS programs before / after data edits or approvals) * Data Alerts (on submit, approve or reject events) * DDL Generator * Datalines Generator * Data Links (to tables, subsets, or individual records) * Data Lineage explorer (SAS 9 only) * MetaData Explorer (SAS 9 only) All with full SAS authorisation and authentication.

AllanBowe · ‎04-27-2020

which client? which version? which platform? more details are needed. Can you record a short video and show us the error message?

AllanBowe · ‎04-20-2020

aha - thanks! Seems that it works just fine when you run it from the Downloads folder. I'd actually moved the binary to the ~/.sas directory, and it seems that this is not a supported configuration.

AllanBowe · ‎04-20-2020

Are you on mac? Where did you get your download? ``` ➜ .sas ./sas-admin plugins list-repos sas-admin plugins: 'list-repos' is not a sas-admin plugins command. See 'sas-admin plugins --help'. ``` ``` ➜ .sas ./sas-admin plugins list-repo-plugins sas-admin plugins: 'list-repo-plugins' is not a sas-admin plugins command. ```

AllanBowe · ‎04-20-2020

How did you invoke the STP? Which client app? Can you share a screenshot? How did you create the STP? Using the graphical interface in EG, or programmatically by running code?

AllanBowe · ‎04-18-2020

I downloaded the latest sas-admin CLI from https://support.sas.com/downloads/package.htm?pid=2133 and set up a profile / authenticated successfully. However it seems that none of the plugins are available. How do I proceed? Is it only possible from the Viya server directly? I'm on OSX. ➜ .sas ./sas-admin plugins list Listing available command line plugins... Name Version Description config ➜ .sas ./sas-admin plugins list-repo-plugins sas-admin plugins: 'list-repo-plugins' is not a sas-admin plugins command. ➜ .sas ./sas-admin plugins install --repo SAS authorization sas-admin plugins: 'install' is not a sas-admin plugins command. See 'sas-admin plugins --help'.