Do loops

[112211]

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

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

[PaigeMiller]

Use the REVERSE function, no loops needed

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

[maguiremq · Accepted solution]

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.