Help using Base SAS procedures

exclude from select of format procedure

Reply
Regular Contributor
Posts: 208

exclude from select of format procedure

Hello all,

 

How to use select method to exclude the format that i don't need?

 

Thanks!

 

proc format library=library.formats cntlout=newdata;
select all but $noneed; /*I want $noneed to be excluded from my selection*/
Trusted Advisor
Posts: 1,399

Re: exclude from select of format procedure

Try next code:

proc format library=library.formats 
            cntlout=newdata(where=(locase(fmtname) ne "noneed");
select all;
run;
Regular Contributor
Posts: 208

Re: exclude from select of format procedure

Thank you Shmuel, but I want use upstream excluding instead of down stream.because I want save memory size.the where clause will not save any SAS memory size.

Thanks!
Super User
Posts: 9,687

Re: exclude from select of format procedure

Check EXCLUDE statement.
Ask a Question
Discussion stats
  • 3 replies
  • 120 views
  • 2 likes
  • 3 in conversation