I would like to know how to use substr function with macro variables. I have the macro variables as follows and I would like to look for first five characters and select the last three characters based on the condition as mentioned below. Not sure it is right and I do not have SAS to execute to it (downtime now). Correct me if I'm wrong. %let ent_curr=10000_EUR; /*i have many macro variables like this*/ /*and I have to write the condition as like below*/ /*given below is sample condition and there are some conditions as similar which I have to write*/ Case When entity =substr(&ent_curr.,1,5) then substr(&ent_curr.,7,9) Else Currency_cd End; ... View more

I'm trying to capture the return code of DI Job via &syscc. but I observed that it is not resetting for each run. It returns the previous return code for every run instead of the providing the actula Job Status. For example, If a Job has ended with Syntax error and the macro variable &syscc. returns 3000 which is correct.   If I correct the error and reran the Job then it should return as 0 if the Job has no warnings or error but it still producing the value as 3000 which is return code of previous run.   I'm calling the following maro variable in the postcode section of the DI Job. My objective is to return the Job Status code of the Job.   %let status_cd=&syscc.; %PUT *******status of the job is: &status_cd.*****; Please help me resolve this issue. ... View more

May I know how to overcome the below error?   SAS code:   proc sql noprint; select "FAULT_ID = "||compress(f_id)|| " ; "||" IF " || notupper(col_nm)|| " eq " || 0 || " and " || length(col_nm) || " eq " || 3 || " then output ; " into :UPPERCASE separated by " " from oper_flt_ref where category="UPPERCASE" and tbl_nm="INSURANCE"; quit;   Log:   26 proc sql noprint; 27 select 28 "FAULT_ID = "||compress(f_id)|| " ; "||" IF " || notupper(col_nm)|| " eq " || 0 || " and " || length(col_nm) || 28 ! " eq " || 3 || " then output ; " 29 into :UPPERCASE 30 separated by " " 31 from oper_flt_ref 32 where category="UPPERCASE" and tbl_nm="INSURANCE"; ERROR: Concatenation (||) requires character operands. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 33 quit; ... View more

Is there any way that we can manage permissions for few folders where DI studio jobs resides? I want to give read only permissions for my team and only I should have permission to update DI jobs in that folder.   Can we tackle this within DI or we need management console to accomplish it? ... View more

In the following code I'm reading the entire dataset using SET Statement where it has 10 Million records and 25+ varaibles. Since it is time consuming, Is there any efficient way to read the dataset and extract the distinct values for ENTITY and REPORTING? Can we implement Bitmap Index (available in SAS?) kind of apporach here?   /*extract unique entity_id and reporting cause*/ data dis_entity_id ; set &tblname.; format ENTITY $ENTITY. REPORTING $50.; keep ENTITY REPORTING; run; proc sort data=dis_entity_id nodupkey; by ENTITY REPORTING; run; ... View more