Hello, Below code extracts all the SAS datasets and the number of observations and variables in each dataset. %macro obsnvars(lib=); %if &lib= %then %let lib=WORK; %else %let lib=%upcase (&lib); proc sql; select memname,nobs,nvar from dictionary.tables where libname="&lib" and memtype="DATA" and memname not in ('_PRODSAVAIL'); quit; %mend obsnvars; ... View more

I am not sure why the complete post is not visible. Please edit to view the complete post. I think this works: data a b c d e; set act.talent nobs=t; /*In my case I am interested in 5 data sets */ t1=round(t/5); if _n_<=t1 then output a; else if _n_<=t1*2 then output b; else if _n_<=t1*3 then output c; else if _n_<=t1*4 then output d; else if _n_<=t1*5 then output e; run; The above code is useful when you want to create less number of datasets from the input data set. Its better to use the below macro code: %macro numofdatasets(no); %do i=1 %to &no; data _&i; set act.talent nobs=t; /*In my case I am interested in 3 data sets */ t1=round(t/&no); if t1*(&i-1) < _n_ <=t1*&i then output _&i; run; %end; %mend; %numofdatasets(5); You can change the number of data set you want to create easily in the macro call. But the last data set will have less obervations if the number of observations is not a multiple of the number of datasets required. Message was edited by: SAS333 Message was edited by: SAS333 Message was edited by: SAS333 ... View more

"Zoom off; Submit" this command restores down the program editor window and runs the code. So that you can see the log running. This will be useful when you are working on Proc Download. ... View more

Ctrl+G doesn't work as it works as go to line by default. Try assigning "SUBMIT" to CTR+J. This works perfectly. ... View more