Help using Base SAS procedures

how to add with in year and company?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 102
Accepted Solution

how to add with in year and company?

I have ned_1 which is a binary variable if

boardid       year     ned_1

1                  2000   0

1               2000     1

1               2001      1

1               2001     1

1               2002     0

1               2002    0

2            2000     0

2            2000     0

2           2001     1

3           2002    1

3          2002     1

i want to arrive at

boardid      year     ned_1

1                2000         1

1               2001          2

1               2002          0

2               2000     0    

2          2001          1

3          2002          2

how may i do this? thank you in advance!


Accepted Solutions
Solution
‎04-24-2014 12:19 PM
Respected Advisor
Posts: 3,156

Re: how to add with in year and company?

proc sql;

  select boardid, year, sum(ned_1=1) as ned_1 from have

        group by boardid, year

;

quit;

Not tested.

Haikuo

View solution in original post


All Replies
PROC Star
Posts: 7,473

Re: how to add with in year and company?

I would use proc summary:

proc summary data=have;

  var ned_1;

  by boardid year;

  output out=want (drop=_Smiley Happy sum=;

run;

Super User
Posts: 19,792

Re: how to add with in year and company?

It helps to provide the logic, so we don't have to make assumptions.

Assuming ned_1 in your want table is the sum of the ned_1 in the first table.

Look into proc means to summarize your information.

Solution
‎04-24-2014 12:19 PM
Respected Advisor
Posts: 3,156

Re: how to add with in year and company?

proc sql;

  select boardid, year, sum(ned_1=1) as ned_1 from have

        group by boardid, year

;

quit;

Not tested.

Haikuo

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 170 views
  • 3 likes
  • 4 in conversation