Create a numeric list with end value determined by another variable

mariapf — Mon, 18 Jul 2022 09:03:08 GMT

Hi all,

I have a problem creating a variable that I think can be solved using some sort of loop but I don't know how to code it. I have an input dataset with information about mortgages, including the maturity for each one. I need to create a variable called year, that creates a line for each year from 0 to maturity for each contract. Therefore, the output dataset will have as many lines as contracts times (maturity +1, accounting for the zeroes). Below I set an example of my input and my expected output, so that it is easier to understand:

Input

CONTRACT_ID	PD	INDUSTRY	MATURITY
13000	0,45	construction	3
12400	0,09	retail	5
37000	0,023	tech	2

Desired output

CONTRACT_ID	PD	INDUSTRY	MATURITY	YEAR
13000	0,45	construction	3	0
13000	0,45	construction	3	1
13000	0,45	construction	3	2
13000	0,45	construction	3	3
12400	0,09	retail	5	0
12400	0,09	retail	5	1
12400	0,09	retail	5	2
12400	0,09	retail	5	3
12400	0,09	retail	5	4
12400	0,09	retail	5	5
37000	0,023	tech	2	0
37000	0,023	tech	2	1
37000	0,023	tech	2	2

Re: Create a numeric list with end value determined by another variable

PaigeMiller — Mon, 18 Jul 2022 09:51:15 GMT

data want;
    set have;
    do year=0 to maturity;
        output;
    end;
run;

Re: Create a numeric list with end value determined by another variable

mariapf — Mon, 18 Jul 2022 11:33:54 GMT

This has worked perfectly, thank you so much for your time!

topic Create a numeric list with end value determined by another variable in SAS Programming

Create a numeric list with end value determined by another variable

Re: Create a numeric list with end value determined by another variable

Re: Create a numeric list with end value determined by another variable