About DJongman

DJongman

By default, cas libraries will not be shown. First you will need to set up a cas session. cas; (this line creates a cas session named casauto.) Also note that the standard selected cas-library is casuser. You can change this with options and or parameters The CAS libraries are not yet displayed. Use the following code to assign all available cas - libraries caslib _all_ assign; this line assignes all available cas - libraries After that, you can load data into cas with proc casutil.

DJongman · ‎11-15-2022

See https://www.youtube.com/watch?v=vkI0mysfAkQ for an example how to create a custom step and add it to a flow

DJongman · ‎11-14-2022

Custom steps can be added to a flow: How to make a custom step: https://documentation.sas.com/doc/en/webeditorcdc/v_017LTS/webeditorsteps/n1am9lk9ec29lyn1cuplosqq60d7.htm From the documentation: Note: The Custom Step functionality is available only if your site licenses SAS Studio Analyst or SAS Studio Engineer. Custom steps are not available in the Interactive perspective. What Version of SAS Studio Are You Running? https://documentation.sas.com/doc/en/webeditorcdc/v_024/webeditorag/p14ailcd9ouczan1pph34bgl84b6.htm

DJongman · ‎04-22-2022

Something like this? proc sql; create table want as select id_number, count(*) as count_of_different_names_used from have group by id_number order by count_of_different_names_used desc; quit;

DJongman · ‎01-10-2022

https://www.sas.com/nl_nl/certification/training-exam-preparation.html

DJongman · ‎11-17-2021

https://communities.sas.com/t5/SAS-Programming/Convert-XPT-to-SAS-Datasets/td-p/97872 Should give you a direction.

DJongman · ‎11-16-2021

Above your code you see a number of variables, including an _output variable, which refers to a work table name. If you replace the table name 'bankdays' in your code with &_output, DI will create a table.

DJongman · ‎10-13-2021

Hi all, I was wondering how the option 'base font' in the SAS theme designer is related to the table font size in VA? I am asking this, because I can't find any reference in documentation regarding this online. It seems that, when base font size 16px is selected, the list and cross table are set to 11 px in VA. And when the theme base font size is being changed to 15px the table font size in VA is now 10px. It's always a difference of 5, with the lowest font size of 7px. So lower then 12px will always give a 7px on the table font size. The above tested in: - VA 8.5.2 - Theme designer version 3.4 - VA 7.5 - Theme designer version 5.1 Question: Is there an overview of the relation between the 'theme base font size' and all VA visuals somewhere out there? Thanks in advance, Daniël

DJongman · ‎06-04-2021

When upgrading we normally delete next files, All logs and files wil be recreated after starting services. (Also, if something is occurring, log-files are smaller to read) stop all services. Remove in directory: /srv/SASConfig/Lev1/Web/gemfire/instances/ins_41415 the next files - gemfire.log - locator41415state.dat - locator41415views.log /srv/SASConfig/Lev1/Web/activemq/data (remove all files, but keep subdirectories) In all the directories: /srv/SASConfig/Lev/Web/Webappserver/SASServer*/logs remove files: - catalina.out - server.log - gemfire.log then restart all services

DJongman · ‎03-12-2021

You could try: https://communities.sas.com/t5/SAS-Data-Management/Importing-multiple-Excel-sheets/td-p/296480

DJongman · ‎03-12-2021

Maybe this link will provide the answer: https://www.lexjansen.com/nesug/nesug12/cc/cc37.pdf

DJongman · ‎12-09-2020

Hi Petri, First thanks for thinking along. The outcome you sketch is correct. However, what I'm running into this: If you link a list-filter to the table and select for example 5 customers. In that case, the weighting is not correct (should always be 1) and therefore the KPI weight is not correct either. That's the problem for me. I get everything done, but not completely in 1 table. In other words, whether all values are good, with the exception of the total of KPI weight, or KPI weight is good and all other values are incorrect. Thanks in advance, Daniël

DJongman · ‎12-07-2020

Hi all, I am struggling with the next problem, and hoping somebody can give me a little direction: Trying to convert the next Excel sheet (example) to a SAS VA report (ListTable): Next calculations are being done in Excel: KPI = Sales/Plan (for example: =+C3/B3) Weighting = Sales cell / Total of Sales (for example: =+C3/$C$9) KPI Weighting = KPI cell * Weighting cell (for example: =+D3*E3) Total is sum of row, except the column KPI. This is average: In VA, Imported the data and created a list table: All is working correctly: Sum of sales is correct. KPI avg is correct (gemiddelde = 81%) Total of Weighting is correct. This should always be 1, if an customer filter is added for example, and a selection is made. (works fine) But, the KPI weight is on cell level correct. But the total is incorrect. This should be 84% and not 406% I know that he is doing in the background a calculation of a total of KPI * weighting = 406% * 1 = 406%. But how can I change this? So the total of the column KPI Weight is not 406, but 84% Tried several calculations (Table an Aggregated table options), but I am stuck on this issue. Hope that someone can help me out. Thanks in advance, Daniël

DJongman · ‎08-17-2020

Hi Tinker_, Check the link: https://documentation.sas.com/?docsetId=vareportdata&docsetTarget=p1j6doowaalx5gn16scudw2wk0jj.htm&docsetVersion=8.5&locale=en Detailed info is given how to create custom ranking in a SAS VA report. Daniël

DJongman · ‎09-02-2019

Hi mkrisz, Tested your code and it seems that the path is incorrect. Change to: libname out "s:\workshop\output\"; Note that the directory 's:\workshop\output\' must be available on the server.

Online Status	Offline
Date Last Visited	yesterday

Re: SAS Studio access to tables on server

Re: How to customize custom steps on SAS Viya SAS Studio

Re: How to customize custom steps on SAS Viya SAS Studio

Re: Counting values per i.d

Re: Can't Find List of Updates for the book 'SAS certified professiona...

Re: How to convert XPT files to sas datasets ?

Re: User written code in SAS DI - no results

Theme designer base font size related to table (list or cross) font si...

Re: Upgraded SAS 9.4 M3 to M7 but now services are not getting UP

Re: how to read xls file sheet names and keep in one dataset

Re: SAS Studio access to tables on server

Re: Create a Filter for top x values - like schoolkids according to th...

Re: Programming 1 error when running p102d01.sas

Re: SUM of column

Re: Importing previous day Excel file with date Macro

Re: SAS Studio access to tables on server

Re: How to customize custom steps on SAS Viya SAS Studio

Re: How to customize custom steps on SAS Viya SAS Studio

Re: Counting values per i.d

Re: Can't Find List of Updates for the book 'SAS certified professiona...

Re: How to convert XPT files to sas datasets ?

Re: User written code in SAS DI - no results

Theme designer base font size related to table (list or cross) font si...

Re: Upgraded SAS 9.4 M3 to M7 but now services are not getting UP

Re: how to read xls file sheet names and keep in one dataset

Re: how to read xls file sheet names and keep in one dataset

Re: [VA] - tabel, calculations. how to solve

[VA] - tabel, calculations. how to solve

Re: Create a Filter for top x values - like schoolkids according to th...

Re: Programming 1 error when running p102d01.sas

SAS Analytics Explorers