Anyone know if it is possible, and if so, how to select all columns of
a table except one? Many times I work with PHI and want to create a
data set consisting of a real patient ID number and a “fake” ID number
linked to the real one. So I create another table containing both,
then drop the real one, usually in a DATA step. I would like to do
this in SQL somehow without having to type all the column names.
Essentially I would like to say “SELECT * except RealID FROM TABLE…”