topic Re: assign 1 to the variable Spacec when the value for country contains at least one space in SAS Programming

assign 1 to the variable Spacec when the value for country contains at least one space

elsalam — Mon, 16 Apr 2018 17:04:38 GMT

Input country & $16. Team year;

run;

How to get the value 1 for the country that has at least one space?

Thx



novinosrin — Mon, 16 Apr 2018 17:13:10 GMT

value= index(strip(country),' ')>0;
/*for 1,0 binary results*/

if index(strip(country),' ')>0;

if index(strip(country),' ')>0;

elsalam — Mon, 16 Apr 2018 17:53:46 GMT

Thank you so much for the prompt response. is work

Andygray — Mon, 16 Apr 2018 18:50:08 GMT

The documentation above explains what index does

Did it work. If yes, you could mark the question as answered and accepted to close the thread.