topic Separating string in New SAS User

Separating string

lioradam — Tue, 18 Oct 2022 12:04:41 GMT

Hello,

I have variables with observations in different lengths as 000R201806, ZY201906

and I want to separate it into the letters (or digits) at the beginning of the string, the year, and the month:

000R 2018 04

ZY 2019 06

What code can I use?

Thank you,

Lior

Re: Separating string

PaigeMiller — Tue, 18 Oct 2022 12:13:16 GMT

Always two digits for the month, four digits for the year, and the rest is the 'beginning of the string'?

Re: Separating string

Tom — Tue, 18 Oct 2022 12:15:00 GMT

@lioradam wrote:

Hello,

I have variables with observations in different lengths as 000R201806, ZY201906

and I want to separate it into the letters (or digits) at the beginning of the string, the year, and the month:

000R 2018 04

ZY 2019 06

What code can I use?

Thank you,

Lior

SUBSTR().

Note that it might be simpler to just create a DATE value instead of separate YEAR and MONTH values.

data have;
  input string $20.;
cards;
000R201806
ZY201906
;

data want;
  set have;
  date = input(substrn(string,length(string)-5),yymmn6.);
  format date yymmdd10.;
  short_string=substr(string,1,length(string)-6);
  year=year(date);
  month=month(date);
run;

Result:

                                   short_
Obs      string            date    string    year    month

 1     000R201806    2018-06-01     000R     2018      6
 2     ZY201906      2019-06-01     ZY       2019      6

Re: Separating string

lioradam — Tue, 18 Oct 2022 12:36:58 GMT

Yes

Re: Separating string

PaigeMiller — Tue, 18 Oct 2022 12:42:33 GMT

Looks like @Tom beat me to it, but really you just need the length of the string, and then the last 6 characters are the year/month, and the rest are the "beginning of the string".

Re: Separating string

lioradam — Tue, 18 Oct 2022 19:20:34 GMT

Thank you very much!

Regards,

Lior

Re: Separating string

lioradam — Tue, 18 Oct 2022 19:22:27 GMT

Thank you 👍