Hi all   The percentn-format is a tricky one for me to understand.    Percentn10.2 where 10 is called the first parameter and 2 is called the second   I have experienced just to use a fairly wide first parameter and then specify the last parameter according to my need.    But why is that?  If I do the following:     data test2; length format $50.; length var $50.; format='percentn4.0'; var=put(0.10412456435, percentn4.0); output; format='percentn4.1'; var=put(0.10412456435, percentn4.1); output; format='percentn4.2'; var=put(0.10412456435, percentn4.2); output; format='percentn4.3'; var=put(0.10412456435, percentn4.3); output; format='percentn5.0'; var=put(0.10412456435, percentn5.0); output; format='percentn5.1'; var=put(0.10412456435, percentn5.1); output; format='percentn5.2'; var=put(0.10412456435, percentn5.2); output; format='percentn5.3'; var=put(0.10412456435, percentn5.3); output; format='percentn5.4'; var=put(0.10412456435, percentn5.4); output; format='percentn6.0'; var=put(0.10412456435, percentn6.0); output; format='percentn6.1'; var=put(0.10412456435, percentn6.1); output; format='percentn6.2'; var=put(0.10412456435, percentn6.2); output; format='percentn6.3'; var=put(0.10412456435, percentn6.3); output; format='percentn6.4'; var=put(0.10412456435, percentn6.4); output; format='percentn6.5'; var=put(0.10412456435, percentn6.5); output; format='percentn7.0'; var=put(0.10412456435, percentn7.0); output; format='percentn7.1'; var=put(0.10412456435, percentn7.1); output; format='percentn7.2'; var=put(0.10412456435, percentn7.2); output; format='percentn7.3'; var=put(0.10412456435, percentn7.3); output; format='percentn7.4'; var=put(0.10412456435, percentn7.4); output; format='percentn7.5'; var=put(0.10412456435, percentn7.5); output; format='percentn7.6'; var=put(0.10412456435, percentn7.6); output; format='percentn8.0'; var=put(0.10412456435, percentn8.0); output; RUN;   Why is percent4.0 not giving me 10% instead of *%.  I guess the dot (.) and % are included in the first parameter. But still.  The way I have come to live with it is by assuming the % consist of two dots and a slash. Then it makes sense. But I cannot be what is going on.   Can anyone help a troubled soul? ... View more

 Hi all   In Denmark everybody is given a CPR-number at birth (social security number). This is a UUID for a person.    As by GDPR we need to scan our folders regulary to find if anybody by accident has put a CPR-number in a folder that is not documented.  For the moment we would like to use SAS to do this task for us in my department.  I have thus developed a macro-function that find allmost every instance of a CPR-number in our folders. Nevertheless I would like to improve my macro function using Perl Reg Ex.      In google a colleague of mine has developed the following syntax (\W|^)([0-3])\d{1}([0-1])\d{3}[\s-_]{0,1}\d{4}(\W|$)   So a cpr contains 10 characters. The first can be between ('0','1','2','3') the third can be ('0','1'). The rest can be any character between '0' and '9'.  Sometimes a cpr-number is made of 11 characters where the 7th is a '-' (line).   I have a hard time understanding Perl Reg Ex in SAS.  Can anyone reform the abovestanding google code so it will fit in SAS. I have consultet the Tip Sheet (https://support.sas.com/rnd/base/datastep/perl_regexp/regexp-tip-sheet.pdf).    i believe I should use the prxmatch-function.    Best, Sander.    ... View more

Hi all   I am working on SAS 9.4 M3 (SYSVLONG4 = 9.04.01M3P06242015) and have encountered input data formatted with RTF formatting.  It has quite a few structures as it can origin through several different channels. So there are for me to see no quick and dirty fixes.   My data can look something like this: {\rtf1\fbidis\ansi\deff0{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}{\f1\fswiss\fprq2\fcharset0 Calibri;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1 d\ltrpar\cf1\lang1030\f0\fs22 *REAL TEXT* d\ltrpar\sa200\sl276\slmult1\cf0\f1 *REAL TEXT* d\ltrpar\cf1\f0 }   Where *REAL TEXT* indicates what I am really interested in.  Are any of you familiar with a SAS function (eg user written) or SAS MACRO that can actually do this stripping of RTF-formating?    Best, Sander Ehmsen, Denmark. ... View more