BookmarkSubscribeRSS Feed
vula
Fluorite | Level 6

Hi Techies,

 

Can anyone please explain how the autoload script works in SAS VA LASR.

I want to see the data in dashboard upto date by refreshing it in report viewer. My data is in dataset created from SAS EG and loaded it into SAS VA LASR server.Now if i run the code in EG the data that gets updated in sas data set needs to be automatically updated in SAS LASR server so that we can see the updated data in dashboard.

 

So please let me know about the script and also provide documentation if any on how to process it.

 

Thanks

3 REPLIES 3
Kalind_Patel
Lapis Lazuli | Level 10

Have you used EG's UPLOAD TO LASR feature?

 

You don't even need any script to do this,

you just right click on the table and select UPLOAD TO LASR,

after that, your updated table will load to LASR when you run that flow in EG.

upload_to_lasr.png

MikA
Obsidian | Level 7

Good question - I'm in exactly the same situation.

An the EG-method seems very useful.

But how do I define where to put on the LASR server? It seems like it cant find the rigtht place?

 

58             FOOTNOTE;
59             FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %SYSFUNC(DATE(), NLDATE20.) at %SYSFUNC(TIME(),
59       !  TIMEAMPM8.)";
60             %deletedsifexists(TMP00004, FIGUR1);
61             /* Loading through the SASIOLA Engine */
62             data TMP00004.FIGUR1 (  );
63                 set VA_DATA.FIGUR1 (  );
64             run;
65         
66         %mend;
67         
68         %codeBody;
ERROR: A connection to the LASR Analytic Server on '11.111.11.1', port 10011, could not be made. Make sure that the host and port 
       are correctly specified, that you are attempting to connect to a LASR Analytic Server of the correct vintage, and that the 
       server is still running.
ERROR: Libref TMP00004 is not assigned.
ERROR: Error in the LIBNAME statement.

ERROR: Libref TMP00004 is not assigned.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
vula
Fluorite | Level 6

Hi Patel,

 

Thanks for your reply.

 

I dont want to load it from SAS EG. I had taken this as an example. please tell me if the data for dashboard is coming from Hadoop. for the first time we can load the table structure to LASR memory after that autoload script needs to pull the data to LASR memry from source.

 

Thanks

Eknath.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1153 views
  • 1 like
  • 3 in conversation