topic Re: Can we copy the Filters of the EG Query builder like values to a data set in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233305#M16898 The filters are likely stored as macro variables, so you need to determine the macro variable names required and you can store them in data set. Thu, 05 Nov 2015 19:20:07 GMT Reeza 2015-11-05T19:20:07Z Can we copy the Filters of the EG Query builder like values to a data set https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233300#M16897 <P>Hi Team</P> <P>&nbsp;</P> <P>I have a requirement where I need to copy the Filters that are used in a query builder to a variable in a data set.</P> <P>&nbsp;</P> <P>Thanks</P> <P>Kiran</P> Thu, 05 Nov 2015 18:54:00 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233300#M16897 ykk 2015-11-05T18:54:00Z Re: Can we copy the Filters of the EG Query builder like values to a data set https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233305#M16898 The filters are likely stored as macro variables, so you need to determine the macro variable names required and you can store them in data set. Thu, 05 Nov 2015 19:20:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233305#M16898 Reeza 2015-11-05T19:20:07Z Re: Can we copy the Filters of the EG Query builder like values to a data set https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233328#M16901 <P>Thanks for the reply.</P> <P>&nbsp;</P> <P>My query builder contains a mix of Prompts and Static Filters that were added.I could not find any macro variable for the filters.Does it require any settings change to my EG.I had used %put _ALL_ to list down all the macro variables.</P> Thu, 05 Nov 2015 20:19:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233328#M16901 ykk 2015-11-05T20:19:41Z Re: Can we copy the Filters of the EG Query builder like values to a data set https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233447#M16906 I think they're called Parameters in EG, you don't see a parameter for each filter? Fri, 06 Nov 2015 15:36:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233447#M16906 Reeza 2015-11-06T15:36:30Z Re: Can we copy the Filters of the EG Query builder like values to a data set https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233557#M16911 <P>I am not using prompts in the Filter.I have a Filter which says EMP_ID IN (123,456) and DEPT_ID =20.&nbsp; I all those filters to be extracted.</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 06 Nov 2015 20:56:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233557#M16911 ykk 2015-11-06T20:56:50Z Re: Can we copy the Filters of the EG Query builder like values to a data set https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233565#M16912 <P>Those are hardcoded then. I don't think they're included anywhere so you'll have to hardcode them into your output file.&nbsp;</P> Fri, 06 Nov 2015 21:22:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-copy-the-Filters-of-the-EG-Query-builder-like-values-to-a/m-p/233565#M16912 Reeza 2015-11-06T21:22:44Z