schimpanski@GMX.DE wrote: > >Hi, > >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. > >PROC sql; >alter table tossfam3 >modify >* label = ''; >quit; > >Thanks ins advance, > >Will > >PS >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.

HTH, David -- David L. Cassell mathematical statistician Design Pathways 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/