Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Upload & append data to existing table from EG to VA

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 86
Accepted Solution

Upload & append data to existing table from EG to VA


Hi Forum,

I can upload through EG to VA without a problem but I want to keep adding data to the same table.

Is this supported?

if so, how can it be done?

Thanks


Accepted Solutions
Solution
‎06-18-2015 08:31 PM
Frequent Contributor
Posts: 86

Re: Upload & append data to existing table from EG to VA

I found out through SAS Tech support that the 'BASE' table was the table that held all the appended data & I was looking at the 'JOB' file instead.

Should've realised this but there it is...

So append was working correctly & appending my records.

View solution in original post


All Replies
Frequent Contributor
Posts: 86

Re: Upload & append data to existing table from EG to VA

OK, I've found that if I upload as separate tables I can then go to 'LASR' >> Append tables & append the tables.

Now I want to view this new consolidated table through Excel, but as it isn't a table object, it isn't available to select?

Is there a way to change the new tables so I can access through Excel?

Thanks

Contributor
Posts: 71

Re: Upload & append data to existing table from EG to VA

In EG I am able to connect to our VA metadata repository, and then assign the LASR server library (by default it is not assigned).

Next I just select a LASR data table and send the data to Excel.

This may cause locking problems, so I would be careful...perhaps the SAS gurus can comment.

Just a question...can't you view this table in a VA exploration or report, and then export the data to Excel?

Frequent Contributor
Posts: 86

Re: Upload & append data to existing table from EG to VA

Hi Boschy,

I'm not trying to export to Excel if that's what you mean. I want to connect to a SAS VA table through the Excel SAS Add In & then view & slice/dice the data with a Pivot table.

So the data I'm using is in memory.

Because I want to add more data to the table each week, I want to append more data. I've found that once I append the data it isn't visible through Excel.

I need to either change the object after the append or something else so I can access via Excel.

Contributor
Posts: 71

Re: Upload & append data to existing table from EG to VA

SAS Add-In for MS Office is a similar approach. You should be able to see the LASR server in metadata and access the LASR tables.

However, given that a LASR server library may not automatically pre-assigned (as is our case), it may not appear as a library in an Add-In for MS Office session.

What I suggest is re-thinking your approach. My thought is that Excel Add-In queries should not be reading SAS VA LASR tables...you are taking resources away from VA. Instead, that data should also be maintained (via PROC APPENDs etc) as a dataset outside VA, i.e. in its own Base SAS library. Then you read that library from Excel.

Frequent Contributor
Posts: 86

Re: Upload & append data to existing table from EG to VA

Thanks but I have plenty of VA resources & this is what I need to do.

I just need to know how it can be done.

VA already allows the slicing & dicing of tables via the Add In, I just want to be able to append data to those tables.

Anyone?

Solution
‎06-18-2015 08:31 PM
Frequent Contributor
Posts: 86

Re: Upload & append data to existing table from EG to VA

I found out through SAS Tech support that the 'BASE' table was the table that held all the appended data & I was looking at the 'JOB' file instead.

Should've realised this but there it is...

So append was working correctly & appending my records.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 929 views
  • 3 likes
  • 2 in conversation