The SAS Output Delivery System and reporting techniques

Scan malfunction

Accepted Solution Solved
Reply
Contributor
Posts: 45
Accepted Solution

Scan malfunction

Good afternoon,

I am trying to scan a few words and I am having troubles with the scan function. I am having the following data set and I would like to create a new variable with the country name.

Sal_Plan_Descr
Angola Salary Structure
Armenia Salary Structure
Benin Salary Structure
Burkina Faso Salary Structure

I would like to get

CountrySal_Plan_Descr
AngolaAngola Salary Structure
ArmeniaArmenia Salary Structure
BeninBenin Salary Structure
Burkina FasoBurkina Faso Salary Structure

Since Burkina Faso has two words, I used the following scan function: Country=scan(Sal_Plan_Descr, 1, 'Salary'); so that I get the entire name of the country. However, I get this:

CountrySal_Plan_Descr
AngolaAngola Salary Structure
AArmenia Salary Structure
BBenin Salary Structure
BBurkina Faso Salary Structure

Do you know why the scan function does not cooperate?

Thanks!


Accepted Solutions
Solution
‎05-14-2014 02:50 PM
Respected Advisor
Posts: 4,932

Re: Scan malfunction

The third argument to the SCAN function is a list of characters that may separate words. It is not a word to search for.

Try

Country= substr(Sal_Plan_Descr, 1, findw(Sal_Plan_Descr, 'Salary') - 1);


instead.


PG

PG

View solution in original post


All Replies
Solution
‎05-14-2014 02:50 PM
Respected Advisor
Posts: 4,932

Re: Scan malfunction

The third argument to the SCAN function is a list of characters that may separate words. It is not a word to search for.

Try

Country= substr(Sal_Plan_Descr, 1, findw(Sal_Plan_Descr, 'Salary') - 1);


instead.


PG

PG
Contributor
Posts: 45

Re: Scan malfunction

It worked!

Thank you Smiley Happy

Super User
Posts: 10,044

Re: Scan malfunction

tranwrd(x,'Salary Structure','');

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 415 views
  • 3 likes
  • 3 in conversation