https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71481#M7124 Hi,<BR /> <BR /> Is there a way to drop columns from the output table when I am using the Query Builder in EG?<BR /> <BR /> Thank you Fri, 26 Mar 2010 15:55:12 GMT LS 2010-03-26T15:55:12Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71481#M7124 Hi,<BR /> <BR /> Is there a way to drop columns from the output table when I am using the Query Builder in EG?<BR /> <BR /> Thank you Fri, 26 Mar 2010 15:55:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71481#M7124 LS 2010-03-26T15:55:12Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71482#M7125 Under the select tab in the Query Builder, only add the columns (variables) that you want to keep in the output table. Fri, 26 Mar 2010 16:04:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71482#M7125 Technolero 2010-03-26T16:04:01Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71483#M7126 Hi,<BR /> <BR /> Thank you for the tip.<BR /> Maybe I didn't ask it quite well.<BR /> I am using a SAS Data Set that has one column(column A), which I use to derive two other columns(calculated columns). <BR /> I just don't need column A to be carried over to the resulting Data Set.<BR /> <BR /> Thank you Fri, 26 Mar 2010 16:17:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71483#M7126 LS 2010-03-26T16:17:34Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71484#M7127 In the Query Builder's Select Data tab, only add your computed columns (which can reference column A). You do not need to add column A in your selection. Fri, 26 Mar 2010 16:27:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71484#M7127 Technolero 2010-03-26T16:27:03Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71485#M7128 Sure...<BR /> I thought I had to drag all columns that my query will refer to....<BR /> It works all right now...<BR /> Thank you for your help and have a nice weekend, Fri, 26 Mar 2010 17:11:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-drop-a-column-from-the-output-table-using-the-Query/m-p/71485#M7128 LS 2010-03-26T17:11:15Z