topic Re: Counting how many times between dates in New SAS User

Counting how many times between dates

nimedina — Tue, 10 Mar 2020 06:34:13 GMT

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.

How many of tweets has Mr. President made each year (give total number tweets for each year?)
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

Re: Counting how many times between dates

andreas_lds — Tue, 10 Mar 2020 06:23:48 GMT

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;

Re: Counting how many times between dates

nimedina — Tue, 10 Mar 2020 06:27:48 GMT

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

Re: Counting how many times between dates

andreas_lds — Tue, 10 Mar 2020 06:51:21 GMT

@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.

Re: Counting how many times between dates

Kurt_Bremser — Tue, 10 Mar 2020 07:32:42 GMT

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;

Re: Counting how many times between dates

akanshya142 — Wed, 11 Mar 2020 09:07:32 GMT

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