Hi Reeza Below is the excerpt of the code i am trying (cannot put the entire code for compliance reason, the colums in the select are | concatenated to form a single line for each row returned. i have set the options in data step as "pagesize=MAX linesize=MAX;" The MAX for linesize defaults to 256, even setting to a bigger value say 1000 does not desired output. ============================= proc sql connect to db2(database=&dbase authdomain="AAA"); create table Gen_UnionQuery_Data as select * from connection to db2 ( SELECT T.OUTPUT FROM ( <<<< select query with many coulums from a multi-table join >>>> ); disconnect from db2; quit; data temp; set Gen_UnionQuery_Data; run; options nonumber nocenter nolabel nodate pagesize=MAX linesize=MAX; titlel; proc print data=temp noobs; run; ============================= Please check an help ...
... View more