Solved: Subsetting data by minimum length of strings - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

Subsetting data by minimum length of strings

Posted 07-13-2015 04:43 PM (799 views)

If I have a table like this:

Name1

A

AB

ABC

ABCD

ABCDE

ABCDEF

ABCDEFG

ABCDEFGH

How can I write a command to just subset the observations that have 6 or more characters in the string?

1 ACCEPTED SOLUTION

Accepted Solutions

PROC Star

Re: Subsetting data by minimum length of strings

Posted 07-13-2015 05:04 PM (890 views) | In reply to SASbeginner20

Try this:

where length(varname) > 5;

Good luck.

View solution in original post

1 REPLY 1

PROC Star

Re: Subsetting data by minimum length of strings

Posted 07-13-2015 05:04 PM (891 views) | In reply to SASbeginner20

Try this:

where length(varname) > 5;

Good luck.