Solved: Subsetting data by minimum length of strings

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

Calcite | Level 5

Subsetting data by minimum length of strings

If I have a table like this:

Name1

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

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

Try this:

where length(varname) > 5;

Good luck.

1 REPLY 1

PROC Star

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

Try this:

where length(varname) > 5;

Good luck.

Nearly 200 sessions are now available on demand in the Innovate Hub.