|
> proc sql;
> reset inobs=5;
> select * from sashelp.class where sex='F';
> reset inobs=max;
I tried this and it runs. It does not, however, restrict the rows.
> >PROC SQL FEEDBACK;
> > CREATE &vt WORK.&_filename AS
> > SELECT *, COUNT(*) AS ob_num
> > FROM &_dir..&_filename(WHERE=(bus_type='SF'))
> > WHERE CALCULATED ob_num LE 1000;
> >QUIT;
>
> IT depends on what you mean by "work". If you change the SQL WHERE clause to
> a HAVING clause, the code should run.
Substituting the HAVING clause in, my SQL runs but I get an empty
dataset.
Stephen
| 
