Hi PaigeMiller, Really thanks for your prompt response. 'Maximum length' means the column has multiple records and i want to know the max length size of that particular columns record. I tried your code but its giving me below output. Can you please have a look at it and help me to understand what's wrong with it? 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 75 76 proc sql; 77 create table column_length as select * from dictionary.columns where libname="hadoop"; NOTE: Table WORK.COLUMN_LENGTH created, with 0 rows and 18 columns. 78 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 5222.84k OS Memory 37288.00k ... View more