Help using Base SAS procedures

Uploading Tables to VA with SAS EG

Reply
Occasional Contributor
Posts: 18

Uploading Tables to VA with SAS EG

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!!!!!!!

SAS Super FREQ
Posts: 825

Re: Uploading Tables to VA with SAS EG

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.

Ask a Question
Discussion stats
  • 1 reply
  • 79 views
  • 0 likes
  • 2 in conversation