Hi,
If we have columns which are in sequence then how can we use it in select statement
For example
If i have id1-id24 then in proc sql how to use the sql statement
proc sql noprint;
create table test as
select id1-id24
from dummy;
quit;
i want to use some thing like that.Can any one let me know how can i use that in sql select statement.
proc sql noprint;
create table test as
select *
from dummy (keep=id1-id24);
quit;
Hi,
I am also having an inner join with other table and i am picking some other values as well in this table
instead of writing dumm1,dumm2,dumm3 i want to write like dumm1-dumm24 in sql.
proc sql
create table test as
select dumm1.info,dummy1.pro
dumm2.peter,dumm2.marta,dumm1-dumm24
from
dummy1 innre jon dummy2
on (dumm1=dumm2);
Your proc sql statement has too many errors and ambiguities to show a correct example, but you can use select * and then, on the 2nd from the bottom line, add (keep=) statements after each filename.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.