topic Re: exclude from select of format procedure in SAS Procedures

exclude from select of format procedure

GeorgeSAS — Sun, 13 Aug 2017 19:07:22 GMT

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*/

Re: exclude from select of format procedure

Shmuel — Sun, 13 Aug 2017 20:01:39 GMT

Try next code:

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

Re: exclude from select of format procedure

Ksharp — Mon, 14 Aug 2017 12:35:19 GMT

Check EXCLUDE statement.

Re: exclude from select of format procedure

GeorgeSAS — Mon, 14 Aug 2017 20:08:09 GMT

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!