Help using Base SAS procedures

Proc sql select variable question

Reply
Regular Contributor
Posts: 222

Proc sql select variable question


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;

Respected Advisor
Posts: 3,156

Re: Proc sql select variable question

Posted in reply to Mike_Davis

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

Frequent Contributor
Posts: 101

Re: Proc sql select variable question

Posted in reply to Mike_Davis

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.

Ask a Question
Discussion stats
  • 2 replies
  • 240 views
  • 6 likes
  • 3 in conversation