Hi,   I would like to do the MYSQL of Groupconcat and also I would like to count the number of occurrences.   So far I got this:   data PLATFORMS; input ORDERID $ PLATFORM $; CARDS; A ZXO B ZXO C EXP D ZXO D EXP ; run; data INVOLVED_PLATFORMS (drop=PLATFORM_old); set PLATFORMS (rename=(PLATFORM=PLATFORM_old)); by ORDERID; retain PLATFORM; length PLATFORM $ 64; if first.ORDERID then PLATFORM = ''; PLATFORM = catx(' ',trim(PLATFORM),PLATFORM_old); if first.ORDERID then count = 0; count = count + 1; if last.ORDERID then output; run; I think I am halfway there, but I cant figure out why count is empty in the 4th row. It should be "2".   Thank you very much!   Dirk ... View more

Hi,   I just set up autoload in VA. I followed this guide: https://blogs.sas.com/content/sgf/2016/04/04/sas-visual-analytics-autoload-configuration-made-easy/   I can put tables into folders and they will be loaded into my Public LASR Library. So far so good, but the table is put in the wrong metadata folder.   How do I control the folder location?   I marked the table in yellow and it should be put in the red underlined folder.   Thanks and regards Dir ... View more

Hi, I m trying to do this:   data temp; infile datalines; input datum : DATE10. value1 COMMAX12.2 value2 COMMAX12.2 value3 COMMAX12.2 value4 COMMAX12.2; datalines; 01.11.2017 366.020,57 273.972,60 83942020,57 83,94 ; run; But I am not able to read the correct date.   Can someone help me out please?   Thanks! Dirk ... View more

Hi, I need a user defined format and I never used PROC Format before and I am a bit lost here.   I need a format like this:   Input Value: 0.571 Output Value: +/+ 57,1%   Input Value: -1.3 Output Value: -/- 130%   This is what I got so far:   Data numbers; input values; cards; 0.1119 0.2119 0.57119 -0.5134 2 40 -5 ; run; proc format; picture advperc low -< 0 = '99.99 %' (prefix='-/- ' mult=10000) 0 - high = '99.99 %' (prefix='+/+ ' mult=10000); run; proc print data = numbers; format values advperc.; run;   I m not quite there yet. The last 3 lines are not right.   Thank you in advance Dirk  ... View more