About RichardPaterson

RichardPaterson · ‎03-24-2017

Thanks Juan, I did of course see Michele's post. The reason I asked is that the Whats New for 8.1 is, well how can I phrase this, underwhelming to say the least. So if these are the enhancements with respect to 7.3, one would have the ask the question - what exactly has been been changed in 7.4. And when 7.4 is released will the 'whats new for 8.1' be revised. Or is 7.4 just 8.1 without the Viya backend? I guess we will see in "the coming weeks".

RichardPaterson · ‎03-23-2017

thanks! is this a ' whats new' with respect to 7.3 or 7.4? regards, Richard

RichardPaterson · ‎03-23-2017

Hello, I am looking for the customary 'Whats new' documentation for 8.1. Does this exist? Or does 8.1 have the same functionality as 7.3? Also I have been invited by SAS to a demo of VA 7.4, is there documenation for 7.4, I don't see 7.4 listed on the documenation site? regards, Richard http://support.sas.com/documentation/onlinedoc/va/index.html#viya81

RichardPaterson · ‎10-10-2016

Hi, I want to follow up on this thread. I have loaded a table from HDFS to LASR. The table is 50GB on HDFS. I can see from the _T_TABLEMEMORY table that indeed only 13MB (yes MB) has been actually allocated in memory. This is as expected accoding to the information provided above. The issue I have is that this mapping of 13MB of data is taking almost 3 minutes to complete. Can someone provide some insight into what actually is happening between clicking the load button and the data being available in LASR. Any help much appreciated, regards, Richard The LASR Procedure Performance Information Host Node sasva.infra.local Execution Mode Distributed Number of Compute Nodes 3 Data Access Information Data Engine Role Path VAPUBLIC.JENNIEVATEST2 SASHDAT Input Parallel, Symmetric

RichardPaterson · ‎09-26-2016

We are nearing the end of Q3. Any news on what, when, how? Next week is the SAS Forum here in Holland, can we expect an announcement? thanks,

RichardPaterson · ‎09-26-2016

Thanks Bruno, I will go with this solution, thanks, and hope that in a future release there is more interactivity between stored processes and reports. kind regards, RIchard

RichardPaterson · ‎09-15-2016

Hello, I have a stored process which I would like to deploy in multiple VA reports. The code to be executed should however dependent on the name of the VA report containing the stored process. Is it possible from within the stored process during run-time to determine the name of the parent VA report? any input very welcome. regards, Richard

RichardPaterson · ‎08-04-2016

Hi Gerry, this helps a lot. many thanks. If I wanted to determine the current amount of data physically loaded into memory then I would just sum the TableAllocatedMemory column, right? It appears that only a small percentage of the rows of my SASHDAT tables are being loaded. What kinds of actions on a table (from VA) would force more data into LASR? I have tried all kinds of visualization and filters etc but the amount od data loaded remains stable. I will investigate the READAHEAD option. regards, Richard

RichardPaterson · ‎08-02-2016

Hello, In the SAS(R) LASR(TM) Analytic Server 2.7: Reference Guide, there is a section on Memory Management. The internal LASR table _T_TABLEMEMORY contains information on all loaded tables in LASR. I am puzzeled about the columns used in this table - (1) InMemorySize - Amount of memory that is needed to store the table in memory. (2) TableAllocatedMemory - Amount of memory that is used for table storage. I am wondering what the difference is between these two columns. I am assuming that 1 is the maximum amount of memory needed to load the table fully into memory and 2 is the amount of memory currently being used for the table (perhaps the user has selected a subset of the data and therefore not all records have been read from the HDFS store). This would appear to make sense since for tables loaded from HDFS the TablesAllocatedMemory value is always a small percentage of the InMemorySize. And for user imported excel sheets the TableAllocatedMemory exceeds the InMemorySize. I understand that for user imported data there is a overhead penalty. Anyway, does anyone have more knowledge of this table? any help appreciated. regards, Richard

RichardPaterson · ‎07-01-2016

Hello, Are the municipalities already visible on the actual openstreetmap map? If not then they will never show on the map. SAS just displays the maps and superimposes the specified region. If you specified the Municipality as the Geo subdivision then you will see this text value when you place your mouse pointer over a specific region. Richard

RichardPaterson · ‎07-01-2016

Hi, Is there a specific reason why you want to do this in the data builder? A simple aggregated measure will give you the same result. Richard

