Dear All, I have a macro generated automatically from the sas environment(measures). I need to get the macro through sas dictionary.macros. As the length of the macro is too large, the value column cannot accommodate the contents. I hope the default length is 200(showing in the offset column). I need the 4 rows in to one. The change in the length of value column is not possible(see the program). Can you please help? Program: /*below is the amcro which i declared manually(automatically created)*/ %let measures=BUILDINGS_IOTRM CONTENTS_IOTRM TIME_ELEMENT_IOTRM BUILDINGS_IOTRM_AVG CONTENTS_IOTRM_AVG TIME_ELEMENT_IOTRM_AVG PTRM_CNT PTRM PTRM_AVG BUILDINGS_PTRM_CNT BUILDINGS_PTRM BUILDINGS_PTRM_AVG CONTENTS_PTRM_CNT CONTENTS_PTRM CONTENTS_PTRM_AVG STOCK_PTRM_CNT STOCK_PTRM STOCK_PTRM_AVG APPURT_STRUCT_PTRM_CNT APPURT_STRUCT_PTRM APPURT_STRUCT_PTRM_AVG COMBINED_PROP_PTRM_CNT COMBINED_PROP_PTRM COMBINED_PROP_PTRM_AVG TIME_ELEMENT_PTRM_CNT TIME_ELEMENT_PTRM TIME_ELEMENT_PTRM_AVG IOTRM_CNT IOTRM IOTRM_AVG BUILDINGS_IOTRM_CNT CONTENTS_IOTRM_CNT STOCK_IOTRM_CNT STOCK_IOTRM STOCK_IOTRM_AVG APPURT_STRUCT_IOTRM_CNT APPURT_STRUCT_IOTRM APPURT_STRUCT_IOTRM_AVG COMBINED_PROP_IOTRM_CNT COMBINED_PROP_IOTRM COMBINED_PROP_IOTRM_AVG TIME_ELEMENT_IOTRM_CNT; proc sql; create table vars as select name,offset,value as value1 length 10000 from dictionary.macros where scope eq 'GLOBAL'; /* create table macro_variables as*/ /* select catx(' ','%let ',strip(name),'=',strip(value),';') as statement length 700,*/ /* catx(' ','%global', strip(name)) as global_statement length 100*/ /* from vars;*/ quit; Thanks, Chithra
... View more