topic Re: nested array to generate a data in SAS Programming

nested array to generate a data

jiangmi — Fri, 24 Oct 2014 19:12:34 GMT

I need generate a data like this:

month	qtr	semi_year	year
1	1	1	1
2	1	1	1
3	1	1	1
4	2	1	1
5	2	1	1
6	2	1	1
7	3	2	1
8	3	2	1
9	3	2	1
10	4	2	1
11	4	2	1
12	4	2	1
13	5	3	2
14	5	3	2
15	5	3	2
16	6	3	2
17	6	3	2
18	6	3	2
19	7	4	2

the total number of 'month' may vary (19 in this case).

the data has a pattern, which assign the 'month' into ordered 'qtr', 'semi_year', and 'year' variables.

I am think a good nested array can take care of it. I don't have it, but I am working on it.

I also welcome other suggestions or better solution.

Thanks.

Re: nested array to generate a data

ballardw — Fri, 24 Oct 2014 19:57:51 GMT

No arrays needed:

data want;

do month = 1 to 19;

qtr= ceil( month/3) ;

semi_year = ceil(month/6);

year = ceil( month/12);

output;

end;

run;

Re: nested array to generate a data

jiangmi — Fri, 24 Oct 2014 20:03:35 GMT

Hi, ballardw,

You made it look so easy.

I learned sth new.

Thank you.

Joe

Re: nested array to generate a data

ballardw — Fri, 24 Oct 2014 20:05:25 GMT

When you've been doing this for 30 years you'll recognize some patterns/solutions quickly also.

Re: nested array to generate a data

jiangmi — Fri, 24 Oct 2014 20:51:31 GMT

Hi, I have some follow_up questions.

I am trying to put it in a macro, don't know why it is not working.

Can somebody offer some suggestions?

Thanks.

%macro one;

data want;

%do month = 1 %to 19;

qtr= (ceil( month/3)) ;

semi_year= (ceil(month/6));

year= (ceil( month/12));

output;

%end;

run;

%mend;

%one;

Re: nested array to generate a data

ballardw — Fri, 24 Oct 2014 21:10:57 GMT

If you put:

options mprint;

before the macro code you should see that you are generating the lines in the %do / %end loop 19 times without change. And probably getting all missing values for output as the dataset variable month is undefined, hence missing, and missing/anything results in missing values.

Re: nested array to generate a data

Reeza — Fri, 24 Oct 2014 21:11:58 GMT

You don't need %do/%to in a data step you can use the regular ones do/to.

I'm gonna guess the following is what you're after:

%macro one(num_months);

data want;

do month = 1 to &num_months;

qtr= (ceil( month/3)) ;

semi_year= (ceil(month/6));

year= (ceil( month/12));

output;

end;

run;

%mend;

%one(19);

Re: nested array to generate a data

jiangmi — Fri, 24 Oct 2014 21:35:11 GMT

Thank you all.

I got it now.