About Peter_Wine

Peter_Wine · ‎11-25-2020

Hi, I just realized that using this solution I get as a result table which contains: old column and new columns. So it looks that to old table new columns are added. I want to keep only new columns. And - I don't know if it is because of above - the length of new columns is set the same as length of old column. How to change it to appropriate length. Please remember that my dataset has over 100 columns hence I ask to simple solution. 🙂 Thanks, Piotr

Peter_Wine · ‎11-18-2020

Works, thanks. I hoped that there is an easier method rather then typing "substring" n-times but Excel helped 🙂 Many thanks. Piotr

Peter_Wine · ‎11-18-2020

Hi All, I've got a dataset (not file) which has only one column and millions of rows. This column contains a fixed length data. How can I split this one column into columns according to fixed length of new columns? Example: Is: Dataset_1: | Col1 | | AAABBBCCC111 | | AAABBBCCC222 | | AAABBBCCC333 | Need: Dataset_2: | Col1 | Col2 | Col3 | Col4 | | AAA | BBB | CCC | 111 | | AAA | BBB | CCC | 222 | | AAA | BBB | CCC | 333 | Thanks, Piotr

Peter_Wine · ‎09-23-2020

Hi All, Is it possible to read avro files from Hadoop in SAS DI? All my trials failed. I tried "File reader" and "Hadoop File Reader". Both doesn't work for me. Thanks in advance, Piotr

Peter_Wine · ‎12-05-2018

Hi All, I'd like to use splitter to split data based on condition: FILED1 NOT LIKE "*abc*" I functions: CONTAINS and LIKE are not available in the functions list. I tried to use operator "=*" but it also doesn't work NOT FIELD1 =* '%abc%' Any advise? regards, Piotr

Peter_Wine · ‎03-30-2018

Thanks: %put _all_; works fine. Regards, Peter

Peter_Wine · ‎03-29-2018

@Patrick thanks for answer but it doesn't give answer I need. I'd like to get the same info which is printed by command: %put _GLOBAL_; answer should be like this: GLOBAL _SASHOSTNAME 'server_name' Or why when I run command "%put _GLOBAL_;" option "GLOBAL _SASHOSTNAME 'server_name' " is not printed? Regards, Peter

Peter_Wine · ‎03-29-2018

Hi All, How can I figure out on which server SAS DI currently works? In my case SAS uses several servers which are chosen randomly and I don't know which one is currently used. I was trying to run code: %put _GLOBAL; but there is no sever name given by it. Regards, Piotr

Peter_Wine · ‎02-02-2018

Hi Community, Is it possible to see progress of loop transformation? Example: In job is loop with parameter table. Is it possible to see which parameter is currently processed? Regards, Peter

Peter_Wine · ‎02-02-2018

Works!!! Thanks a lot. Regards, Peter

Peter_Wine · ‎02-02-2018

Hi SAS Community, I'm trying to use "Extract" transformation and for one column I'd like to use parameter defined in "User Written" step. In "User written" I declare: %LET parm='abc' In "Extract" I created new column and in expression field I write: &parm I get error: ERROR: The following columns were not found in the contributing tables: abc Any idea? Regards, Peter

Peter_Wine · ‎11-16-2017

Hi, Unfortunately I inherited some job in SAS DI which use this transformation and it stops there. I tried to modify code manually in the "code" tab (Right click -> Properties -> Code -> User written body -> proc transpose......). Cheers, Piotr

Peter_Wine · ‎11-15-2017

Hi All, I got the following error during running transformation: "Transpose" in SAS DI: "ERROR: Too many bad BY groups." I found that I have to add "LET" option to PROC TRANSPOSE, but how can I do that in SAS DI. I tried to put it manually in "Code" tab but it doesn't work. Also in tab: "Options" -> "Other options" -> "Specify PROC TRANSPOSE options:" when I put it here I don't see it in the code and doesn't work.. Please help, Piotr

Peter_Wine · ‎11-13-2017

Hi All, What is the difference between: "Insert Rows" and "Append" in SAS DI transformations? Is it on the performance? Are they equal in terms of features / results which they give. When I should use first one and when second one? Thanks in advance, Piotr

Peter_Wine · ‎11-09-2017

Hi Reeza, Thanks, it works! 🙂

Online Status	Offline
Date Last Visited	‎11-26-2020 07:56 AM

Re: Split dataset (one colum - fixed length data) into columns

Re: Split dataset (one colum - fixed length data) into columns

Split dataset (one colum - fixed length data) into columns

How to read avro file from Hadoop in SAS DI?

Use equivqlent to LIKE in splitter transformation

Re: How to check server where SAS DI is working on?

Re: How to check server where SAS DI is working on?

How to check server where SAS DI is working on?

SAS DI - Loop - to see progress

Re: SAS DI - use parameter in advance expressions

Re: SAS DI - Loop - to see progress

Re: Split dataset (one colum - fixed length data) into columns

Re: Split dataset (one colum - fixed length data) into columns

Split dataset (one colum - fixed length data) into columns

How to read avro file from Hadoop in SAS DI?

Use equivqlent to LIKE in splitter transformation

Re: How to check server where SAS DI is working on?

Re: How to check server where SAS DI is working on?

How to check server where SAS DI is working on?

SAS DI - Loop - to see progress

Re: SAS DI - use parameter in advance expressions

SAS DI - use parameter in advance expressions

Re: SAS DI: "Transponse" transformation. "ERROR: Too many bad BY group...

SAS DI: "Transponse" transformation. "ERROR: Too many bad BY groups."

What is difference between: "Insert Rows" and "Append" in SAS DI trans...

Re: SAS DI - Extract transformation - filtering by dates