topic Character function in SAS Programming

Character function

Ajayvit — Wed, 22 May 2019 17:23:38 GMT

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.

Re: Character function

novinosrin — Wed, 22 May 2019 17:30:11 GMT

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;

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

Re: Character function

Tom — Wed, 22 May 2019 17:58:19 GMT

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?

Re: Character function

Reeza — Wed, 22 May 2019 18:28:43 GMT

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.

Re: Character function

Ajayvit — Thu, 23 May 2019 00:29:43 GMT

Dear Reeza,

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

Re: Character function

Ajayvit — Thu, 23 May 2019 00:34:43 GMT

Dear,

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