在 SAS 中使用多个分隔符拆分字符串 [英] split string with multiple delimeters in SAS

问题描述

如何在 SAS 中将以下字符串(多个分隔符)拆分为单独的列?

How to split the below string (multiple delimeters) into seperate columns in SAS?

[拦截]-2[/拦截] [国家]我的[/国家][LOG_AMT]0.2354[/LOG_AMT] [BETAX]-11.08325[/BETAX]

[INTERCEPT]-2[/INTERCEPT] [COUNTRY]MY[/COUNTRY] [LOG_AMT]0.2354[/LOG_AMT] [BETAX]-11.08325[/BETAX]

> INTERCEPT  COUNTRY   LOG_AMT     BETAX
> -2           MY       0.2354    -11.08325

推荐答案

执行此操作的简单方法是通过使用 @@ 和分隔符作为 '[' 读取来生成键值对.使用 proc transpose 生成键值对后，您可以生成完全相同的结果.这样，如果将来添加更多的属性值对，代码仍然能够完美地生成结果.查看下面的代码.

Simple way of doing this would be generate a key value pair by reading using @@ and delimiter as '['. After key value pair is generated using proc transpose you can generate the exact same result. This way if in future something more is property-value pair are added the code would still be able to generate the result perfectly. Check the out the below code.

data have;
length key value $ 20.;
retain key ' ';
retain group 1;
infile datalines dlm=']' ;
    input text :$char20. @@;
    key=lag(text);
    if find(text,'[/') then do;
        key=scan(key,2,'[','mo');
        value=scan(text,1,'[');
        output;
    end;
    drop text;
datalines;
[INTERCEPT]-2[/INTERCEPT] [COUNTRY]MY[/COUNTRY] [LOG_AMT]0.2354[/LOG_AMT] [BETAX]-11.08325[/BETAX]
;;;;
run;
proc transpose data=have out=want(drop=group _name_);
    by group;
    var value;
    id key;
    idlabel key;
run;
proc print data=want;run;

就我个人而言，我更喜欢使用 sas perl 正则表达式来破坏键值对中的属性/值.您也可以考虑将属性/值分解为键值对.

Personally, I prefer using sas perl regular expression for breaking properties/value in key value pair. You could look into as well for breaking properties/value into key value pair.

这篇关于在 SAS 中使用多个分隔符拆分字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！