do loops

[Sowmya12]

visit
week1
week2
week3
week4
week5

new variable days should be created and values in days are multiples of 7
week1 day=7
week2 day=14
week3 day=21 etc.,

The output should be

visit       days
week1     7
week2     14
week3     21
week4     28
week5     35

week1      7

week2      14

week3      21

[russt_sas]

If they are always in order you could do something like this:

data one;
input visit $;
cards;
week1
week2
week3
week4
week5
week1
week2
week3
;

data new;
set one;
if visit='week1' then days=7;
else days+7;
run;

proc print;
run;

[Kurt_Bremser]

day = input(substr(visit,5),best.) * 7;