SAS FILTER QUESTION

[robertrao]

Hello,

From the below character_variable I only want to pick the ones with 5 digits:

I want to eliminate the rest. Do I use Substring??

CODE_VARIABLE

10351

101

11223040

32421

10449900

[Reeza · Accepted solution]

Length() function returns the length of a string.

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

[MadhuKorni]

data Want;

input Code_Variable $;

if length(Code_Variable) eq 5;

cards;

10351

101

11223040

32421

10449900

;