Hello members, I created macro variable (CAT1) from proc sql select into. And want to use it in the data step in the do loop: &SUB._CAT[J]=&&CAT&J.; It does not work. Where did I do wrong? Thanks! ----------------- proc sql; select rc into :CAT1 from rc2 where Objective_1="&subj." and Question_No='11'; quit; %put RC1 = &CAT1;   data tpsalt3;    set tpsalt2;    array &SUB._CAT {&ITEM_TOT.} $ &SUB._CAT1-&SUB._CAT&ITEM_TOT.;    do J=1 to &ITEM_TOT.;       &SUB._CAT[J]=&&CAT&J.;    end;   drop J; run;   ... View more

Hello members, I want to create histograms from different data sets with the same vertical and horizontal axes (e.g., same min, max, unit). I used the proc freq as below. However, I did not find a way to adjust the min, max, unit of the histogram. are there other procedures to do it. Can anyone please help? proc freq data=data; tables score/plots=freqplot; run; Many thanks! ... View more

Hello members, How can I clear the results and outputs generated by the procedures within a macro? For example, for the following code. How can I only keep the data2 in within the macro and clear the intermediate results generated by % macro bydomain (conditon1=a, condition2=b); before run % macro bydomain (conditon1=c, condition2=d);?   Data data2; set data1; run;   % macro bydomain (conditon1, condition2); data data2; ... run;   %mend; % macro bydomain (conditon1=a, condition2=b); % macro bydomain (conditon1=c, condition2=d); ...   Thanks so much!!! ... View more

Hello members, Can you please help me find out what's wrong with the red part? Thanks!!!!!   %macro cov (cutt,cutc); %do i=1 %to 2; data covA&i.; infile "&pathr.WS1_A.rep&i..sc" FIRSTOBS=3 OBS=43 missover pad; input rawA&i. 5-6 thetaA&i. 10-15; run; data covB&i.; infile "&pathr.WS2_B.rep&i..sc" FIRSTOBS=3 OBS=43 missover pad; input rawB&i. 5-6 thetaB&i. 10-15; run; data conAB&i.; merge covA&i. covB&i.; diffA&i.=abs(thetaA&i.-&cutt.); diffB&i.=abs(thetaB&i.-&cutt.); run; proc print data=conAB&i.;run; proc sql noprint; select min(abs(thetaA&i.-&cutt.)) into :minthetaA&i. from conAB&i. where thetaA&i.>=0; select min(abs(thetaB&i.-&cutt.)) into :minthetaB&i. from conAB&i. where thetaB&i.>=0; quit; %put minimum thetaA diff is &&minthetaA&i.; %put minimum thetaB diff is &&minthetaB&i.; proc sql noprint; select rawA&i. into :rawA&i. from conAB&i. where diffA&i.= &&minthetaA&i.; select rawB&i. into :rawB&i. from conAB&i. where diffB&i.= &&minthetaB&i.; quit; %put raw cutA is &&rawA&i.; %put raw cutB is &&rawB&i.; data cut&cutc.&i.; cutrawA=&&rawA&i.; cutrawB=&&rawB&i. ; run; %if &i=1 %then %do; data cov&cutc.;set cut&cutc.&i.;run;%end; %else %do; data cov&cutc.;set cov&cutc. cut&cutc.&i.;run; %end; %end; %mend; %cov (cutt=0, cutc=zero); %cov (cutt=0.5,cutc=low);     ------------------------- log----- WARNING: Apparent symbolic reference RAWA1 not resolved. raw cutA is &rawA1 WARNING: Apparent symbolic reference RAWB1 not resolved. raw cutB is &rawB1 NOTE: Line generated by the macro variable "I". 1 &rawA1 - 22 WARNING: Apparent symbolic reference RAWA1 not resolved. NOTE: Line generated by the macro variable "I". 1 &rawB1 - 22 WARNING: Apparent symbolic reference RAWB1 not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.CUTLOW1 may be incomplete. When this step was stopped there were 0 observations and 4 variables. WARNING: Data set WORK.CUTLOW1 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): ... View more

Hello,   I have a categorical variable RESP like this ' AB++++B+BD+A++BCDB++++B++A+B++A++BC++B+B+D   I want to recode the 42 columns into 42 numerical variables, such as if substr(RESP, 1, 1) = '+ ' then score1=1; else if substr(RESP, 1, 1 )= '*' then score1=0; else score1=0;   How to code this using array and do loop?   Thanks!!! ... View more

Hi all, I used the following code to replace numeric missing with 0 in 52 items. this procedure is repeated for 10 times. however, in the final saved output, the field of the 52 items is blank. only id and bucket variable are there. What is the problem? Thanks!   %macro missing (form,group,percent,type);   %do i=1 %to 10; FILENAME datain "&path.F&Form._m&percent..rep&i..txt"; FILENAME out_r "&pathout.F&Form._m&percent..rep&i..txt"; /*-------------------------------read in data file--------------------------------------------------------*/ data F&Form._m&percent.rep&i.; infile datain; input @1 ID 4. @6 (i1-i&TotalItems) (1.) @59 bucket 3.; ; run;   proc sql noprint; select count(bucket) into : loopnum from F&Form._m&percent.rep&i. where bucket=0; quit; %put "the number of loop is:&loopnum.";   /*-------------- generate missing for bucket=0 students --------------------------------------------------*/ data F&Form._&type._m&percent.rep&i.; set F&Form._m&percent.rep&i.; array iVars i1-i52; array idx idx1-idx48; if _N_<=&loopnum. then do until (cmiss(of iVars[*])=48); call missing(iVars[ceil(52*rand('uniform'))]); end; drop idx:; run;   data _null_ ; set F&Form._&type._m&percent.rep&i.; %if bucket=0 %then %do; %do j=1 %to 52; array items i1-i52; array que it1-it52; %if items[j]=. %then que[j]=0; %else que[j]=items[j]; %end; %end; FILE out_r lrecl=5000 nopad DLM=''; PUT @1 ID 4. @6 (it1-it&TotalItems) (1.) @59 bucket 3.; run ; %end; %mend missing; %missing (form=A, group=100,percent=1,type=&type.);       ... View more