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;
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
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.