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.
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 '22.214.171.124', 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
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.
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.
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.