topic Re: Creating a Variable Based on the 4th Position of Another in SAS Programming

Creating a Variable Based on the 4th Position of Another

BCNAV — Mon, 23 Jul 2018 18:19:06 GMT

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!

Re: Creating a Variable Based on the 4th Position of Another

PaigeMiller — Mon, 23 Jul 2018 18:22:39 GMT

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=p0gq8bwobt4wjgn12km94wi66mxw.htm&locale=en

Re: Creating a Variable Based on the 4th Position of Another

novinosrin — Mon, 23 Jul 2018 18:25:42 GMT

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;

Re: Creating a Variable Based on the 4th Position of Another

SuryaKiran — Mon, 23 Jul 2018 18:41:38 GMT

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')