I am trying to have the hanging footnote, which is properly wrapped according to my requirements. I am using "^R/RTF'\....." commands. I don't have much experience in this area and am looking for suggestions on achieving my requirements. In the following footnote 1, I want the wrapping of the text to happen after the ":" in the Text "Challenges:" just like how it happens with footnote 2. I don't know what number I have to give there so that it properly aligns. Thank you for your suggestions. How it generating: How I want options orientation = landscape errors = 2 missing = ' ' ls = 175 nofmterr nobyline noquotelenmax; ods escapechar = '^'; ods results on; ods listing close; ods rtf file = "xx\sample.rtf" ; title ""; PROC REPORT DATA= sashelp.class LS=145 PS=55 SPLIT="?" HEADLINE CENTER MISSING FORMCHAR(2)='_' ; ** titles **; footnote1 j = l "^R/RTF'\brdrb\brdrs '"; footnote2 j = l "^R/RTF'\li575\fi-575 'Challenges: This is a very long footnote characters greater than 230 which may need proper hanging indentation, it should have enough empty space, second line should align like the second footnote in this document."; footnote3 j = l "^R/RTF'\li575\fi-575 'Note: NVDIA have a very good quarter this year, which made approximately more than 250 Billion dollars which caused the raise in DOW in stock market."; ods rtf close; ... View more

I want to transpose the data and how I have and want. Is it possible? dates/time are in datetime16. format in have datasets. I really appreciate any help you can provide.   ... View more

 I have the  following dataset with Variables: Have dataset: Number -> Indicated the Actual Numerical Values Dec        ->Number of digits (numbers) after the decimals have to be displayed. Want Dataset: Number Char --> Character format of "Number" after the decimals  format applied. data have; input Number dec ; cards; 2.345 2 1.8 1 0 2 123.45 1 5.6781 2 ; run; Want dataset: ( I  wrote the Numberchar ,rounding/  may have error) Thanks in Advance   ... View more

I have the variable "Time" ( character text string) of minutes; I want to convert them into seconds ( numeric format). Unfortunately, I can not change the source data, and this is how it is written in the source. I appreciate your help. data have; time = "08:00"; output; time ="08:45"; output; time = "27:38"; output; time ="59:59"; output; run; Want   ... View more

Thank you for the help and your time.   I have the following time format in is8601 format(PT14M), which I want to convert into MM: SS (14:00) character format. if its PT2M then it should display as "02:00" data x; is8601 = 'PT14M'; output; is8601 = 'PT2M'; output /* mmss_char = "14:00";*/ run; ... View more