Dear All,   I have a program like below , which is to modify the labels of the datasets.   proc sql noprint; select distinct quote(trim(memname)) into :mis_tables SEPARATED by ',' from sashelp.vcolumn where libname='libref'; quit; %put &mis_tables; options nomlogic nosymbolgen nomprint; /* Updating the lables */ %macro s(kname1 ,kname2,labels ); %let labels2 = %sysfunc(tranwrd(%quote(&labels),%str(??),%str(,))); proc datasets lib=resasdmc nodetails nolist ; modify &kname1; label &kname2="&labels2" ; quit; %mend s; data ddd(keep=table_name tech_name label_name_1); set mis_ref_labels; //oracle table where table_name in (&mis_tables); label_name_1= tranwrd (label_name,',','??'); run; data _null_; set ddd; call execute('%nrstr(%s('||(strip(table_name))||' , '||(strip(tech_name))||','||%str(strip(label_name_1))||'))'); run;   Table ddd: TABLE_NAME TECH_NAME label_name_1 MIS_FLAT_BUS_SEG_KPI AMT0_AAE_N Acq Cost And Admin Exp?? Net MIS_FACT AMT0_AAE_O Acq Cost And Admin Exp?? Retro MIS_FACT AMT1_APR_N Agg Pol Res?? Net MIS_BUS_COND_DEDUCTIONS ADDCOMM_AMOUNT ADDCOMM_AMOUNT MIS_BUS_COND_DEDUCTIONS ADDCOMM_AMOUNT_MAIN ADDCOMM_AMOUNT_MAIN MIS_BUS_COND_DEDUCTIONS ADDCOMM_DEDBASIS ADDCOMM_DEDBASIS MIS_BUS_COND_DEDUCTIONS ADDCOMM_DEDUCTION_TAB ADDCOMM_DEDUCTION_TAB MIS_BUS_COND_DEDUCTIONS ADDCOMM_FK_AMT_CY ADDCOMM_FK_AMT_CY MIS_BUS_COND_DEDUCTIONS ADDCOMM_METHOD_ID ADDCOMM_METHOD_ID MIS_BUS_COND_DEDUCTIONS ADDCOMM_METHOD_TITLE ADDCOMM_METHOD_TITLE MIS_BUS_COND_DEDUCTIONS ADDCOMM_PCT Management Expense (%)   I am gettign an error : ERROR: Expected close parenthesis after macro function invocation not found.   Rootcause : The last row, label_name1 column is having a value Management Expense (%) where the character '%)' is masking ')'., there by causes closing parenthesis issue.   Can anyone please help here?   Thanks, Chithra ... View more

Dear All,   I am having a data set like below :   id scn year value 89 1 168 100000 89 1 169 0 89 1 169 111111 89 1 171 0 89 1 171 0 89 1 172 100003 89 1 179 100004 89 1 180 0 89 2 168 100006 89 2 169 0 89 2 172 100008   The columns id,scn and year is sorted in ascending order, i mean all are group by. year column should be consecutive numbers, but here some year are missing, I need to add consecutive numbers in between with value as 0. i need to do this in data step becuase it is very huge data, multiple steps will cause performance issue.   The output should lokks like : id scn year value 89 1 168 100000 89 1 169 0 89 1 169 111111 89 1 170 0 89 1 171 0 89 1 171 0 89 1 172 100003 89 1 173 0 89 1 174 0 89 1 175 0 89 1 176 0 89 1 177 0 89 1 178 0 89 1 179 100004 89 1 180 0 89 2 168 100006 89 2 169 0 89 2 170 0 89 2 171 0 89 2 172 100008   Thanks in Advance, Chithra ... View more