you will need a comma in the by statement.
create table shell as select * from locations, years order by location year;
should be
create table shell as select * from locations, years order by location, year;
... View more
This should work. You are copying local macro variables up to your RSUBMIT server session.
signon task&threadnum inheritlib=(risk);
%syslput _all_;
rsubmit wait=no log="&basedir./task&threadnum..log" output="&basedir./task&threadnum..lst";
%put _all_;
endrsubmit;
... View more
This table is too big for PROC SORT or SQL .
I would suggest other method to sort data:
data F M;
set sashelp.class;
select(sex);
when('F') output F;
when('M') output M;
otherwise;
run;
data want;
set F M;
run;
... View more