Proc sql select variable question

[Mike_Davis]

Hello everyone,

How to use proc sql to create a dataset in the new dataset I just want select all but one variables from old dataset?

In this example,I don't want variable s0377 list in the select statement.  Also I don't want to use drop statement as :...create table one(drop=s0377) ...or.... from sashelp.Yr1001(drop=s0377).....

Thanks

Proc sql noprint;

create table one as

select *

from sashelp.Yr1001

;

quit;

[Haikuo]

well, if not using drop, then try this:

proc sql;

select name into :name from dictionary.columns separated by ',' where libname='WORK' and MEMNAME='ONE' AND  name ne 'S0377'; quit;

Proc sql noprint;

create table one as

select &name

from sashelp.Yr1001

;

quit;

Haikuo

[FloydNevseta]

Another option:

Proc sql noprint;

create table one as

select *

from sashelp.Yr1001

;

alter table one

drop s0377

;

quit;

But why don't you want to use the DROP= option? Generally, it's less coding and more efficient.