Counting how many times between dates

[nimedina]

Hello,

I have some two problems asking as followed while using SAS.

1. To find out how many times for each year.

2. To find out how many times after JAN202017. 

1. How many of tweets has Mr. President made each year (give total number tweets for each year?)
2. How many of tweets has Mr. President made after he became president (find this date online)? *(JAN.20.2017)

The data set is as followed in the photo (not the full data set shown).

Source                                 Text                          Date                       Time                       Retweet_count

Twitter for iphone           Goodmorning...     24MAR2019                 12:01:44                        76002

Twitter for iphone           .....................         24MAR2019                 12:01:44                        76002

Twitter for iphone           ......................        24MAR2019                 12:01:44                        76002

[andreas_lds]

For the fist question: do you want to specify the year, or do you need the number for each year you have?

For the later try:

proc summary data=have nway;
  class Date;
  format Date year4.;
  output out=counted(drop=_type_ rename=(_freq_=count)):
run;

[nimedina]

For the first question, it would be how many posts for each year.

[andreas_lds]

---

@nimedina wrote:

For the first question, it would be how many posts for each year.

---

Then the code i posted should be a solution for the first question. I have, of course, assumed, that the date you have is a proper sas date and not a string.

---

[Kurt_Bremser · Accepted solution]

The second is very easy in SQL:

proc sql;
create table want as
select count(*)  as count_of_tweets
from have
where date ge '20jan2017'd;
quit;

[akanshya142]

1. You can use group by for the same:

proc sql;

create table want as 

select year(date) as yr, count(*) as cnt_tweets from have

group by yr;

quit;

The solution of 2 has been given earlier