id sale 101 5 101 14 101 . 102 45 102 78 102 58 102 69 102 89 102 .   assign sum id wise into missing values like see below   id new 101 5 101 14 101 19 102 45 102 58 102 69 102 78 102 89 102 339 ... View more

data s ; set sashelp.class ; t=min(age,_n_) ; run;   what is meaning of   t=min(age,_n_)  ? ... View more

subid Date Dose P101 13JAN2005 Asp-05mg P101 19JAN2005 Asp-10mg P101 25JAN2005 Asp-15mg P101 31JAN2005   P102 14JAN2005 Asp-10mg P102 20JAN2005 Asp-05mg P102 26JAN2005 Asp-15mg P102 01FEB2005 Asp-15mg P103 19JAN2005 Asp-15mg P103 25JAN2005 Asp-10mg P103 30JAN2005 Asp-10mg P104 26JAN2005 Asp-10mg P104 02FEB2005 Asp-10mg P105 02FEB2005 Asp-20mg   derive every group last record without missing like see below dataset subid Date Dose P101 25JAN2005 Asp-15mg P102 01FEB2005 Asp-15mg P103 30JAN2005 Asp-10mg P104 02FEB2005 Asp-10mg P105 02FEB2005 Asp-20mg ... View more

ods rtf file='D:\phani\dd.rtf'; proc report data=sashelp.class nowd ; column name age sex height weight ; title 'students data' ; options nodate nonumber ; run; ods rtf close ;     if i run above program it will give rtf file but how to assign background photo in rtf like  see attached file rtf file didn't upload due to file size so i uploaded pdf file ... View more

I have libray . library name is Main. Main library has some many datasets .In those datasets some datasets contain only variables there is no data and some datasets has data. My question is how to know which datasets have data and which datasets haven't data at time ... View more

data s1 ; input id $ dose ; cards ; 101 22 101 23 101 24 102 43 102 23 102 11 102 22 103 22 103 22 ;   i have date like see above i want to data keep like see below  group(id) wise sum id dose total 101 23 69 101 24 . 101 22 . 102 11 99 102 22 . 102 23 . 102 43 . 103 22 44 103 22 . ... View more

data main ; infile cards dlm=',' ; input name $33. age ; cards ; dfhis dfhwejw kssdhf,22 sdfhlas ksglk saglas jhassdfjgish,23 dhjs sdhf,22 ; when i run above program it gives wrong data  how to solve that one? ... View more

data s ; name='a@b@c' ; new=scan(name,2,'@') ; run;   i run above program in 9.2 sas version it gives default length 200 but if i run same program in 9.4 sas version it gives same length like name length is 5 and new variable length is also 5. can you explain that difference? ... View more

data have; input mem $ frequency percent; datalines; M 240 24.0 M 320 32.0 F 120 12.0 M 80 8.0 C 68 6.8 M 42 4.2 C 130 13.0 ; run; HOW TO DO SUM BY MEM(GROUP VARIABLE) WISE IN DATA STEP BLOCK? GROUP VARIABLE IS MEM LIKE SEE BELOW  EX1: mem frequency percent C 68 6.8 C 130 13 C 198 19.8 F 120 12 M 42 4.2 M 80 8 M 240 24 M 320 32 M 682 68.2   EX2: mem frequency percent C 68 6.8 C 130 13 TOTAL 198 19.8 F 120 12 M 42 4.2 M 80 8 M 240 24 M 320 32 TOTAL 682 68.2 ... View more

data s ; wishes='happy new year                   happy birthday                          congrats my baby ' ; run;   if we run above program it gives record keep in two lines but i want to data keep in three line as we give data data in three line and same  structure one by one line ... View more

data s ; set sashelp.class ; run;   if i forget run the program but at particular time it will be run by using task schedule in windows  how can i do? ... View more