topic Re: find the number of characters in SAS Programming

find the number of characters

JNWong — Tue, 07 Feb 2017 04:20:21 GMT

HI,

i am wondring if exists a function to count the number of character variable,not just the times which 'a refered character' appered.

variable values like '' for'' ''at'' ''in'' and so on.as I have defined the length is 500,so there exists a lot of blanks ,i may try to use the compress function or strip,but it not works out.

Thank you!

Re: find the number of characters

mkeintz — Tue, 07 Feb 2017 04:36:23 GMT

The LENGTH function, as in

len1=length(myvar)

provides the position of the rightmost non-blank character.

len2=length(left(myvar))

does the same after left-justifying myvar.

And

len3=length(compress(myvar,' ',''));

counts only the non-blanks.

Re: find the number of characters

JNWong — Tue, 07 Feb 2017 05:02:34 GMT

thanks for your answers.sorry for another question
i use the length function to extract a string of characters indeed.

code like: food=substr(name,find(name,var1,'i')+length(var1),32)，the variable 'name' includes the character value'var1'
but i can not get the right result.

thank you

Re: find the number of characters

art297 — Tue, 07 Feb 2017 05:27:18 GMT

It would help if you provide example values of both the variables 'name' and 'var1' and what you want the value of food to be based on those values.

Art, CEO, AnalystFinder.com

Re: find the number of characters

JNWong — Tue, 07 Feb 2017 05:59:03 GMT

thank you!

as the 'name' variable like:

iphone 6 will be launched on Nov.11 2015

ipad mini has been introduced in Japan

var1 like;

it is just the prep in the 'name' variable.i have reverse them like'no' 'ni', var2 = reverse(var1)

i want to extract the 'iphone' and 'ipad mini',and i have reverse the characters for substr functon.name1 = reverse(name)

so i use the substr like 'product = substr(name1,find(name1,var2,'i')+length(var2),32)

athough i may not get it by one step for the other components like 'has been',

i just want to get 'iphone 6 will be launched'. and take other steps to drop the components 'will be launched'

thank you!

Re: find the number of characters

JNWong — Tue, 07 Feb 2017 06:54:27 GMT

i have solved my problems

it seems like i have misunderstood the length of var2.

under some circumstances,it is better to use the trim function.

Re: find the number of characters

RW9 — Tue, 07 Feb 2017 09:28:28 GMT

Two things. When posting a question post test data in the form of a datastep so that we can see the full picture.

Secondly, there is a function called lengthn. The reason for using this function is to return the number of characters of a string with trim already done. I.e.

length(trim(<variable>))

Is the same as:

lengthn(<variable>)

Re: find the number of characters

JNWong — Tue, 07 Feb 2017 10:10:41 GMT

ok.i have got it.thanks for your help.

Re: find the number of characters

art297 — Tue, 07 Feb 2017 15:40:54 GMT

It's definitely useful to discover how the length and lengthn functions work, but I think you're going about solving your problem in a round about way. I'd use the findw function. e.g.,

data have;
  input @;
  name=_infile_;
cards;
iphone 6 will be launched on Nov.11 2015
ipad mini has been introduced in Japan
;

data want;
  set have;
  
  /* if you want make/model*/
  makemodel=substr(name,1,
             min(ifn(findw(name,'will',' ','s') eq 0,.,findw(name,'will',' ','s')),
                 ifn(findw(name,'has',' ','s') eq 0,.,findw(name,'has',' ','s')))-1);

  /* if you want everything before var1*/
  action=substr(name,1,
             min(ifn(findw(name,'on',' ','bs') eq 0,.,findw(name,'on',' ','bs')),
                 ifn(findw(name,'in',' ','bs') eq 0,.,findw(name,'in',' ','bs')))-1);
run;

HTH,

Art, CEO, AnalystFinder.com