BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Criptic
Lapis Lazuli | Level 10

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

1 ACCEPTED SOLUTION

Accepted Solutions
Criptic
Lapis Lazuli | Level 10

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;

View solution in original post

1 REPLY 1
Criptic
Lapis Lazuli | Level 10

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;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Discussion stats
  • 1 reply
  • 847 views
  • 0 likes
  • 1 in conversation