i have a datset  data test; input store sales; cards; 1 . 1 200 1 300 1 . 2 . 2 300 2 150 2 560 3 900 3 560 3 . ; run; i want the first non missing value of each store? ... View more

store  sales 1 100 1 110 1 200 2 200 2 300 2 100 i want cumulative sales of store with proc sql  store sales 1 100 1 210 1 410 2 200 2 500 2 600 how cant i get this result using proc sql? ... View more

In linear regression we have y=b0 +b1x  where bo is the itercept and b1 is the slope.   b1=y2-y1/x2-x1 ,by this we get the slope and b0 we get by putting the x=0   In multiple linear regression we have Y=b0+b1x1+b2x2+b3x3 now here how can we get the intercept and slope?? For intercept do we need to put x1,x2 and x3 all to 0?? ... View more

Adj R2=1- (1-r2)(N-1)/N-p-1   where N=total sample size         p=no of predictors          r-coeff of determination    If i get a negative adj r2 then what can i conclude from that?? ... View more

data t; input sno category$ 20.; cards; 1 dairy floor eggs 2 floor milk 3 eggs bread 4 bread butter butter ;run;   i have this data set and i want distinct category (dairy,floor,eggs,milk,bread,butter). I can do like this data t1; set t; do i=1 to 3; x=scan(category,i); output; end; run; proc print;run; but here i dnt knw how many times i have to run the loop like 3 or 4 or 5 times.Any optimum way?   ... View more

      %macro ab(lib,ds); %do i=1 %to 3; %let x=%scan("&ds",&i,','); proc print data=&lib..&x; run; %end; %mend; %ab(test ,test1 ) %macro ab; proc sql; select distinct memname into:a separated by ',' from dictionary.columns where libname="PAWAN" and memname like"A%"; %let x=&sqlobs; quit; %do i=1 %to x; %let x=%scan("&a",&i,'i'); proc print data=pawan..&x; run; %end; %mend; %ab;  in the first macro i'm getting error but in the second it is working fine?? why %scan is not working in the first macro???what's the logic ... View more

%macro nn(dt); %do i=1 %to 3; %let x=%sysfunc(scan("&dt",&i,','); %put &x; data t; set &x; run; proc print;run; %end; %mend; %nn(one,two,three); want to print all the three data sets,getting error that More positional parameters found than defined. ... View more