I'm trying to remove the trailing spaces with the use Strip function as follows, but it is not removing the spaces in the final Output.   Am I missing something?   FNCTL_CMPNT_NM=strip(ifc(indexw("&etls_jobName","_ADP_"),'AP','LIS')); My Value for FNCTL_CMPNT_NM is 'LIS                                                                                  ' after the execution of the above code. ... View more

After executing the code below,   proc sql; create table dis_entity_id as select distinct ENTITY_ID format=$ENTIT. from INSURANCE_CONTRACT; quit;     I got Output as ,   DKV Seguros DKV Belgien NULL RGO Schadn/Unfall RGO Hestia   Now I want the Output as   DKV Seguros/DKV Belgien/NULL/RGO Schadn Unfall/RGO Hestia   so I ran the code below to get the desired output   data reqd_vars (drop=ENTITY_ID); set dis_entity_id end=last_record; by ENTITY_ID; /* format ENTY_NM $ENTIT.;*/ length ENTY_NM $50; retain ENTY_NM; if first.ENTITY_ID then ENTY_NM=catx('/',ENTY_NM,ENTITY_ID); if last_record then output; run; But the Output which I got is 54009/54010/580001/58001/60011 instead of DKV Seguros/DKV Belgien/NULL/RGO Schadn Unfall/RGO Hestia. May I know why the Format is not applied in the bew variable ENTY_NM?     ... View more

I want to combine multiple values of Entity_ID into one Entity_ID in the new variable Name ENTY_NM.   If I execute the code below I received 5 observations (one Entity_Id for each row ) instead of one Observation.   If I've Entity_Ids like abc_bcf,dfe_efr then I want it to Display like abc_bcf/dfe_efr    data reqd_vars; set dis_entity_id; by ENTITY_ID; length ENTY_NM $50; retain ENTY_NM; if first.ENTITY_ID then ENTY_NM=" "; ENTY_NM=catx('/',ENTY_NM,ENTITY_ID); if last.ENTITY_ID then output; run; ... View more

I'm trying to create a user defined format as follows, but I'm not seing the updated Format in the dataset dis_entity_id. Am I doing something wrong? In my final dataset I want to see the texts as 'Schaden/Unall' if the ENTITY_ID is 5801   proc format; Value $ENTIT '5801'='Schaden/Unall' '60011'='Hestia' '56002'='Lebn' '60041'='Austria' '6002'='Belgien' '5401'='Köln' '54009'='Segros' '5400'='Belgen' 'test'='NULL'; run; proc sql; create table dis_entity_id as select distinct ENTITY_ID format=$ENTIT. from &_INPUT; quit;     ... View more

  If I execute the below code, I'm not getting the right value for the variable SOLN_CMPNT_NM . I'm getting the value as "DATA EXPORT" instead of "DATA TRANSFER" when my &etls_jobName resolves  I'm not certin what I'm doing wrong here.   ... View more