>how can I delete all variable labels in a dataset, preferably with PROC
>sql? How do I refer to all variable (cf. _all_) within PROC sql. The
>syntax below does not work.
>alter table tossfam3
>* label = '';
>Thanks ins advance,
>I'd like to do the data management in a consistent way with only one
>approach, ie. proc sql.
Since lots of people have addressed the main points, I would like to
kvetch about your PS. If you *really* want a unified data management
approach, then you ought to use PROC DATASETS instead. That's
what it is designed for.
But I would recommend that you re-think your overall data management
scheme. SAS is a 4GL that provides a wide variety of tools for a wide
variety of tasks. I do not think that every data management task is
going to be best-served by the same proc. Some processes will have
procs which best address the problem, some will be better done with
a data step, and some will be best done outside SAS entirely. So don't
force yourself into a straitjacket, even if your middle name is Houdini.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Donít miss your chance to WIN $10,000 and other great prizes from Microsoft
Office Live http://clk.atdmt.com/MRT/go/aub0540003042mrt/direct/01/