Creating a Variable Based on the 4th Position of Another

[BCNAV]

For flights in our airspace, we assign a flight an ACID.

Examples: ACA690, FVWT, ENY3356, FCHC (there are always at least 4 characters)

What I need to do is to go to the 4th position and assess if it is numeric or a character. If it is numeric, I want to grab the first three characters of the ACID and dump it into the variable iacocode. If the 4th position character is not numeric, then assign icaocode to be "UKN".

For so ACA690, icaocode would be "ACA", for FVWT it would be "UKN"

Thanks!

[PaigeMiller]

You can use the ANYDIGIT function to determine whether or not the character is numeric or not.

http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=lefunctionsref&docsetTarget=p0...

[novinosrin · Accepted solution]

data have;
input var $10.;
cards;
ACA690
FVWT
ENY3356
FCHC
;

data want;
set have;
iacocode=ifc(anydigit(char(var,4))>0,substr(var,1,3),"UKN");
run;

[SuryaKiran]

You can also use COMPRESS function to identify numeric and characters in a string.

ifc(missing(compress(substr(var,4,1),,'d')),substr(var,1,3),'UNK')