topic how to repeat a value for given number of times? in SAS Programming

how to repeat a value for given number of times?

srikanthyadav44 — Thu, 05 Sep 2019 06:50:33 GMT

dear all

I have to repeat each value of a variable for ten times.

i have do it for 357 values

my data set format is as follows

companycode

comp1

comp2

comp3

………….

………

…………

comp357

required format is

companycode

comp1

comp2

please suggest me a SAS code for doing it

thanks in advance

Re: how to repeat a value for given number of times?

PeterClemmensen — Thu, 05 Sep 2019 06:52:04 GMT

Do like this 🙂

data have;
input companycode $;
datalines;
comp1
comp2
comp3
;

data want;
    set have;
    do _N_=1 to 10;
        output;
    end;
run;

Re: how to repeat a value for given number of times?

Patrick — Thu, 05 Sep 2019 07:59:25 GMT

@PeterClemmensen

I assume that you've used the automatic variable _N_ is a typo.

@srikanthyadav44 Don't use _N_ but "anything else" as name for the counter variable.

data want(drop=_i);
    set have;
    do _i=1 to 10;
        output;
    end;
run;

Re: how to repeat a value for given number of times?

PeterClemmensen — Thu, 05 Sep 2019 08:15:10 GMT

@Patrick, your assumption is incorrect. I like to use _N_ when a temporary counter variable is needed in a simple setting. If you have thoughts on the matter, I am all ears though 🙂