topic Re: Substr function returns wrong result in SAS Programming

Substr function returns wrong result

sfmeier — Tue, 08 May 2012 12:14:51 GMT

Dear experts,

in a DATA step I am using the substr function on a $10. formatted variable that contains numbers.The numbers begin with 5, however substr(variable,1,1) returns 6 :smileyalert:

How can I make it work?

Thank you,

Stefan

Re: Substr function returns wrong result

Linlin — Tue, 08 May 2012 12:30:12 GMT

please post a few observations from your dataset.

Re: Substr function returns wrong result

sfmeier — Tue, 08 May 2012 13:17:33 GMT

Here u go! Like this? RT_Kusy RT_RespOrg substr_rt_kusy SG_WP 52102007 BBO_I_P 6 1 52102007 BBO_I_P 6 1 52102007 BBO_I_P 6 1 52102007 BBO_T_P 6 1 52102011 BBO_I_P 6 1 52102007 BBO_T_P_CV 6 1 52100011 BBO_T_P 6 1 52102007 BBO_I_P 6 1 52100011 BBO_I_P 6 1 52100011 BBO_I_P 6 1 52102007 BBO_I_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_I_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_I_P 6 1 52102007 BBO_I_P 6 1 52102007 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_T_P 6 1 52100011 BBO_I_P 6 1 52102007 BBO_I_P 6 1 50102008 BBO_T_P 6 1 52102007 BBO_T_P 6 1

Re: Substr function returns wrong result

art297 — Tue, 08 May 2012 13:43:41 GMT

You will have to show the code you are using to input the data and the code you are using to incorporate the substr function. It appears like you are only declaring four fields, but either have five fields or one that includes space separated data.

Re: Substr function returns wrong result

sfmeier — Tue, 08 May 2012 14:54:40 GMT

Ups, I just found my error myself, thx anyway!