Each row contains Max or Min (intervened 1-by-1). How to get the range , in data step ?!   Sample code, with dataset, is below.   data _temp(rename=(i=bloc)); do i=1 to 20; if mod(i,2)=1 then do; var_min=-ranuni(i)*100; var_max=0; end; else do; var_max=ranuni(i)*100; var_min=0; end; output; end; run;quit; %let selvar=var; data _temp; set _temp; if _N_>=0 then do; if &selvar._min<-0.0001 then do; &selvar._range= lag(&selvar._max)- &selvar._min; t_max=lag(&selvar._max); end; else if &selvar._max> 0.0001 then do; &selvar._range= &selvar._max - lag(&selvar._min); t_min=lag(&selvar._min); end; end; run;quit; ... View more

I have code below, trying to show up refence line for y2axis. But it does not work. Any one know how?!   data test; do i=1 to 1000; x=i; y1=sin(i*3.14159/100)*10+100; y2=cos(i*3.14159/100); output; end; run;quit; %let xvar=x; proc sgplot data=test; series x=&xvar. y=y1/ lineattrs=(color=blue thickness=2.0 pattern=solid); series x=&xvar. y=y2/y2axis lineattrs=(color=pink thickness=1.2 pattern=solid); refline 100 /axis=y2axis lineattrs=(color=red thickness=2.0) ; run;quit; ... View more

I have code, generates 4 macro variables and print them out into a file.   The code works fine, not in a MACRO. When inside MACRO it always complains[see below].   Anyone?!   %macro macroit(); proc sql noprint; select round(md3,0.001) into: val_md3 from &plotds. having ind=max(ind); select round(md3_ema_e,0.001) into: val_md3_ema from &plotds. having ind=max(ind); select round(md3y,0.001) into: val_md3y from &plotds. having ind=max(ind); select round(md3y_ema_e,0.001) into: val_md3y_ema from &plotds. having ind=max(ind); quit; %put "val_md3=&val_md3. val_md3y=&val_md3y."; data _out_c; input mvar $20.; val_out_=dequote(resolve(quote(mvar))); ind=_N_; datalines; &val_md3 &val_md3_ema &val_md3y &val_md3y_ema run;quit; data _out_c(keep=val_out_final); set _out_c; if ind>0 then val_out_2=substr(mvar,2,length(mvar)); else val_out_2=mvar; if ind>0 then val_out_final=trim(val_out_2)||"="||strip(val_out_); else val_out_final=mvar; run;quit; data _out_c_0; input val_out_final $80.; datalines; [value] run;quit; data _out_c; set _out_c_0 _out_c; run;quit; proc export data=_out_c(keep=val_out_final) OUTFILE='C:\\sinx_out.ini' DBMS=DLM REPLACE; DELIMITER=','; PUTNAMES=NO; RUN; %mend; %macroit(); MPRINT(MACROIT): proc sql noprint; MPRINT(MACROIT): select round(md3,0.001) into: val_md3 from _ECL_MD_sin having ind=max(ind); NOTE: The query requires remerging summary statistics back with the original data. MPRINT(MACROIT): select round(md3_ema_e,0.001) into: val_md3_ema from _ECL_MD_sin having ind=max(ind); NOTE: The query requires remerging summary statistics back with the original data. MPRINT(MACROIT): select round(md3y,0.001) into: val_md3y from _ECL_MD_sin having ind=max(ind); NOTE: The query requires remerging summary statistics back with the original data. MPRINT(MACROIT): select round(md3y_ema_e,0.001) into: val_md3y_ema from _ECL_MD_sin having ind=max(ind); NOTE: The query requires remerging summary statistics back with the original data. MPRINT(MACROIT): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MLOGIC(MACROIT): %PUT "val_md3=&val_md3. val_md3y=&val_md3y." "val_md3= -1.193 val_md3y= -0.884" MPRINT(MACROIT): data _out_c; MPRINT(MACROIT): input mvar $20.; MPRINT(MACROIT): val_out_=dequote(resolve(quote(mvar))); MPRINT(MACROIT): ind=_N_; MPRINT(MACROIT): datalines; ERROR: The macro MACROIT generated CARDS (data lines) for the DATA step, which could cause incorrect results. The DATA step and the macro will stop executing. NOTE: The data set WORK._OUT_C has 0 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(MACROIT): - -1.053 -0.884 -0.769 run; NOTE: Line generated by the macro variable "VAL_MD3". 1 -1.193 ------ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(MACROIT): quit; MPRINT(MACROIT): data _out_c(keep=val_out_final); MPRINT(MACROIT): set _out_c; MPRINT(MACROIT): if ind>0; MPRINT(MACROIT): ; MPRINT(MACROIT): ; MPRINT(MACROIT): ; ERROR: The macro MACROIT will stop executing. MLOGIC(MACROIT): Ending execution. ... View more

How to re-assign column order in dataset?!   Proc Transpose generates column with order depends on the order of each value popping-up, see below.  Anyway to enforce order inside PROC?!   ... View more

Using Proc IMPORT to readin huge CSV files with lots of columns.   Say the CSV file has 100 columns and ONLY like to readin the first 90 columns, how to do it?! Here is DATAROW option... but no DATACOLUMN option, or right?! ... View more

refline 2800/axis=x lineattrs=(color=red thickness=2.0); DOES one reference line inside SGPLOT. I am running a macro, need generate SGPLOT with multiple reference lines and the values are varied (upto macro outcome).  Anyone knows how, assume the macro saves out reference line values into a set of macro variables, refvalues.  ... View more