About mm84

mm84 · ‎12-12-2023

Hi @Kurt_bremsen, thanks for your help. As @l_lanssen notice there was a missing retain to complete the solution.

mm84 · ‎12-12-2023

Thanks @s_lassen, it is fix with the missing retain. I will mark @Kurt_Bremser solution as accepted.

mm84 · ‎12-12-2023

I am using SAS Enterprise Guide 8.3. When applying the solution it returns:

mm84 · ‎12-12-2023

Third observation for group A and period 202302, it should count M0, M1, that are the distinct keys until this month.

mm84 · ‎12-12-2023

Sorry, you are right. For 202301 it should be 2.

mm84 · ‎12-12-2023

I need to accumulate from previous periods. For 202303 it should distinct count from all previous periods. That is why in 202303 it should count M0, M1, M2, M3.

mm84 · ‎12-12-2023

I don't want to count inside each group, but to accumulate distinct keys from the begging. In 202303 it should count M0, M1, M2, M3. Thanks.

mm84 · ‎12-12-2023

Sorry, what I have is MyDataset1. What I want is MyDataset2. Thanks

mm84 · ‎12-12-2023

Hi community, I would like to accumulate a count distinct of a variable for each period inside a group. I tried to use retain with no luck. Can someone point me in the right direction? data MyDataset1; length group $1 Period 6 Key $8; infile datalines truncover; input group $ Period Key $ ; datalines; A 202212 M0 A 202301 M1 A 202302 M1 A 202302 M2 A 202303 M1 A 202303 M3 B 202301 L1 B 202302 L1 B 202303 L2 B 202303 L3 ; run; data MyDataset2; length group $1 Period 6 cummulative 6 ; infile datalines truncover; input group $ Period cummulative ; datalines; A 202212 1 A 202301 1 A 202302 2 A 202303 4 B 202301 1 B 202302 1 B 202303 3 ; run; Thanks

mm84 · ‎09-18-2019

Hi community, I have an aggregated measure using parallel period cummulative function: I have a filter to show only 2 years, 2018 and 2019. The problem is that when I create a bar chart there is no information from 2018, since It depends from 2017. Is it possible to show in bar chart only 2019 year? Thanks,

mm84 · ‎08-10-2019

Perfect,it works. Thanks

mm84 · ‎08-09-2019

Hi @SASKiwi , We have different layers, if the extraction of a table fails then we need to run 3 or 4 projects to get everything updated. It could be nice if it would be possible to know only the flows that are affected to re-run again. Thanks,

mm84 · ‎08-08-2019

@CaseySmith Thanks for your answer. What we need to accomplish is a way to know when a table fails which are the dependent tables that are affected. We have many flows in different epg projects, but if one table fails, how could you easily know which are the flows that you need to run again once you fix this table?

mm84 · ‎08-08-2019

Hi community, Is it possible in SAS Visual Analytics 7.4 to create a personalized chart with a stacked bar chart and a line chart with two axes? I was able to create a personalized chart, but when adding the bar chart I can't see the possibility to add more than one measure. A normal bar chart let you add more than one measure, with the grouping style stacked. Thanks,

mm84 · ‎07-26-2019

Hi community, Is there a way to obtain by code all tables of each flow in a SAS Enterprise Guide project? For obtaining all fields of each table in a library I used: PROC CONTENTS NOPRINT DATA=MYLIBRARY._ALL_ OUT=WORK.METADATA_MYLIBRARY; RUN; I need to obtain all table dependencies for each flow. Thanks

Online Status	Offline
Date Last Visited	‎12-12-2023 12:35 PM

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Count distinct inside period by group

Represent cummulative measures in bar chart

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Re: Count distinct inside period by group

Count distinct inside period by group

Represent cummulative measures in bar chart

Re: Personalized chart with stacked bar and line chart

Re: Get all tables of every flow in a project in SAS Enterprise Guide

Re: Get all tables of every flow in a project in SAS Enterprise Guide

Personalized chart with stacked bar and line chart

Get all tables of every flow in a project in SAS Enterprise Guide