topic Re: Do loops in SAS Programming

Do loops

112211 — Fri, 11 Aug 2023 10:19:44 GMT

Data do;
A= 'United States of America ';
Run ;

I need output like reverse words below mentioned (preferably use do loops 😞
America of states united

Re: Do loops

PaigeMiller — Fri, 11 Aug 2023 10:51:29 GMT

Use the REVERSE function, no loops needed

data want;
    set do;
    reverse_A=reverse(A);
run;

Re: Do loops

maguiremq — Fri, 11 Aug 2023 11:42:32 GMT

Hi @112211, I didn't see your desired output until now.

data want (drop = i);
length a_want $50.; /* Needs to be set depending on output */
a = "United States of America";
do i = countw(a, " ") to 1 by -1;
a_want = catx(" ", a_want, scan(a, i, " "));
end;
run;

Basically, your loop starts at 4 because COUNTW finds four words. I use the by -1 to go from 4 --> 3 --> 2 -- 1.

CATX then combines each word with the DO loop.