Character function

[Ajayvit]

data code2;
input country$ 10.;
datalines;
IndiaIN
AmericaAM
IndiaIN
canadaCA
FranceFR
IndiaIN
;
run;
proc print data=code;
run;

data test4;
set code2;
Position=find(country,"IN");
/*am=find(country,"AM"); */
/*ca=find(country,"CA");
fr=find(country,"FR");*/
Ccode=substr(country,Position);
run;

expecting all country code under Ccode variable.

[novinosrin · Accepted solution]

Hi @Ajayvit 

Are you asking for 

data code2;
input country$ 10.;
datalines;
IndiaIN
AmericaAM
IndiaIN
canadaCA
FranceFR
IndiaIN
;
run;


data test4;
set code2;
Ccode=substr(country,length(country)-2+1);
run;

 Or

Ccode=substr(country,length(country)-1);

[Ajayvit]

Dear,

Thank you for your reply. I am getting same o/p what i was expecting.

[Tom]

Do all of the values have the country code as the last two characters?

code = substr(country,length(country)-1);
country=substr(country,1,length(country)-2);

Or do you need to hunt for them?

[Reeza]

Are you sure you don't have a delimiter? Can you view the file in NotePad++ and show a screenshot with invisible characters shown? It would be bad practice to store data like, not that it hasn't happened before, but it's so bad that I would expect a different approach to be available.

[Ajayvit]

Dear Reeza,

Thank you for replying.
None of the observation is having delimiter.