BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SASPhile
Quartz | Level 8

I'm looking for help to create data like below:

Week is incremented by 5 and under each week four values (a b c d with one space from left) all in one column.

Thanks for your help.

 


week 1
 a
 b
 c
 d
week 5
a
b
c
d
...
...
week 50
a
b
c
d

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
data want;
length value $20.;
do i=0 to 50 by 5;
      value = cat("Week", put(i, 2. -l));*you may need trim;
       output;

        do value='a', 'b', 'c', 'd';
                  output;
        end;
end;

run; 

@SASPhile wrote:

I'm looking for help to create data like below:

Week is incremented by 5 and under each week four values (a b c d with one space from left) all in one column.

Thanks for your help.

 


week 1
 a
 b
 c
 d
week 5
a
b
c
d
...
...
week 50
a
b
c
d


 

View solution in original post

1 REPLY 1
Reeza
Super User
data want;
length value $20.;
do i=0 to 50 by 5;
      value = cat("Week", put(i, 2. -l));*you may need trim;
       output;

        do value='a', 'b', 'c', 'd';
                  output;
        end;
end;

run; 

@SASPhile wrote:

I'm looking for help to create data like below:

Week is incremented by 5 and under each week four values (a b c d with one space from left) all in one column.

Thanks for your help.

 


week 1
 a
 b
 c
 d
week 5
a
b
c
d
...
...
week 50
a
b
c
d