Hi,   I got a datasæt with many rows and a char variable with content of a list of numbers separated by :   41:31: 53:52:32:33:34:35:36:54:53:52:51:61:48:47:46:45:61:62   I need to count and sum the number of specific numbers to create a classification as this:   Group1 when number is in(48,47,46,45,44,43,42,41,31,32,33,34,35,36) and I need to sum the found number of string   Group2 when number is in(55,54,53,52,51,61,62,63,64,) and I need to sum the found number of string   So the result is Group1=11 and Group2=7   Any ideas how to do it ?   Thanks in advance. ... View more

We are asked to create input to a SIEM system in order to expand the security level.   1. Do you have any experience in that manner? let us know more ? 2. Any good ideas for how to start to feed to SIEM are welcome. 2. I suppose that SAS has a ton of logs but they are difficult to anayze from raw text? 3. If we turn on the APM a lot of relevant stuff is available but how can that information be integrated with a SIEM system ? ODBC?   Any ideas and experience are highly appreciated.   Thanks in advance. Look forward to hear from you. ... View more

Hi, I am dealing with a dataset which has a field containing a so-called EDIFACT message. It menas a long streng containing different inormation. I want to parse and divide the long text string into sas variables. This should be based on char string characters - se example below.   Any ideas or code to a nice and easy solution from SAS???   Thanks in advance,    Input data: one long string   NAD+PERSONnumber+3456789010'DTM+091:170126:101'NAD+ENTITY+027'NAD+KLA+11' NAD+YNR+'NAD+MOK+405'TAF+55:45:53:52:51:61:62:63:64:65:85:84:83:82:81:71:72:73:74:75' TOB+85:OKK:0'TOB+75:OKK:0’TOB+63:MES:4'QTY+DYB:X'   I want to create these new variables: PERSONnumber=3456789010 DTM=091:170126 ENTITY=027 KLA=11 YNR=+ MOK=405 TAF=55:45:53:52:51:61:62:63:64:65:85:84:83:82:81:71:72:73:74:75' TOB85=OKK:0 TOB75=OKK:0 TOB63= MES:4'QTY+DYB:X'   ... View more