cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
fayemelissa
‎11-13-2021
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Need help to create a data table

by Calcite | Level 5 in SAS Programming
‎11-25-2020 06:58 PM
‎11-25-2020 06:58 PM
Hello everyone! I have to creat a table of the sort with my data and honestly I do not know where to start. Should I use proc tabulate and if so, how do I find the top three longest watching times from my data set. Any help is welcome and I cannot use proc sql for this project.   Thank you in advance!     Mean Median Top three longest watching time Number of people Member of Netflix     This section is divided in three parts   Not member of Netlfix           ... View more

Calculate the sum of a variable

by Calcite | Level 5 in SAS Programming
‎11-17-2020 08:12 PM
‎11-17-2020 08:12 PM
   How would I be able to create a code for this without using an sql procedure? Determine the day of the week (Monday to Friday) for which the total observed usage time during the study period was the highest. The result of your procedure should show the days of week only. I want to have a table with The weekdays and their total of usage time. To do so I have to calculate the sum of the usage time and exclude the weekend days.There are multiple observations for the usage time per day. This is what I have so far: PROC SUMMARY DATA=NewBixi; VAR Timeusage; OUTPUT OUT=Usage SUM=; BY Day; RUN; PROC PRINT DATA=Usage; ID Day; WHERE Jour not in("Sunday";"Saturday"); RUN; However; Saturday still shows in my table and I do not want to have the _type_ and _Freq_ columns in my final table.   Thank you for your help! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-13-2021 08:08 PM
Quick links