topic Re: Proc sql select variable question in SAS Procedures

Proc sql select variable question

Mike_Davis — Tue, 15 May 2012 15:09:17 GMT

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;

Re: Proc sql select variable question

Haikuo — Tue, 15 May 2012 15:20:03 GMT

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

Re: Proc sql select variable question

FloydNevseta — Tue, 15 May 2012 16:19:25 GMT

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.