topic Re: how to get the last two words using scan function in SAS in SAS Programming

how to get the last two words using scan function in SAS

Aayushi_17 — Fri, 18 Oct 2019 04:47:11 GMT

how to get the last two words using scan function in SAS?

if i have visit as

Visit 2 Week 4

Visit 12 Week 42

visit 1 day 1

visit 16 week 52

i want the ouptut as

Week 4

Week 42

Week 52

Thanks in advance

Re: how to get the last two words using scan function in SAS

PeterClemmensen — Fri, 18 Oct 2019 05:00:17 GMT

With Scan Function:

data have;
input string $ 1-20;
datalines;
Visit 2 Week 4
Visit 12 Week 42
visit 1 day 1
visit 16 week 52
;

data want;
   set have;
   lasttwo=cat(scan(string, -1), ' ', scan(string, -2));
run;

Result:

string             lasttwo 
Visit 2 Week 4     Week 4 
Visit 12 Week 42   Week 42 
visit 1 day 1      day 1 
visit 16 week 52   week 52

Re: how to get the last two words using scan function in SAS

andreas_lds — Fri, 18 Oct 2019 05:39:35 GMT

@Aayushi_17 wrote:

how to get the last two words using scan function in SAS?

if i have visit as

Visit 2 Week 4

Visit 12 Week 42

visit 1 day 1

visit 16 week 52

i want the ouptut as

Week 4

Week 42

????

Week 52

Thanks in advance

So you want output only if the value contains the word week? Or why is the fourth line empty?