Hi, I am trying to transpose daily data using UserWrittenCode in DI Studio which I will append each day to a master table. HAVE (data): DATE             STATUS        COUNT_1 06/01/2020     Done              4 06/01/2020     Start               2 06/01/2020     IP                   1 06/01/2020     FAIL               7   WANT (test1): Date                 Done        Start       IP       FAIL 06/01/2020          4              2           1          7   Can you see an error in this code? Thanks! %let etls_tableExists = %eval(%sysfunc(exist(&_OUTPUT, DATA))); %if (&etls_tableExists) %then %do; proc sql noprint; drop table &_OUTPUT.; quit; %end; PROC TRANSPOSE data=&_INPUT out=test1; by DATE; id STATUS; var COUNT_1; RUN; DATA &_OUTPUT. ; SET test1; run; ... View more

Hi. I am somewhat new to SAS. I an sure this is simple but I am stuck. I have a table of CODES and a count by CODE. I would like to create a smaller table of just the Top n codes (3 in this example). Could you provide an example code? Thanks!   HAVE (code_tbl):                                                WANT (tbl_topthree): CODE      COUNT_OF_CODES        CODE      COUNT_OF_CODES  123                   6                                   126                      10 124                   8                                  136                       9 126                   10                                124                       8 236                    4 324                    7 223                    2 136                    9 etc.                    etc.   (Is it also possible to do one level deeper? Such as if I had STORE   CODE    COUNT_OF_CODES and wanted the top 3 COUNT by each STORE.)   ... View more

Hi. I am new to TD coding. In DI Studio,  I would like to convert 08JAN2020 date format to mm/yyyy and use mm/yyyy for my grouping (ie by month/year only, ignore day of the month). In SAS I used this: INPUT(PUT(date,mmyys7.),anydtdte7. It looks too exotic but it worked good to just give me month/year. How would I get to the same date value in teradata? Thanks! (Is this the correct forum for TD questions?). ... View more

Hi. I am learning to work with teradata code in DI Studio to speed up processing of large tables (Advice from my admin). This might be more of a strategy question. How to SUM by a Group A only. The Group By requires all the non-aggregated columns to be listed, which seems awkward. Please correct me if I understand it wrong.   HAVE: Columns A B C D(variable) WANT:   The SUM of D(variable) Grouped By A only. If 3 different A values: 3 groups: Group A1 - sum(Dvar), Group A2 - sum(Dvar), Group A3 - sum(Dvar) HOW (in TD): SUM(D(variable); Group By A B C (must include all columns?!) GET?: 3 x 3 combinations of grouping: A1B1C1 sum(Dvar), A1B1C2 sum(Dvar), A1B1C3 sum(Dvar)etc.   I could do brute force and split off a table of A D(variable), perform my sum/group, then rejoin. Is there a more efficient way? Any advice would be appreciated! Eventually this will be reported in Viya. ... View more

Hi. DI Studio use basic question. I am an EG user, trying to add DI Studio to my skillset (with some mentoring). Does DI have an equivalent to EG's Filter "in a List", where Add Values gives a list of possible choices? I find that very useful and I don't see it in DI's WHERE Tab of Properties (Extract transform). Thanks. ... View more