proc freq data=sashelp.class noprint ; table sex*age/out=freq(drop=percent) ; run; if i run above program it gives like see below  Sex Age Frequency Count F 11 1 F 12 2 F 13 2 F 14 2 F 15 2 M 11 1 M 12 3 M 13 1 M 14 2 M 15 2 M 16 1   but i want to data like see below (use proc report) type total M 10      11 1      12 3      13 1      14 2      15 2      16 1 F 9      11 1      12 2     13 2     14 2     15 2 ... View more

ods rtf file='D:\sss\ss.rtf' ; proc report data=sashelp.class nowd ; column name age sex height weight new_height; define sex/group ; define height/order ; define new_height/computed ; compute new_height; new_height=height*2 ; endcomp ; rbreak after /summarize dol dul ; run; ods rtf close ;   if i run above program it gives sum results like age,weight but how to calculate value of new_height variable ... View more

data s1 ; name=22122018 ; run; proc sql ; select input(put(name,best.),ddmmyy10.) as date format=ddmmyyd10. from s1 ; quit;     if run above program it gives 22-12-2020 but i want as it is date  ... View more

data s ; input a1-a3 ; cards ; 5 10 5 10 20 10 ; proc sql ; select avg(a1) as average from s ; quit; or  proc sql ; select avg(of a1-a3) as average from s ; quit;   by using proc sql i got average either column wise or row wise . how to calculate average in datastep block? ... View more

libname ex excel 'E:\sas\dime\xls\data3.xls' ; data s; set ex."Sheet1$"n; run; proc print data=ex.'sheet1$'n; run;     the above program doesn't work . how to solve? ... View more