DATA Step, Macro, Functions and more

Majority of data points

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Majority of data points

Hello,

I need to find the time period (3 month increments; Jan-Mar, Feb-Apr, etc.) where the majority of my data points (rates) are. The dataset extends 2 years. Would it be best to create a graph/visualization such as a scatterplot? Or use a proc freq statement on the dates? Any help would be greatly appreciated.


Accepted Solutions
Solution
‎04-20-2018 04:18 PM
Super User
Posts: 13,006

Re: Majority of data points

Posted in reply to statiswak

If you have a date associated with the measures then 1) make sure it is a SAS date value (NOT character or numeric like 20180120 that only looks date-like) and 2) use a format like YYQ6. for the variable.

Then procs like Freq will group the variables into calendar quarters and display the value like 2017Q1 (first quarter of 2017)

View solution in original post


All Replies
Respected Advisor
Posts: 2,647

Re: Majority of data points

Posted in reply to statiswak

"majority of data points" might mean something different to me than it means to you

 

Nevertheless, I can think of two approaches

  1. Histograms (bar charts) of the data
  2. Run PROC UNIVARIATE and use the MODE that is computed (MODE is the value occurs the most)
--
Paige Miller
New Contributor
Posts: 3

Re: Majority of data points

Posted in reply to PaigeMiller

Thank you!

Solution
‎04-20-2018 04:18 PM
Super User
Posts: 13,006

Re: Majority of data points

Posted in reply to statiswak

If you have a date associated with the measures then 1) make sure it is a SAS date value (NOT character or numeric like 20180120 that only looks date-like) and 2) use a format like YYQ6. for the variable.

Then procs like Freq will group the variables into calendar quarters and display the value like 2017Q1 (first quarter of 2017)

New Contributor
Posts: 3

Re: Majority of data points

Thank you. The proc freq did the trick. I did a cross-tabulation, so I could see the frequency of the ID's by date and quarter.

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 97 views
  • 2 likes
  • 3 in conversation