How to specify selected variables based on the common prefix of variable's names in proc import?

[Cruise]

Hi All, 

I'm using proc import to read in my excel data to SAS. I have many variables and would like to drop variables with names starting with raw_. 

How can I achieve to allow limited variables based on the common prefix of variable names in the proc import or in data step using the data imported if doing this in proc import was impossible? 

Thank you very much for your time. 

Cruise

proc import 
datafile="mydata_Jan11.xlsx"
out=ipd
dbms=xlsx replace;
getnames=yes;
run;

[novinosrin · Accepted solution]

proc import 
datafile="mydata_Jan11.xlsx"
out=ipd(drop=raw_:)
dbms=xlsx replace;
getnames=yes;
run;

drop=raw_: