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

Cruise — Mon, 11 Jan 2021 21:17:33 GMT

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;

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

novinosrin — Mon, 11 Jan 2021 21:25:09 GMT

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

drop=raw_:

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

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

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