Hi , I have this code: PROC TABULATE DATA=HAIM.HAIM_PIDIONOT ; VAR SUM_PIDION count_policy; CLASS TOCHNIT_BITUACH / ORDER=UNFORMATTED MISSING; CLASS PERIOD / ORDER=UNFORMATTED MISSING; TABLE PERIOD all = 'סה"כ' , TOCHNIT_BITUACH *( SUM_PIDION * Sum={LABEL=' '}*F=COMMA14. count_policy * Sum={LABEL=' '}*F=COMMA14. SUM_PIDION ={LABEL='אחוז משורה '}* ColPctSum={LABEL=' '} ) ; ; RUN; My problem is when i give the ColPctSum *f=percent6. im not getting what i expected . For example : 2.6 > im getting 260% > i want to get 2.6% Is there any options doing it like i want? ... View more

Hi , I build this proc report : ods html file="\\risuilt\home\sas\MISHNE_LIFE\demografic.html"; proc report data=aaa nowindows out=t; title demografic period; column age gender, count ; define age/group; define gender/across format=$H_GENDER8.; define count/sum format=comma12.; run; quit; ods html close; Some of the result is: male female age 1 . 15 im trying to change the nulls to zero any suggestions? ... View more

Hi , I have data with vat that contains both numbers and laters. For example : abc efgh 13 . Is There a function that can separate between numbers and laters ?? ... View more

HI , for example i have this data: data a; input a b; cards ; 1 2 3 4 5 6 7 8 ; run; i want my output will be like this : 1 2 . . 3 4 . . 56 . . thanks in advance, ... View more

HI , I made simple proc report like this: proc report DATA=M_HAIM.TRANSPOSE_REINSURANCE ; column _NAME_ period,REINSURANCE_COMP , ( &measures ); define _NAME_ / order=data group 'measures' format=$M_H_row. ; define PERIOD/ order=data across 'PERIOD' NOZERO format=M_H_COLUMN. ; define REINSURANCE_COMP / across ''; define "0"n / sum format=comma12.2 'no- REINSURANCE_COMP' ; define A / sum format=comma12.2 'A '; define C / sum format=comma12.2 'C '; define D / sum format=comma12.2 'D '; define P / sum format=comma12.2 'P '; define RR / sum format=comma12.2 'RR '; rbreak after/summarize; compute after ; _NAME_='total'; endcomp; run; my problem is : the measures are dynamic . in each run i can get more/less/different measures. using dictionary.columns table l can bring all the columns into macro var, and then use it in the column statment. but i dont know what to do with the define statment..... any suggestions? ... View more

Hi, for example l have the folowing data: agent x y A 3 5 B 2 4 C 7 3 I want my output be like this agent x y A 3 5 A 3 4 A 3 3 A 3 2 A 3 1 B 2 4 B 2 3 B 2 2 B 2 1 C 7 3 C 7 2 C 7 1 I try to do it without sucess ,can anybody help me? ... View more

Hi , this is my first time im using proc report.... my problem is this: my data for example is: data a; length zip $ 5 cty $ 8 varr $ 10; input zip $ cty $ varr $ sales cost; label zip="Zip Code" cty="country" varr="variety" sales="monthly sales"; datalines; 52423 Scott Merlot 186 35 52423 Scott Chardonnay 156.61 33 52423 Scott Zinfandel 35.5 38 52423 Scott Merlot 55.3 90 52388 Scott Merlot 122.89 80 52388 Scott Chardonnay 78.22 90 52388 Scott Zinfandel 15.4 12 52200 Adams Merlot 385.51 120 52200 Adams Chardonnay 246 167 52200 Adams Zinfandel 151.1 180 52200 Adams Chardonnay 76.24 190 52199 Adams Merlot 233.03 175 52199 Adams Chardonnay 185.22 155 ; run; im trying to create a new column that divide sales with cost proc report data=a; title sample10; column cty zip varr,(sales cost example); define cty/group width=9 'country/name'; define zip/group 'îé÷åã'; define varr/across 'variety'; define sales/sum format=6.2 'ñëåí îëéøåú'; define example/computed; compute example; example=sales/cost; endcomp; run; then new column is getting in all the rows null. can someone please explain me how to do it (if its possible with this example)? Thanks in advance ... View more