Hi, Im using Proc Print to create a report. The Output is in text format: options ps=45 ls=250 nodate nocenter ; proc printto file="&tmpdir.Patient Summary - &label..txt" new; run; proc print data=all_pat noobs ; var text; by pat; where hospno>=3067 and hospno<=3072; pageby pat; run; proc printto; run; At the begining of each page im getting the string "txt". I dont know how to get rid of it... Any ideas? ... View more

Hi, Is there a way to give a style only to the values of the 'TOTAL'.? proc report data=a nowindows headskip ; column visit_char (n); define visit_char/group ; rbreak after/summarize style={foreground=blue}; /*-this option also highligths the 'TOTAL'.....*/ compute after; visit_char='Total' ; endcomp; where visit in(0,1,2) and code in(314,303); quit; ODS RTF close ; ... View more

Hi, I made this code: ods html file= "xxxx.html" proc report data=temp nowindows noheader headskip nowd missing ; column pt txt; define pt /order left ; define txt /group width=150 ; compute after txt; line ' '; endcomp; compute after pt; line ' '; endcomp; compute before ; line @50 'Repeat Error'; line ''; endcomp; run; ods html close; Im trying to foreground the 'Repeat Error' with red color without succes.... I tried to use call defined after the compute before statment-its not working. Any ideas? Thanks in advanced ... View more

Hi, Let say I have: data test; w="8,5"; run; I want to convert the variable w to numeric but to numeric with period and not with comma . the result should be 8.5. I wanted to do it only with input function (not to use scan/translate function before). Is there a way to do it (a appropriate format)? Thanks in advance ... View more

Hi, Is there a diffrence between using Input function and zero ? ... View more

Hi i took this simple example to explain my problem: In axis1 i have varaible sex and in axis2 i have varaible weight i want to get my output without the labels values ' f ' and 'm' belong to varaible sex - i want it to be empy .... what could be the way to make it work? data a; set SASHELP.CLASS; run; Axis1 label=none STYLE=1 WIDTH=1 MINOR=NONE ; Axis2 STYLE=1 WIDTH=1 ; PROC GCHART DATA=a ; VBAR Sex / SUMVAR=Weight CLIPREF FRAME TYPE=SUM COUTLINE=BLACK RAXIS=AXIS1 MAXIS=AXIS2 ; RUN; ... View more

Hi , I have this simple code : proc report data=sales nowindows; column name zip sales; define name / group; define zip/group; define sales/sum format=6.2; run; The ouput is html. e.g : jonatan 6061 200 8080 400 jeni 2020 700 3040 800 My question : Is it possible to generate output like this : jonatan 6061 200 jonatan 8080 400 jeni 2020 700 jeni 3040 800 I tried to find a solution on the web and i couldnt find... Any suggestions? Thanks in advance , ... View more