Hi.i am running a macro function in sas9.4 , when i execute the macro function for small data it gives me the correct answer but when i enter a big data which is 12000 columns it gives me error that the file is damaged and the processing did not completed .why it does not process?is it because of lack of memory capacity ?.appreciate any help.     ... View more

hi all. how can i use a macro function which should be executed  inside another macro function ,because the result of inside macro function is needed to be used in the outside macro function .is there any way to do that .if anyone knows that i will appreciate to share it with me. thanks, ... View more

Big DATA Imports[ New ]   Options     data alaki;    do trt = -1 to 1 by 2;      do gene = -1 to 1 by 1;        do time=1 to 3;           input responder@;           output;        end;      end;    end; datalines; 4.22027067    4.37189508    4.42832633     12.342489    12.3535905    12.2709339     6.10929307    6.34392243    6.43155656     4.43362232    4.54115629    4.2886178 12.6404601    12.715388    12.7065314 6.07044046    6.06052994    6.11873577 ; run; proc print;run;   hello.my question is how i can read my data as a seperate sas dataset in the above program,and then use set statement to read from this new dataset instead of using datalines ,because my data is big data and i can not place it in datalies .i used proc import but it gives me header ,and considers it as  columns which do loop doesn't realize it .if anybody knows the answer we appreciate to share it.   thanks ... View more

hello. please look at my coding and correct my mistake.i want to generate 100 samples from a normal distribution with mean of 0 and standard deviation of 10 and  construct two 95% confidence intevals for the mean under assumption of known variance and unknown variance seperately  for each sample and mark thoes intervals that do not cover mean 0 ,by three stars***. i want to have 20 observations for this prosse.i want to use sas macro language.  here is my coding: data x; input mean n std upcl lowcl alpha=alpha t0 z0 tu tl zu zl; datalines; run; %macro mymac; %let macvar=one; %do j=1 to 20; data one; %do i=1 %to 100; %let x=rannor(-1)*10+0; %output; label &x=''; %end; %let dat=mycvar; proc means data=&dat mean clm std n; %run; data two ; set stat (drop =_TYPE_ _FREQ_); alpha =.05; t0=tinv(1-alpha/2,n-1); z0=probit(1-alpha/2); zu=mean+z0*(10)/sqrt(n); zl=mean-z0*(10)/sqrt(n); tu=mean+t0*std/sqrt(n); tl=mean-t0*std/sqrt(n); run; %let lc=lc; %let uc=uc; %let b=&lc*&uc; %let eval_b=%eval(&b); %put &b is &eval_b; %macro compare(b,0); %if &b>0 %then %put label &x='***'; %else %if &b<0 %then %put label &x=''; %mend compare; %compare(0,&b) %end ; %mend; proc append base=x data=two; run; data print; call execute('proc print data=mymac;run;'); run;     ... View more