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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.