About GertNissen

GertNissen · ‎08-07-2019

Great 🙂 News in VA 8.4 I'm looking forward to Freeze columns in a list table as you view a report, just like a spreadsheet. The new Suggestions pane gives you suggested insights based on all your data Giving report consumers the ability to make reports their own As you make changes to your report in View Mode, SAS Visual Analytics remembers your choices Question? Is the Windows version limited to only Visual Analytics or will it be possible to run Visual Statistics and VDMML also on Windows environments?

GertNissen · ‎07-25-2019

Hi @chaudharydeepak This respons is valid in VA 7.3 (You have not stated what version of VA you are using - would be helpfull to know) 1) Make sure your Unique_id is a category 2) Make sure that it's also been used in both visualizations Btw: You could remove Unique from the List Table object (not needed, just added it for clarity) Next you add the interaction (remember it will only work on visible columns in Object 1 - here the Bar Chart) Select Unique_id from both tables.

GertNissen · ‎07-25-2019

Try IF ( Geo= 'APAC' ) RETURN 'APAC' ELSE 'Rest of the World'

GertNissen · ‎07-25-2019

oouupps ;-( sorry We found the error, and it was actually visible in my first screen shot - well hidden behind the grey overlay. Somehow we managed to get a third (unknown origin) LASR server using the same port as our existing LASR server. Not 100% sure where it came from, but bravely (aka desperate) deleted the new unknow LASR server and now our "old" LASR starts again, autoload works again and the users have confirmed everything is working 🙂 That might explain why Public LASR, EnvMan LASR was working, while only LASR LASR was not.

GertNissen · ‎07-24-2019

Still struggling with understanding the problem and finding a solution Found these, perhaps it would help investigation... Like Public LASR can start, also Env Lasr can start - only 'LASR' that can't start D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles\ ERROR: The LASR Analytic Server image does not contain any tables.

GertNissen · ‎07-23-2019

Thanks @alexal Not sure if I'm following your steps correctly? I don't have write access to 😧 but changed to K: in XML code Submitted the start Workspace server on CMD (pointing to k:\) D:\SAS\Config\Lev1\SASApp\WorkspaceServer\WorkspaceServer.bat -logconfigloc K:\http_logger.xml -nodms Submitted the LASR start code from EG (connected to sasvasmp) But I dont think I'm hitting the 'new' Workspaceserver ?? No output (or file) in k:\out.log ?

GertNissen · ‎07-23-2019

Hi all VA System Admin Experts 😉 Would very much appreciate your input on this matter, as our VA environment has been down since friday - has been runnning fine for long ;-( Environment: VA 7.3 SMP on Windows server 2012R2, all SAS Windows services are running 2 LASR servers LASR Analytic Server – sasvasmp (DOWN) Public LASR Analytic Server – sasvasmp (RUNNING) Error: Can't start LASR (public can start) When run in SAS Display Manager 1 libname ml sasiola startserver= 2 ( 3 PATH="D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator 3 ! \sigfiles" 4 LOGGING 5 ) 6 7 host="sasvasmp.XXXX.net" port=10010 8 signer="http://sasvasmp.XXXX.net:80/SASLASRAuthorization" 9 ; NOTE: No tag was specified in the LIBNAME statement. The default tag (WORK) is used to name and identify tables in the LASR Analytic Server. You can specify a tag as a data set option. ERROR: Unable to register LASR server with authentication service. ERROR: Libref ML is not assigned. ERROR: Error in the LIBNAME statement. Logfiles: \SAS\Config\Lev1\Web\Logs\SASServer12_1\SASLASRAuthorization7.3.log Only "Error delegating 'createClob' call" \SAS\Config\Lev1\Web\Logs\SASServer12_1\SASVisualAnalyticsViewer7.3.log [VIEWER ] ERROR [tomcat-http--36] 2019-07-23 07:14:14,725 [ST-917-5JYwqIYtiZf4gWADWIWP-cas:TIGR] com.sas.bidata.error.DataErrorHandler - AuthorizationFailure com.sas.lasr.LASRAuthorizationException: ERROR: The signature is not valid, access denied. Signon to http://sasvasmp.XXXX.net:80/SASLASRAuthorization is working for my user (AND Public LASR is starting with auth enabled) If LASR Authorization Service is removed in SMC, it will start the LASR server but all data is inaccessible (Error: Datasource has no content or is not available in memory) SAS Note http://support.sas.com/kb/52/315.html D:\SAS\Config\Lev1\Web\activemq\data has been deleted, with no effect Signature files SAS Note: http://support.sas.com/kb/51/624.html D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles From: LASR.2592927925.0.saslasr.log ID=1,PID=20476,SASTime=1879493636.3,Time=Tue Jul 23 09:33:56 2019,User=gnis,Host=SASVASMPPRD,LASRServer=D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles\/_T_9A8CF0A6_5837BA8/LASR.2592927925.0.saslasr,Port=10010,RawCmd=action=ServerInfo,ExeCmd=action=ServerInfo,JnlMsg=,StatusMsg=Command successfully completed.,RunTime= 0.00 ID=2,PID=20476,SASTime=1879493636.3,Time=Tue Jul 23 09:33:56 2019,User=gnis,Host=SASVASMPPRD,LASRServer=D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles\/_T_9A8CF0A6_5837BA8/LASR.2592927925.0.saslasr,Port=10010,RawCmd=action=ServerVersion,ExeCmd=action=ServerVersion,JnlMsg=,StatusMsg=Command successfully completed.,RunTime= 0.00 ID=3,PID=20476,SASTime=1879493636.4,Time=Tue Jul 23 09:33:56 2019,User=gnis,Host=SASVASMPPRD,LASRServer=D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles\/_T_9A8CF0A6_5837BA8/LASR.2592927925.0.saslasr,Port=10010,RawCmd=action=Terminate,ExeCmd=action=Terminate,JnlMsg=,StatusMsg=Command successfully completed.,RunTime= 0.00 From: LASR.2523228033.0.saslasr.log ID=1,PID=20548,SASTime=1879423936,5,Time=Mon Jul 22 14:12:16 2019,User=gnis,Host=SASVASMPPRD,LASRServer=D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles\/_T_9665677B_237D7E48/LASR.2523228033.0.saslasr,Port=10010,RawCmd=action=ServerInfo,ExeCmd=action=ServerInfo,JnlMsg=,StatusMsg=Command successfully completed.,RunTime= 0,00 ID=2,PID=20548,SASTime=1879423936,5,Time=Mon Jul 22 14:12:16 2019,User=gnis,Host=SASVASMPPRD,LASRServer=D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles\/_T_9665677B_237D7E48/LASR.2523228033.0.saslasr,Port=10010,RawCmd=action=ServerVersion,ExeCmd=action=ServerVersion,JnlMsg=,StatusMsg=Command successfully completed.,RunTime= 0,00 ID=3,PID=20548,SASTime=1879424161,7,Time=Mon Jul 22 14:16:01 2019,User=gnis,Host=SASVASMPPRD,LASRServer=D:\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles\/_T_9665677B_237D7E48/LASR.2523228033.0.saslasr,Port=10010,RawCmd=action=ServerVersion,ExeCmd=action=ServerVersion,JnlMsg=,StatusMsg=Command successfully completed.,RunTime= 0,00

GertNissen · ‎05-06-2019

If you want new features in SAS Enterprise Guide, then add them to the SAS Ballot or wote on existing ideas. I have added 4 suggestions for improving SAS Enterprise Guide EG: Remember ‘old’ where clauses EG: Color code Notes and programs icons, like flows EG: More flexible run to/from options EG: Add new program node etc from more places Would also like to give som attention to these ideas, that I think need votes show ordered list name in task status by @tomrvincent More power to Find & Replace by @SuryaKiran Sort Dataview in EG by @JoeRotford

GertNissen · ‎12-03-2018

Hi All Welcome back to another season of SAS Juletip 😉 This year we will have Juletips every working day in December, and even some days with two Juletip. All Juletip will be tagged, and you can find all the Juletip from previous years in the community: 2014 2015 2016 2017 2018 38 17 17 16 (new every day) Please comment, like and share the SAS juletip ---------------------------------------------------------------------------- Juletip #1 - Finding Missing data Sometimes when you work with data you need to get a quick&dirty overview of the data quality - i.e. in regards to missing values. Today's tip introduces 4 simple ways to get a fast overview and with other small tips introduced along the way. 1) Quality overview of your numeric variables using PROC MEANS; PROC MEANS data=Sashelp.Heart nolabels NMISS N stackodsoutput; var _NUMERIC_; * Being lazy not specifing the individual variables *; ods output Summary = MissingValues; run; Notice the output table being made with ods and not "output out=" syntax. The option stackodsoutput controls how the output looks You could then create a list of problem variables with missing values for later use - if needed proc sql noprint; select Variable into :MissingVarList separated by ' ' from MissingValues where NMiss > 0; quit; %put &=MissingVarList; 2) Using Data step The missing() function has been around for many SAS version, but not many are using its siblings nmiss & cmiss nmiss() count numeric missing cmiss() count not Char Missing, but Count Missing of both numeric and char variables - making is more useful When adding all available variables to arrays, we can refer to them automatically without specifying each of them (lazy approach) data _NULL_; set sashelp.heart; array char[*} $ _CHAR_; array num[*} _NUMERIC_; if cmiss(of char[*], of num[*]) then put 'Missing:' _n_ char[*]=; run; Notice the summarization of all variables in the array, and the put of all variables in the log. You could of course output the same to a dataset. Looping etc. 3) Outputting the variable name with missing values This example loop through the variables and only output the variable names (vname) that contain missing values for each obs data Missing(keep=obsno name); set Sashelp.Heart nobs=nobs; array char[*} $ _CHAR_; array num[*} _NUMERIC_; obsno=_n_; length name $32; do i=1 to dim(char); if cmiss(char[i]) then do; name = vname(char{i}); output; end; end; run; 4) Using proc freq with formats An alternative solution using formats and proc freq First setup a dummy format to distinguish between missings and not missing. proc format; value missing .='Missing' other = 'Has Value'; value $missing ' '='Missing' other = 'Has Value'; run; Here we aggregate all values to two groups based on the format ods output OneWayFreqs=freqs; *ods trace on; * Use this to identify output tabels in ODS*; proc freq data=sashelp.heart; tables _all_/missing; format _character_ $missing. _numeric_ missing.; run; *ods trace off; ods output close; This tip also outputs the result using ODS output in a different way than in example 1. Question: These small snippets are just examples, How would you get this overview of missing values in your data? add a comment below.

GertNissen · ‎10-18-2018

It's all Data Management 😉 Data Integration is a broad term describing how to "work" with data, i.e. building a Data Warehouse - for that you can use different load techniques - such as ETL, ELT, DataVault, StarSchemes, MapReduce, UPM (Unified Programming Model) etc. etc. Sometimes Data Quality is an "add-on" to the ETL, to emphasize the extra importance (others might argue its part of the T in ETL). Perhaps you could skip the T and pour all data into a Data Lake? How would ETL be possible in Real Time environments? Some would might also add Data Migration and Data Consolidation as additional processes to Data Integration or Data Federation/virtualization. Master Data Management could also be added into the same context. There is an short SAS article here that has an good explanation https://www.sas.com/da_dk/insights/data-management/what-is-etl.html Gartner uses this definition The discipline of data integration comprises the practices, architectural techniques and tools for achieving the consistent access and delivery of data across the spectrum of data subject areas and data structure types in the enterprise to meet the data consumption requirements of all applications and business processes. Source: https://www.gartner.com/it-glossary/data-integration-tools/ SAS has many Data Management tools - https://www.sas.com/da_dk/solutions/data-management.html?gclid=CjwKCAjw3qDeBRBkEiwAsqeO7jwzz1tZn7Ah7buInxWl7meMrEjyjAHfzauYHxGH_ANbA0sH6r5xkBoC-scQAvD_BwE In SAS you would typically use the tool SAS Data Integration Studio (+ Data Management Studio) to build your ETL jobs/flows to build your Data Warehouse.

GertNissen · ‎07-04-2018

Hej Jesper Tak for dit indlæg og for at dele Tips & Tricks - Godt eksempel på anvendelse af PROC FCMP du der giver. En anden mulighed er at benytte NLS funktionerne (National Language Support) til at både at returne korrekt ugedag (nr 3) med dansk tekst. Obs dato dk_ugedag 1 21369 onsdag Test selv med denne kode options locale=Danish_Denmark; data ugedag; dato=today(); dk_ugedag = NLDATE(dato,'%A'); run; Link til NLDATE dokumentationen, hvor der også er diverse eksempler http://go.documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=nlsref&docsetTarget=n14463ngld1umvn10fcpbo3bs26u.htm&locale=en Bemærk f.eks. forskellen mellem %u og %w

GertNissen · ‎12-01-2017

Hello everybody Welcome back to the SAS Juletip Advent Calendar - Hurray As old friends of Juletip already knows, we will post a small SAS tip each working day during December containing different Tips & Tricks using different parts of The SAS Platform. The 70 Juletip we already have posted the previous years can all be found here in Santas big Bag. Education and gaining new knowledge is always important and the Juletip is a informal way of acquiring new skills. Perhaps you have read my Blogs about staying relevant and how to learn? As always we encourage you to be active in the SAS Community - Please like tips you find useful, and comment if you have additional tips and ask questions if you need more info - everybody can pitch in with comments and answers, Regards Gert Nissen ------------------------------------- Juletip #1 - Easy generating nice Excel Sheets This tip is from a Blog by Chevell Parker and is a very good introduction to the ODS Excel Destination which generates native Microsoft Excel formatted files. This small tip is to inspire to start using the ODS Excel Destination (SAS 9.4M3) instead of Older Destinations (for example, the MSOffice2K or the ExcelXP tagsets). You will find much more info in the SAS Blogs about ODS Excel. Just copy/paste the code below and try to run it on your SAS environment (perhaps you will need to change the path) or just have a look at the attached screen shot. ods excel file="c:\temp.xlsx" options(start_at="3,3" frozen_headers="5" frozen_rowheaders="3" autofilter="1-5" sheet_name="Sales Report" row_repeat="2" embedded_titles="yes"); proc print data=sashelp.orsales; title "Sales Report for the Year 1999"; run; ods excel close; More Info: Visit Tips for Using the ODS Excel Destination for more options and explanations Link to the ODS Excel Documentation As part of your learning experience I'm sure you will learn of lot from visiting our Community dedicated to "The SAS Output Delivery System and reporting techniques" If you have read my Blog, you will see that SAS has many different offerings for learning, like: Ask The Expert, Papers etc. I have compiled an small overview here.

GertNissen · ‎11-06-2017

It will depend on your format, as there are many ways to write date, time etc with or without different details.. Have a look at http://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#p0unvzltcs191nn1ow0qhrohknz0.htm default if MDYAMPM19.

GertNissen · ‎11-03-2017

Are you looking for something like data input; format date datetime.; input date mdyampm21.2; datalines; 3/5/2017 12:00:00 AM ; run;

GertNissen · ‎10-27-2017

Hi All I have compiled a list containing some of the SAS Tips & Tricks I have shared during October. You can find a link to the list here LinkedIn - https://www.linkedin.com/feed/update/urn:li:activity:6329662572006043648 Twitter - https://twitter.com/GertNissen/status/923896343940227077 The Content is #SASNordicFANS, Networking meetings Webinars NEW SAS Learning Conference!! SAS Intro Tours SAS Tips&Tricks SAS/GRID SAS Data Integration Studio The new SAS94M5 SAS Visual Analytics SAS Enterprise Guide SAS Studio You are welcome to share these and connect with me. Regards Gert

Re: Count of specific observations by ID and Date

Re: Help understanding what is happening in this macro?

Re: Count of specific observations by ID and Date

Re: Transpose Query

Re: Creating a format from a dataset based off a range of values?

Juletip #21 - Proc SQL, other use than join

Juletip #9 - filename wildcard and origin of data

Re: Report Thumbnails / preview images - SAS VA 7.5, Windows/SMP

Report Thumbnails / preview images - SAS VA 7.5, Windows/SMP

SAS VA 7.5 - Print to PDF - very slow performance

Re: Count of specific observations by ID and Date

Re: Help understanding what is happening in this macro?

Juletip #22 Learn while having Fun!

Re: Change date format to day/month

Re: Transpose Query

Re: How to compare datetime value (02JAN2007:00:00:00)

Re: Transpose Query

Re: Creating a format from a dataset based off a range of values?

Juletip #21 - Proc SQL, other use than join

Juletip #9 - filename wildcard and origin of data

Re: Coming Soon to SAS Visual Analytics 8.4

Re: Interaction between two tables

Re: Creating Custom Category in SAS VA

Re: Error: VA 7.3 - Can't start LASR server - Authentication server er...

Re: Error: VA 7.3 - Can't start LASR server - Authentication server er...

Re: Error: VA 7.3 - Can't start LASR server - Authentication server er...

Error: VA 7.3 - Can't start LASR server - Authentication server error

New features in SAS Enterprise Guide

Juletip #1 - Finding Missing data

Re: ETL vs DATA Integration

Re: us weekday vs dk weekday

Juletip #1 - Easy generating nice Excel Sheets

Re: Datetime format

Re: Datetime format

Blog article: A collections of SAS Tips & Tricks shared on LinkedIn an...

SAS Community Nordic

SAS Analytics Explorers

SAS Global Forum 2019

SAS Global Forum 2017

SAS Global Forum 2018