topic do loops in SAS Programming

do loops

Sowmya12 — Mon, 01 May 2023 15:09:11 GMT

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

Re: do loops

russt_sas — Mon, 01 May 2023 15:17:22 GMT

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;

Re: do loops

Kurt_Bremser — Mon, 01 May 2023 15:18:11 GMT

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