[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    SAS Forum: (elegant solution) Delete all Columns that contain a certain String
From:       Roger DeAngelis <rogerjdeangelis () GMAIL ! COM>
Date:       2017-03-31 14:03:40
Message-ID: 7528077390351850.WA.rogerjdeangelisgmail.com () listserv ! uga ! edu
[Download RAW message or body]

SAS Forum: (elegant solution) Delete all Columns that contain a certain String

see
https://goo.gl/PYQZ4k
https://communities.sas.com/t5/Base-SAS-Programming/Delete-all-Columns-that-contain-a-certain-String/m-p/346141


very slight change with drop statement

proc sql noprint;
  SELECT name INTO :dropMe SEPARATED BY ' '
  FROM sashelp.vcolumn
  WHERE libname = 'YOURLIB' AND
                memname = 'HAVE' AND
                prxmatch('/het$/i', strip(name)) > 0;
quit;

data want;
  set have(drop=&dropMe);
run;


[prev in list] [next in list] [prev in thread] [next in thread]