Uploading Tables to VA with SAS EG

RexDeus9 — Wed, 10 Jan 2018 14:43:54 GMT

Hi,

Just like many of you, I have many requests by users to upload various data sets to VA. I mostly do it with SAS EG. (Why SAS EG when you can do this with VA?, I'm just a big fan of EG and and have many use for it when managing various issues of SAS).

And probably like many of you, I've created a SAS EG project to upload various data sources to VA. Lately I ran into this issue:

The internal "Upload to LASR" function in SAS EG makes use of such code: (e.g. Loading the "data set A" table. Yes I know, it should never have such a naming, but stay with me)

%registerTable(
LIBRARY=%nrstr(/Products/SAS Visual Analytics Administrator/Visual Analytics LASR)
, FOLDER=%nrstr(/The/Data/Source/data set A));

The above runs fine even though empty spaces are part of the table name.

If you try to upload multiple tables in batch with code like this: (which could include table names with spaces):

%registerTable(
LIBRARY=%nrstr(/Products/SAS Visual Analytics Administrator/Visual Analytics LASR)
, FOLDER=&tblFolder.);

The code fails on "FOLDER=&tblFolder." statement with:

ERROR: Given folder path '/The/Data/Source/data set A'n is not found.

I've tried many quote/unquote variations and can't get it to work.

Help!!!!!!!

Re: Uploading Tables to VA with SAS EG

BrunoMueller — Wed, 10 Jan 2018 14:56:36 GMT

Somehow your folder name became a name literal '/The/Data/Source/data set A'n (are you using the NLITERAL function)

For a Foldername this is not necessary.

Change your code that creates the &tblFolder macro variable, so you are not using the name literal.

topic Re: Uploading Tables to VA with SAS EG in SAS Procedures

Uploading Tables to VA with SAS EG

Re: Uploading Tables to VA with SAS EG