%let Ctx = "LotId;P110123; DuploWaferId;D02; Operation; 1000-OxideDepostion!1!0"; In this example this are always pairs. I want a table with columns LotId DuploWaferId Operation with the correct values. I tried already a few things, but what is the best way? %let CtxFormat="CtxName;CtxValue"; %let Ctx = "LotId;P110123; DuploWaferId;D02; Operation; 1000-OxideDepostion!1!0"; data _null_; aantal = %sysfunc(countw(&CtxFormat,';')); call symputx('aantal',aantal); run; %put &aantal; data _null_; aantal = %sysfunc(countw(&Ctx,';')); call symputx('aantalvar',aantal); run; %put &aantalvar; data format;     array format{&aantal} $20.; i = 1;     do while (scan(&CtxFormat,i,';') NE ''); format{i} = scan(&CtxFormat,i,';'); i = i +1; end; run; data colnames(keep=vname);   set format (obs=1) ;   array n{*} _NUMERIC_ ;   array c{*} _CHARACTER_ ;   do i = 1 to dim(n) ;     vname = vname(n{i}) ;     output ;   end ;   do i = 1 to dim(c) ;     vname = vname(c{i}) ; output;   end ; run ; proc sql; select vname into:cols separated by ' ' from colnames where vname ne 'i'; quit; %put &cols; proc transpose data=format out=formattransp(keep=format1) prefix=format; var &cols; by i; run; data _null_; set formattransp; if upcase(format1) = "CTXNAME" then call symputx('PlaceName',_N_); if upcase(format1) = "CTXVALUE" then call symputx('PlaceValue',_N_); run; %put &PlaceName &PlaceValue; /* read values */ /* aantal = number of blocks per variable */ /* aantalvar = number of variables in ctx */ /* PlaceName = Place of the name of the variable */ /* PlaceValue = Place of the value of the variable */ data temp_variables;     array format{&aantalvar} $50.; i = 1;     do while (scan(&Ctx,i,';') NE ''); format{i} = compress(scan(&Ctx,i,';')); i = i +1; end; run; data colnames(keep=vname);   set temp_variables (obs=1) ;   array n{*} _NUMERIC_ ;   array c{*} _CHARACTER_ ;   do i = 1 to dim(n) ;     vname = vname(n{i}) ;     output ;   end ;   do i = 1 to dim(c) ;     vname = vname(c{i}) ; output;   end ; run ; proc sql; select vname into:cols separated by ' ' from colnames where vname ne 'i'; quit; %put &cols; proc transpose data=temp_variables out=temp_variables_transp(keep=format1) prefix=format; var &cols; by i; run; data column_names(drop=teller) column_values(drop=teller); set temp_variables_transp; retain teller; if _N_ = 1 then teller = 1; if teller = &PlaceName then output column_names; if teller = &PlaceValue then output column_values; if mod(_N_,&aantal) = 0 then do;   teller = 0; end; teller = teller + 1; run; proc sql; select format1 into:columns separated by ' ' from column_names; quit; %put &columns; ... View more

My axis goes fromzero to the maximum of V. The problem is this does not prints the points from 0.0 to0.135 for V /* Define symbolcharacteristics */ axis1label=("Current Density(mA/cm²)")       width=2         style=0         order=(0to &DmaxValue by 2); axis2       label=("Voltage(V)")       width=2         style=0         order=(0to &VmaxValue by 0.1); procgplot       data=all_data;       plot&plotstatement   /overlaylegend=legend1                                           href=0 vref=0 vaxis=axis1 haxis=axis2; ; run; ... View more

I want to pass variables through a Stored Process Url, what is the max length of my url? ... View more

First question: aligning output All my graphs are placed in the center, i want them left /* general graph settings */ goptions reset=all border cback=white htitle=12pt; OPTIONS DEV=activex;     ODS MARKUP     STYLE=     CODEBASE="http://imecwww/~sas/EG/sasgraph.exe"     FILE=_webout     ;    ods html file=_webout (title="&run_id View ") stylesheet=(URL="http://imecwww.imec.be/~osp/fab300/CSS/ImecStyleProcReport.css"); /* graphs to display JSC Voc Eta FF */ title1 'Overview Voc (mV)'; proc gchart data=wacom_graphs;      VBAR Measurement /  width = 3.5 sumvar=VocD type=sum discrete autoref ; run; quit; title1 'Overview JSC '; proc gchart data=wacom_graphs;      VBAR Measurement /  width = 3.5 sumvar=JSCD type=sum discrete autoref ; run; quit; title1 'Overview Efficiency (%)'; proc gchart data=wacom_graphs;      VBAR Measurement /  width = 3.5 sumvar=EtaD type=sum discrete autoref ; run; quit; title1 'Overview Fill Factor (%)'; proc gchart data=wacom_graphs;      VBAR Measurement /  width = 3.5 sumvar=FFD type=sum discrete autoref ; run; quit; ods html close; ----------------------- Second question (other graphs - up to 10 overlay graphs) The goal is that the curves will cut the x and y axis.  How can I do this, now they start at -2 or something. /* Define symbol characteristics */ axis1 label=("I")       width=2; axis2       label=("V")       width=2; legend1 label=none         position=(top center inside)         mode=share; proc gplot data=all_data; plot &plotstatement   /overlay legend=legend1        haxis=axis1                             vaxis=axis2        vzero hzero ; run; ... View more

I have a proc report where I want to replace the column name by define Jsc / 'Jsc (mA/cm2)'; but it splits after JSC? ... View more

i have a stored process which gets id's it looks like 17,18,19 for example now what i want to do here is to append them all to the same dataset but with different variable names (A_17, A_18 , B_17, B_18 ) but at this point it already fails to read my do while statement any help? %macro CreateGraphData; %let i = 0; %do %while (scan(&curve_id,&i,',') NE ''); current_id = scan(&curve_id,&i,','); data wacom_&i; set RF300l3.wacom_main; where curve_id = current_id; run; data wacom_&i (drop = A B); set RF300l3.wacom_data; where curve_id = current_id; A_&i = A; B_&i = B; run; if &i = 1 then do; data all_data; set wacom_&i; run; end; else do; proc append base=all_data data=wacom_&i force;run; end; %let i = &i + 1; %end; %mend; %CreateGraphData; ... View more