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: 
miss_vang
‎05-03-2017
  • 7 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: active activity counts by month

by Calcite | Level 5 in SAS Enterprise Guide
‎04-24-2017 10:42 AM
‎04-24-2017 10:42 AM
when the activity is still active, the end_date is specified with at dot ( . ) in the dataset. ... View more

Re: active activity counts by month

by Calcite | Level 5 in SAS Enterprise Guide
‎04-24-2017 10:36 AM
‎04-24-2017 10:36 AM
Hi again   I can see, that the programming is restricted to the table i maid. It is an example of the data set i have.  To be more specific, i have 30 activities and each activity has 30 or more observations, that I wish to count.   The end_date has '.' and is not missing, when it is still active.     Thank you sooo much for your time and help - it is appreciated 🙂  ... View more

Re: active activity counts by month

by Calcite | Level 5 in SAS Enterprise Guide
‎04-23-2017 04:36 PM
‎04-23-2017 04:36 PM
Thank you so much 😊😊😊 ... View more

Re: active activity counts by month

by Calcite | Level 5 in SAS Enterprise Guide
‎04-23-2017 04:33 PM
‎04-23-2017 04:33 PM
Sorry, i cannot make the table better. Act 1 represent the first activity, where 3 observations were maid in 01-2016 and 2 observations were maid in 02-2016, and so fourth ... View more

Re: active activity counts by month

by Calcite | Level 5 in SAS Enterprise Guide
‎04-23-2017 04:30 PM
‎04-23-2017 04:30 PM
The table should look like this: Activity 01-2016 02-2016 ... 04-2017 Act 1 3 2 ... 3 Act 2. 2 3 .... 4 Act 3 1 2 ... 6 01-2016 represent january in 2016, 02-2017 february in 2016and so forth. The dots represent the months inbetween. ... View more

Re: active activity counts by month

by Calcite | Level 5 in SAS Enterprise Guide
‎04-23-2017 04:24 PM
‎04-23-2017 04:24 PM
1. It counts how many observations of that activity has been active that specific month represented in the table. - 2. Columbs should represent á specific month in a specific year 3. My first table continously update, so I need the activity to count, when there is no enddate (still active) I need my table to take future periods in to account when they occur. When we go into May, then May will appear in table Is it possible to make such a table? ... View more

active activity counts by month

by Calcite | Level 5 in SAS Enterprise Guide
‎04-23-2017 03:20 PM
‎04-23-2017 03:20 PM
  I have Enterprise guide 7.1 I have a table, which looks like this: activity  startdate       enddate act 1     01-10-2016   15-01-2017 act 2     24-02-2015    act 1     06-05-2014    23-06-2016 act 3     20-10-2016   23-04-2017   and I want a table, which looks like:   activity 01-2016  02-2016  03-2016  04-2016  05-2016 ....  03-2017 act 1      1              3               3             2              1                  6 act 2      3              4               5             2              2                  1 act 3      1              1               2             1              0                  2   How can transform first table to the second table? I would really like to make it, so it continues 'forever'? Thank you 🙂     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-03-2017 06:44 AM
Likes given to
View All
Quick links