RichardPaterson · ‎06-23-2016

Hi Tricia, many thanks for your post. The technical side of my brain took over and I forgot to dive deeper into the real issue behind the customer question. This has now been addressed. We willl probably solve this issue by displaying the max date on the report. I hope SAS will add more tighter integration of stored processes into VA. But then I don't need to tell you how great stored processes are 😉 Richard

RichardPaterson · ‎06-21-2016

Hello, I would like to display on my VA report the date the underlying LASR tables were last loaded. I have managed to extract the load information from the LASR server. Now the problem I face is how to present this on the report. Ideally I would like to use a stored process for this purpose, whereby the stored process extracts the data about the parent report however the stored process has no knowledge of the report it is running in. I could request the user to enter the name of the report into a stored process prompt however this is error prone. Got an idea? love to hear it! Richard

RichardPaterson · ‎06-16-2016

yes this is unfortunately correct. And there is also no interactivity possible between a stored process object and another VA object. I think this is VERY easy for SAS to implement. I really hope this is in a next version, then we can make some really nice dashboards using the power of stored processes. I do not have the knowlegde, but it may be possible for a piece of javascript to 'scrape' the current value of a drop down list for example and then pass this into the stored process..... If you know how to do this I would be grateful to learn how. Richard

RichardPaterson · ‎06-16-2016

how many images are we talking about? This number would help determine the approach. These are the possible solutions. None of this code is tested. 1. transfer images to local file system and display the image using the Image object in VA. This is only practical for a small number of images. 2. transfer images to a WebDav server. Then add a stored process to VA with a parameter for the employee name. The stored process will write HTML code to reference the image on the webDav server. data _null_ ; file _webout; set pics; put '<HTML>'; put '<HEAD></HEAD>'; put '<BODY>'; put "<h3>Employee &employee</h3>"; put "<IMG src='http://webdav.local/pics/employee&..jpg'></IMG>"; put '</BODY>'; put '</HTML>'; run; 3. If you want to read the images directly from the database, there your stored process will look something like this, Libname pics "<to source database>"; proc sql noprint; create table pics as select photo as img format=$32767. informat=$32767. from pics.picstable where employee="&employee"; /* macr o variable passed from stored process in VA */ quit; /* transfer image from database to a temporary location that can be referenced by your SAS web server */ /* this will be something like - /opt/sas/config/Lev1/Web/WebServer/htdocs/pics */ data _null_; set pics; file "/temp/somewhere on your VA server.jpg" LRECL=32767 NOPRINT NOTAB; put img; run; /* again use HTML to display the picture */ data _null_ ; file _webout; put '<HTML>'; put '<HEAD></HEAD>'; put '<BODY>'; put "<h3>Employee &employee</h3>"; put "<IMG src='http://localwebserver/pics/employee&..jpg'"></IMG>"; put '</BODY>'; put '</HTML>'; run; RIchard

Online Status	Offline
Date Last Visited	‎02-26-2022 11:02 AM

Re: VA 8.1 on Viya

Re: VA 8.1 on Viya

VA 8.1 on Viya

Re: Monitoring Table Memory Use - _T_TABLEMEMORY

Re: Future release SAS VA

Re: Does stored process know in which VA report it is running?

Does stored process know in which VA report it is running?

Re: Monitoring Table Memory Use - _T_TABLEMEMORY

Monitoring Table Memory Use - _T_TABLEMEMORY

Re: About names in customized region maps

Re: Finding the max length that occurs within each variable

DIsplaying date the LASR table was last updated on report?

Re: How to display images in VA dasboard from database

Printing to PDF in 7.3

Re: Cache Table Size

Re: character to numeric conversion

Re: VA 8.1 on Viya

Re: VA 8.1 on Viya

VA 8.1 on Viya

Re: Monitoring Table Memory Use - _T_TABLEMEMORY

Re: Future release SAS VA

Re: Does stored process know in which VA report it is running?

Does stored process know in which VA report it is running?

Re: Monitoring Table Memory Use - _T_TABLEMEMORY

Monitoring Table Memory Use - _T_TABLEMEMORY

Re: About names in customized region maps

Re: How to get the count of previous period in Data Preparation

Re: DIsplaying date the LASR table was last updated on report?

DIsplaying date the LASR table was last updated on report?

Re: How to display images in VA dasboard from database

Re: How to display images in VA dasboard from database