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

[Criptic]

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

[Criptic · Accepted solution]

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-proce...

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;