I have two table A and B. I want compare column B1 from Table B with A1 from Table A. Whichever values will be matched want to add B2 column from Table B corresponding values in A3 column of table A.   Eg.   Table A, Column :: SiteID, Name, Users   Table B Column :: SiteID, Uniue User   Compare A.SiteID and B.SiteID. Whichever values will be matched want add B.Unique User corrensponding value to A.users    Thank You ... View more

How to remove leading and trailing spaces from excel fine? ... View more

I am runing following code,   libname orionx XLSX "/home/aniketwagare0/test/ecprg193/lpar.xlsx" libname outori "/home/aniketwagare0/test/output" data outori.tetest set orionx.lpar1 where Action Performed='111 Create an account' and Action Performed='109 Subscribe Email' run   But i am getting following error,   57 data outori.tetest; 58 set orionx.lpar1; 59 where Action_Performed='111 Create an account' and Action_Performed='109 Subscribe Email' ERROR: Variable Action_Performed is not on file ORIONX.lpar1. 60 run;     I have attached my xlsx file. ... View more