The runs test is available in the autoreg procedure which does support by-processing. It should go like; proc autoreg data=myData; by myByVariable; model myVariable= / runs; run;   Note proc autoreg requires licence to SAS/ETS. ... View more

You can try the following code( as single is your original data set ) data new ; set single; do i=1 to 2; output; end; run; proc print data=new(drop=i) noobs; run; ... View more

> I get the following error message every time I run a > count model using proc countreg. Also the procedure > stops and no output is generated. Does anyone have > any suggestions.... > > proc countreg data = work.test1 method = qn; > model y = &I_VAR. /dist=zinegbin; > zeromodel y ~ ; > output out =test2 pred = Fit; > run; > > The follwoing error appears: > > NOTE: Convergence criterion (FCONV=2.220446E-16) > satisfied. > NOTE: At least one element of the (projected) > gradient is greater than 1e-3. > ERROR: Floating Point Zero Divide. > ERROR: Termination due to Floating Point Exception > NOTE: The SAS System stopped processing this step > because of errors. I use version 9.2. Thanks for the info.....I will follow up with the SAS tech folks. ... View more

Thanks a lot to Ksharp as well.....This code also does the job.... Thanks Guys!!! ... View more

Sorry for the late reply Patrick and Ksharp. My apologies. Both codes worked brilliantly. Thanks a lot for your help. DB ... View more

Or something like this?... data somedata; input x y z1 $ z2; datalines; 1 2 a 1 2 4 b 1 3 5 c 1 4 9 a 2 5 4 b 2 6 8 c 2 ; run; symbol1 v=dot i=join c=red; symbol2 v=dot i=join c=blue; proc gplot data=somedata; plot y*x=z2; run; ... View more

Thanks Cynthia and Robert for your suggestions... ... View more

You will need to generate the SAS code and use CREATE TABLE, or consider a DATA step approach where you can create more than one SAS member/table with a single pass of an input file, again with your SAS macro code needing to generate the DATA statement parameters and associated OUTPUT statements. Scott Barry SBBWorks, Inc. ... View more

Thanks for your reply. I was able to fix the issue with the sysevalf condition in the appropriate place. ... View more