SAS AMO 7.1 use Column of Excle Sheet as Filter of the Data source

Criptic — Fri, 02 Aug 2019 09:56:19 GMT

Hello,

is it possible to have a column that is filled with some values let's say A is filled with 'BMW', 'Audi', etc. and I want to filter sashelp.cars where make in A1:A10 is this possible? And if it is possible how?

Kind regards

Criptic

Re: SAS AMO 7.1 use Column of Excle Sheet as Filter of the Data source

Criptic — Tue, 06 Aug 2019 05:20:55 GMT

So I pocked around a lot more in the documentation and couldn't find a way to do it. But I stumbledupon the possibility to input data via a StoredProcess from Excel - thanks to this very helpful video: https://video.sas.com/detail/video/3862907101001/use-microsoft-excel-data-as-input-to-a-stored-process.

This solved my problem and I hope it might help somebody with a similar question further down the road.

Coding to copy paste:

libname XcelData xml;

data work.input_excel_1;
	set XcelData.&_WebIn_SASName;
run;

topic SAS AMO 7.1 use Column of Excle Sheet as Filter of the Data source in Microsoft Integration with SAS

SAS AMO 7.1 use Column of Excle Sheet as Filter of the Data source

Re: SAS AMO 7.1 use Column of Excle Sheet as Filter of the Data source