How about proc sql pass through? ... View more

Would you try like this proc import datafile='H:\Model_Building\data.txt' dbms=dlm out=work.test replace; delimiter=","; getnames=yes; guessingrows=500; run; ... View more

It might  be helpful to you http://support.sas.com/techsup/technote/ts673.pdf ... View more

data dataset1; input var1 var2 var3 var4 var5; datalines; 1 3 65 63 77 1 2 65 63 66 2 2  2  2  2 2 2  2  2  2 ; proc sort data=dataset1; by var1 var2 var3 var4 var5; run; data dataset2(keep= var1 var2 var3 var4 var5 count); set dataset1; by var1 var2 var3 var4 var5; if first.var5 then count=0; count+1; if last.var5 then output; run; /*or*/ proc sql; create table dataset2 as select var1,var2,var3,var4,var5,count(*) from dataset1 group by var1,var2,var3,var4,var5; run; ... View more

As said friedEgg data dataset1; input var1 var2 var3 var4 var5; datalines; 1 3 65 63 77 1 2 65 63 66 2 2  2  2  2 2 2  2  2  2 ; proc sort data=dataset1; by var1 var2 var3 var4 var5; run; data dataset2(keep= var1 var2 var3 var4 var5 count); set dataset1; by var1 var2 var3 var4 var5; if first.var5 then count=0; count+1; if last.var5 then output; run; ... View more

Agreed Fried Egg. ... View more

data dataset1; input var1 var2 var3 var4 var5; datalines; 1 3 65 63 77 1 2 65 63 66 ; proc sort data=dataset1; by var1 var2 var3 var4 var5; run; data dataset2(keep= var1 var2 var3 var4 var5 count); set dataset1; by var1 var2 var3 var4 var5; count+1; run; ... View more

I am pretty sure that these two schools for these particular programs they are using only SAS http://spears.okstate.edu/graduate/datamining/ http://analytics.ncsu.edu/ thanks ... View more

use the options as explained here. http://support.sas.com/rnd/app/examples/ets/missval/index.htm ... View more

http://www2.sas.com/proceedings/sugi30/236-30.pdf ... View more

http://www.lexjansen.com/pharmasug/2011/tt/pharmasug-2011-tt15.pdf ... View more

http://support.sas.com/onlinedoc/913/docMainpage.jsp ... View more

your original data might be dynamic. it might be updating very frequently. are you getting data from RDBMS? or SAS data mart. There are little chances that your SAS data mart also refreshes very frequently. First confirm where you are getting data? ... View more