Sex Age F 13 F 13 F 14 F 12 F 15 F 11 F 14 F 12 F 15 M 14 M 14 M 12 M 13 M 12 M 16 M 12 M 15 M 11 M 15 i have above dataset how derive extra record for maximum age like see below dataset Sex Age status F 11 F 12 F 12 F 13 F 13 F 14 F 14 F 15 F 15 F 15 maximum M 11 M 12 M 12 M 12 M 13 M 14 M 14 M 15 M 15 M 16 M 16 maximum
... View more
ods escapechar='~' ; ods pdf file='D:\phani\ss1.pdf' ; ODS PDF TEXT="~S={JUST=l FONT_SIZE=14pt COLOR=RED font_weight=bold FONT_FACE='Courier New' }SAS" "~S={JUST=l FONT_SIZE=14pt font_weight=bold COLOR=ORANGE FONT_FACE='Courier New' }COMMUNITIES"; ods pdf close ; I want to give two text formats with different colors in ods pdf text. If i run above program I dont get the result then how to get two formats at time
... View more
ods escapechar='~'; ods rtf file = "D:\phani\test.rtf" ; ods text='~S={width=100% preimage="D:\phani\Download.png"}'; ods rtf close ; if i run above program i get photo (sas logo) but it gives large photo how to decrease photo size
... View more
data ex1 ; input num ; cards; 3 4 5 ; is there any function or format like number convert to letters like see below dataset num num_in_letters 3 Three 4 Four 5 Five
... View more
Name Sex Age Alfred M 14 Alice F 13 Barbara F 13 Carol F 14 Henry M 14 James M 12 Jane F 12 Janet F 15 Jeffrey M 13 John M 12 Joyce F 11 Judy F 14 Louise F 12 Mary F 15 Philip M 16 Robert M 12 Ronald M 15 Thomas M 11 William M 15 The above dataset is sashelp.class dataset now I want to do age cumulative sum by sex wise in sql I did in datastep block but how to do in sql like see below dataset Name Sex Age cum_age Alice F 13 13 Barbara F 13 26 Carol F 14 40 Jane F 12 52 Janet F 15 67 Joyce F 11 78 Judy F 14 92 Louise F 12 104 Mary F 15 119 Alfred M 14 14 Henry M 14 28 James M 12 40 Jeffrey M 13 53 John M 12 65 Philip M 16 81 Robert M 12 93 Ronald M 15 108 Thomas M 11 119 William M 15 134 t
... View more
data ex3 ; input id $ test $ visit $ result ; cards ; 101 rbc visit1 222 101 rbc visit2 222 101 rbc visit3 300 101 wbc visit1 222 101 wbc visit2 222 101 wbc visit3 300 101 wbc visit4 300 102 rbc visit1 222 102 rbc visit2 222 102 rbc visit3 300 102 wbc visit1 222 102 wbc visit2 222 102 wbc visit3 300 102 wbc visit4 400 102 wbc visit5 400 ; I have one data set so now assign 'y' for which is maximum result value by test wise which is come first like see below data set id test visit result flag 101 rbc visit1 222 101 rbc visit2 222 101 rbc visit3 300 y 101 wbc visit1 222 101 wbc visit2 222 101 wbc visit3 300 y 101 wbc visit4 300 102 rbc visit1 222 102 rbc visit2 222 102 rbc visit3 300 y 102 wbc visit1 222 102 wbc visit2 222 102 wbc visit3 300 102 wbc visit4 400 y 102 wbc visit5 400
... View more
I know compress function and its modifiers like 'kp' 'ka' 'kd' , but couldn't find difference in below program what will happen if I run below program? data t ; name='jhon peter' ; a=compress(name,,'r') ; run;
... View more
