topic Creating variable in New SAS User

Creating variable

Amalik — Fri, 10 Jan 2020 05:32:28 GMT

Hi,

I have a variable D. Now I want to create another variable say D1 which takes the maximum value of D by each quarter.Just as below. Just unsure how to go about it in SAS

D	D1	Quarter
0	1	1
0	1	1
1	1	1
0	0	2
0	0	2
0	0	2

Re: Creating variable

PeterClemmensen — Fri, 10 Jan 2020 06:28:38 GMT

Here is one way

data have;
input D Quarter;
datalines;
0 1
0 1
1 1
0 2
0 2
0 2
0 3
2 3
1 3
;

data want;
   do until (last.Quarter);
      set have;
      by Quarter;
      if D > D1 then D1=D;
   end;
   do until (last.Quarter);
      set have;
      by Quarter;
      output;
   end;
run;

Result:

D  Quarter D1 
0  1       1 
0  1       1 
1  1       1 
0  2       0 
0  2       0 
0  2       0 
0  3       2 
2  3       2 
1  3       2

Re: Creating variable

Ksharp — Fri, 10 Jan 2020 11:56:15 GMT


proc sql;
create table want as
select *,max(d) as d1
 from have 
  group by Quarter;
quit;