Hello all, in DI Studio I built a job which includes a Loop. This Loop includes 1 job, which has 5 parameters assigned, that get passed over to the included job. However, once I map all 5 parameters from the incoming data set, whenever I save and reopen the job, the 5th mapping is lost. All others are still there. Is there a limitation of parameters for a loop/job-inclusion? Thanks a lot, Thomas UPDATE: Please disregard, it seems only a certain length is allowed as parameter name Message was edited by: ThomasH ... View more

Hi everybody, I guess this is a very easy one, but I just cant figure it out on this friday afternoon... I am passing a date9 value to another job in a loop, so it gets there as a macro variable. So I have a variable &date, which resolves to 17998. How do I convert it back to a DATE9. value? What's the name of the format of "17998". data _null; format x DATE9.; x = input(resolve('&date'),DATE9.); ... does not work. Thanks a lot! Thomas ... View more

Dear forum, I am facing an issue with DI Studio I cant find any documentation on. There is 1 job which has a Lookup (missing table->abort) and a post-processing defined, which inserts a row into a "jobstatus" table containing the JOB_RC. When running the job normally, it aborts when in case the lookup table is missing and executes the post-processing code. When I run the job via an %include from another job, the lookup table is missing, the job aborts but does NOT run the post-processing code, thus not inserting the JOB_RC into my jobstatus table. Why is the behaviour different? Thanks a lot, Thomas ... View more

Hello all, got a little problem here and would be glad to get help. Using a User Written Code in DI Studio I am trying to UNION 2 datasets to filter out duplicate rows. Dataset a has 1 column with informat 12.7/outformat 12.7, so has dataset b. Values are: dataset a 12.1234594999 dataset b 12.1234595 The value in dataset a is displayed in DI Studio exactly as value b (due to informat/outformat), but once I do not use the usual table view of DI studio, it has all the decimals as written above. So once I do this... SELECT * from a UNION SELECT * from b ...the values are identified as NOT duplicate. So there are 2 questions: - Why does the UNION neglect the in/outformat (do I need to specify the format in the UNION again?) - How do I round this (round, roundz?) to fit value b so I can round it before the UNION Any help is appreciated very much. Thanks, Thomas ... View more

Hello all, I am trying to do the following: There is 1 implementation and 1integration environment. Both contain a DB/2 database with different user/pass settings. In the physical storage of my table I have set up a profile with user/pass, which is no longer valid, when I deploy my .sas files to the integration environment. The user/pass are pre-assigned in the SAS config files per environment and would need to be accessed via &DBUSER and &DBPASS - is it possible to set up the profile like this in the Management Console or do I need to do it differently? Thanks a lot, Thomas ... View more

Hi, I am trying to build some kind of workflow handling and would like to request your input on the following scenario: There is 1 job A, which includes (via %include) 3 jobs B1, B2, B3 sequentially in a loop. Job A is executed Job A includes B1 B1 checks for a condition (if true: continue with job, set a flag F = 0 / if false: abort only B1, set a flag F = 1) Job A includes B2 B2 checks F (if 0, continue / if 1, abort only B2) B3 as B2 Job A ends Questions: - does the usage of "%abort return" work for the given scenario or should I consider anything else? - is "%global F" sufficient to define it as a variable available throughout B1 - B3? A is executed in batch mode. Any hint would be appreciated. Thanks and regards, Thomas Message was edited by: ThomasH ... View more

Hi all, I have created a macro variable in the pre-processing of a job. [...] %let jobname = %substr(&etls_jobname,1,5); [...] Now I would like to access it in the post-processing via a PROC SQL but it cant be resolved there. [...] WHERE jobname LIKE "&jobname" [...] I can't use &etls_jobname here, because it gets overwritten while some other jobs run via %include. Any idea how I can resolve this? Thanks a lot in advance and best regards, Thomas ... View more

Hi all, I am trying to call a PROC SQL in a macro, where the SQL creates 2 variables via "INTO : " and then continue to use it in that calling macro. But somehow, this doesn't work as the 2 variables are always "0" in the following code. Anybody got an idea? Appreciate every help! %let id = 0; %let version = 0; %MACRO CoolLookup(Zahl); proc sql; select ID, VERSION into :ID, :VERSION from myLib.mytable where LOOK_HERE = &Zahl. AND LOOK_THERE = 'T'; quit; %MEND CoolLookup; %MACRO start; data test_port; CALL EXECUTE('%CoolLookup(601)'); test_601_ID = &ID.; test_601_VERSION = &VERSION.; run; proc print data = test_port; run; %MEND start; %start; Thanks and best regards, Thomas ... View more

Hi there, I am trying to enter a time8. format into a SAS dataset via edit mode in DI studio. However, the system keeps on complaining about a wrong format unless I build a job to table-load an existing time8. value from another table into my target table. Copy/Pasting exactly this value from the source does also not work. How do I need to enter the time into a time8. cell? Not working is: - 1960-01-01 18:00:00 - 18:00:00 Thanks a lot and regards, Thomas ... View more

Hi all, got another problem here. I am working with DI Studio and just tested some min/max field format and informat values via direct input in DI Studio datasets. It seems that for a column with format "14." (length 😎 I cannot enter values with >9 resp. >10 digits depending on the number I use. E.g. 99999999999999 -> Not a valid integer value 999999999 -> works (9x 9) 11111111111111 -> not a valid integer value 1111111111 -> works (10x 1) Trying it purely in SAS base works. Is this a DI studio issue? Thanks and regards, Thomas ... View more