In my project we've decided to replace the hard coded values with the macro variables. Plan is to create the dataset with the list of hard corded values as one variable and the meaningful name for those values in another variable. E.g. Variables Values Sex 'M' Key_figure '22365' Id '659' And we would like to substitute the hard coded values in our program with &sex, &key_figure.... Appreciate if some one of you guide me by explaining how this approach works and how it can be implemented. ... View more

I'm not certain where I'm missing the closed paranthesis in the below code.   26 data test; 27 28 SCHDLD_OBJ_RUN_STRT_TMST=%sysfunc(floor(%sysfunc(inputn("&etls_stepStartTime",datetime17.)))/60*60); _ 388 200 76 ERROR: Expected close parenthesis after macro function invocation not found. ERROR 388-185: Expecting an arithmetic operator. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. 29 format SCHDLD_OBJ_RUN_STRT_TMST dtfmt.; 30 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 0 observations and 1 variables. WARNING: Data set WORK.TEST was not replaced because this step was stopped ... View more

I'm executing the following code in most of the programs.. For the programs which don't have ENTITY_ID from the querying table, I want to create the variable ENTITY_ID (character) and assign the missing value instead of receiving the error 'ERROR: The following columns were not found in the contributing tables: ENTITY_ID. '   /*extract unique entity_id*/ proc sql; create table dis_entity_id as select distinct ENTITY_ID format=$ENTITY. from &library..&Input_table.; quit; ... View more

I've the post code in DIS Job which calls the .sas file via %INCLUDE Statement. It (post code) is working fine when DIS Job ends with success or warning. However it is not working when the DIS Job Fails and I could see the WARNING as follows. I'm not certain why I'm getting the WARNING only when DIS Job fails.   .sas file which was being called in INCLUDE Statement is not taking any value from the final table which was being created from the DIS Job. May I know how to resolve this issue when the DIS Job failes?     817 /*---- Start of Post-Process Code ----*/ 818 819 %INCLUDE "/var/sasdata/ifr/SASCode/distudio/metadata_info.sas"; 0 WARNING: RUN statement ignored due to previous errors. Submit QUIT; to terminate the procedure. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.02 seconds cpu time 0.00 seconds ... View more

I want to create one macro variable called 'LIBRARY' which I want to use it to the next step to query the permanent table. Assume I've a Job Name as below.   %let etls_jobName = IF_04_J_PRT_TRA_INSURANCE_RECORD_DELIVERY; or %let etls_jobName = IF_04_J_PRC_TRA_INSURANCE_RECORD_DELIVERY; or %let etls_jobName = IF_04_J_PRT_LOA_INSURANCE_RECORD_DELIVERY; or %let etls_jobName = IF_04_J_PRC_LOA_INSURANCE_RECORD_DELIVERY;   And   If the Job Name contains PRT_TRA then I want the macro variable to resolve to IFPRTEXT If the Job Name contains PRC_TRA then I want the macro variable to resolve to IFPRCEXT If the Job Name contains PRT_LOA then I want the macro variable to resolve to IFPRTTRA If the Job Name contains PRC_LOA then I want the macro variable to resolve to IFPRCTRA   I never created the macro variable with some conditions. Appericiate if someone of you shed some light on this.     ... View more