I'm processing a table with DI Studio (4.901)   I have a column that is numeric (best6.) input.. I need to convert the column to character (char40).. (simple enough) BUT, if the numeric value of the input column is less than/equal to 99.... I need to add a zero to the leading side of the value in it's character result. I have to use this result character column to join with another table..   so a value of 99 needs to be '099'    I tried to use a case statement such as : case when <= 99 then cat('0', numeric_column) else numeric_column end   when I try to validate the code I get this error: 71 proc sql; 72 validate 73 select case 74 when <= 99 __ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER. 75 then cat (0, channel_code) 76 else channel_code 77 end from work.etls_EFITable;     I think I'm just overlooking something simple in my logic.. Regards.   ... View more

Hi all, (I'm using DI Studio 4.901)   I'm trying to split a column of data i process with a file reader based on a delimiter into 2 new columns. In EG this is easy to accomplish, but I cant seem to get this to convert over to my DIS transformation without an error.   my input column (web_atlas_ord_nbr) is a char20 with a pipe delimiter  my 2 new result columns are char20 as well.   my expression code is: SCAN(web_atlas_ord_nbr, 1) for new result column1   and SCAN(web_atlas_ord_nbr, -1) for new result column 2.   it passes the validate expression check, but when I run it... I get a syntax error:   500 (SCAN (web_atlas_ord_nbr, 1)) as web# length = 20 _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN, LENGTH, TRANSCODE. ERROR 200-322: The symbol is not recognized and will be ignored.     I have attached some shots of the actual code and error. Any help to understand what I'm doing worng would be greatly appreciated.               ... View more

Hi All.   I'm recently charged with creating a job in DI Studio (v4.901) that will use a REST transformation, an API, and return a Json file with data. I've never done anything like this before, and the web and SAS seem limited with information about how to something similar.   I sorta understand the concept, requests and replies with the API... codes based on success or failure. Then using a token to actually GET my data..   Does anyone know of any resources, examples (examples would be awsome) or ways to find out more? I'm still on the green side with my programming skills..    Thanks!               ... View more

Hello,   My headache for today seems simple in theory, but I cannot get it to work: At the end of a DI Studio job (v 4.901) , in the postcode of a transformation, I want to execute an X cmd to delete tables in my archive directory that are over 7 days old. Sounds easy enough right?    in this transformation, I am already using an X cmd to copy the file I just processed into an archive folder based on the status of the job being 'successful'. This works with no problems whatsoever:   X cp -a /dmadata/AS400/CDH_* /dmadata/AS400_ARCH/;   Now after this, I also want to delete any tables in this same archive directory that are older than 7 days. I have tried several variations of : x find /dmadata/AS400_ARCH/CDH* -mtime +7 -exec rm {} \;     the job runs without error, but doesnt do anything.  I have tried to use this code without the mtime check, as well as with a fully defined table name.. but nothing works.   I tried this version: x rm /dmadata/AS400_ARCH/CDH* ;   and everything within the directory was deleted..  so what's the issue?   is there another piece I'm missing, or a format change that could work.? (and yes, I even moved this process to the front of my 'job' to see if it makes a difference, and the results were the same) I'm stuck and looking for someone who might have had this same issue before..   Thanks,       ... View more