About trt

trt · ‎12-17-2018

I have to say this is the worst format to take for import. ANYDTDTM19. informat is choosing format for each single new line, and makes serious mistakes when month and day can be misunderstood. For example 12JUN2018 (12.06.2018) will by rule always misinterpreted as 06DEC2018. That is why it is very important to set options datestyle=dmy; to make it sure that day is read always first.

trt · ‎08-22-2017

Just to have it in the air within this discussion. You can also use the Stored Process sessions (http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sesssamp.html). A macro variable (_sessionid) you need to pass through your pages (as a GET parameter). All pages which have the same _sessionid can share the libref called SAVE, and all datasets created in it. This library is temporary, as session expires after (by default) 15 minutes. If any of the SAS experts are there to correct me, please do.

trt · ‎11-16-2015

Hey SAS_Mike, Thanks for your answer. I guess you are right, it seems to me a bit difficult to do it directly from Report Designer, so instead I need to figure out a new column for Data Source (built in "Data Preparation/Builder", as you mentioned). However, I still havent figured out the best way to do it, so that once it gets aggregated, the formula works properly 🙂

trt · ‎11-16-2015

Hey Teja, In original database table, ObjectID is Character value. The output should have "10.5" value as one of the columns. Let's say for this example, I would need to have an output like this: ======================= Day | Value (aggregated) 1 | 6.2 (1.5+1.5+3.2) 2 | 6.2 (1.5+1.5+3.2) 3 | 10.5 (1.5+1.5+3.2+4.3) ======================= But the time period should be flexible, as the periods have to be chosen by the client who would use the report. So in that sense, e.g. if the period is chosen to be from Day 2 onwards, then ======================= Day | Value (Aggregated) 2 | 3 (1.5+1.5) 3 | 7.3 (1.5+1.5+4.3) =======================

trt · ‎11-09-2015

Assume we have the following table loaded as data source in SAS Visual Analytics: ======================= Day | objectID | Value 1 | 1 | 1.5 1 | 2 | 1.5 1 | 3 | 3.2 2 | 1 | 1.5 2 | 2 | 1.5 3 | 1 | 1.5 3 | 4 | 4.3 ======================= Now I want to get a sum of all distinct objectIDs over these 3 days (assumption is that value does not change over days). literary, I would like to get: value_for_objectID_1 + value_for_objectID_2 + value_for_objectID_3 + value_for_objectID_4 which would be in this case 1.5+1.5+3.2+4.3=10.5 In form of a SQL query: select sum(a.value) from (select distinct objectID, value from DATA_TABLE_ABOVE) a; Since to my knowledge, SAS Visual Analytics does not offer SQL queries within chosen data source in the "Report Designer", how would one be able to aggregate value conditionally (in this case over distinct values of another column). Any hints/suggestions would be very helpful.

Online Status	Offline
Date Last Visited	‎12-18-2018 04:17 AM

Re: Informat for dd/mm/yyyy hh:mm:ss

Re: Stored process that outputs a data set?

Re: How to conditionally aggregate data in Report Designer?

Re: How to conditionally aggregate data in Report Designer?

How to conditionally aggregate data in Report Designer?

Re: Informat for dd/mm/yyyy hh:mm:ss

Re: Informat for dd/mm/yyyy hh:mm:ss

Re: Stored process that outputs a data set?

Re: How to conditionally aggregate data in Report Designer?

Re: How to conditionally aggregate data in Report Designer?

How to conditionally aggregate data in Report Designer?