I will present this and other things at NESUG this year the following macro converts all nulls to zeros (that is what I needed) for eitehr a set of variables or for all numeric ones you can easilly modify it to convert string 'null' to '' (blank) without typing multiple lines of code, even if here was a function this is better as you do not need to write 100 of lines to process 100's of variables I attached a small  text file, for some reason I could nto paste code from my sas editor ... View more

Hi:   If you have code that worked in SAS 9.2 and the EXACT same code works differently or does not work in SAS 9.3, you should open a track with Tech Support. They can test your code in both versions of SAS and report to the developer if there is a problem that needs to be fixed. And, if there is a workaround for the issue, Tech Support will know what it is.   To open a track with Tech Support, fill out the form at this link: http://support.sas.com/ctx/supportform/createForm   In the meantime, these existing Tech Support notes might contain relevant information: http://support.sas.com/kb/16/727.html http://support.sas.com/kb/44/269.html http://support.sas.com/kb/41/165.html cynthia ... View more

Look at the paper by Art Carpenter at SUGI 27. http://www2.sas.com/proceedings/sugi27/p017-27.pdf ... View more

For a data driven approach : data have; input SampleID varname$ value1 value2 value3; datalines; 1     iron        0.7 1 0.05 1     copper      0.5 0 0.05 1     glycitin    532 1 200 1     glycitein   4.8 1 2 1     daidzein    5.76 1 2 1     daidzin     1200 1 200 1     genistein   4.8 1 2 1     genistin    2750 0 200 2     iron        1.2 0  0.05 2     copper      0.96 0  0.05 2     glycitin    478 0 200 2     glycitein   6.7 0 2 2     daidzein    7.5 0 2 2     daidzin     960 0 200 2     genistein   6 0 2 2     genistin    3000 0 200 ;   data tr; input varname :$32. var1 $ t1 t2 var2 $; datalines; TotalDaidzeinEquivalents daidzein 254.24 416.38 daidzin TotalGenisteinEquivalents genistein 270.24 432.38 genistin TotalGlyciteinEquivalents glycitein 284.46 446.41 glycitin ; proc sql; create table want as (select h1.sampleID, tr.varname, h1.value1 + tr.t1/tr.t2*h2.value1 as value1, h1.value2 + tr.t1/tr.t2*h2.value2 as value2, h1.value3 + tr.t1/tr.t2*h2.value3 as value3 from tr inner join have as h1 on tr.var1=h1.varname inner join have as h2 on tr.var2=h2.varname and h1.sampleID=h2.sampleID) union all (select SampleID, varname, value1, value2, value3 from have) order by sampleID, varname; drop table tr; select * from want; quit; PG ... View more

But you can use annotate macros to add this line . NOTE: It is from Arthur Carpenter's Book - Complete Guide to proc report. ods pdf style=printer file="c:\ch10_3_3.pdf" startpage=never; title1; proc report data=sashelp.class nowd; run; * Add the annotate macros to the autocall library; %annomac * Build the annotate data set; data Annolines; length function color $8; retain xsys ysys '5'; * Syntax for the LINE macro; %*LINE (x1, y1, x2, y2, color, line_type, size); %line(.5,69.6,50.5,89.6,blue,2,20) %line(.5,80.5,50.5,90.5,red,2,20) %line(42.2,67,62.2,104,green,2,20) run; * Use the annotate data set; proc gslide anno=annolines; run; quit; ods _all_ close; Ksharp ... View more