I am trying to derive a variable based on the age in my dataset. Is there an easy way to  use and apply the formats with out writing "IF" and  "THEN" conditions? Thank you for your responses. data sas; set sashelp.class; length group4 $20.; if age < 12 then do; group4= '<12 years'; group4n = 1; end; else if 12=< age <13 then do; group4= '>=12 to <14 years'; group4n = 2; end; else if 13=< age <14 then do; group4= '>=14 to <15 years'; group4n = 3; end; else if age >= 14 then do; group4= '>=15 years'; group4n = 4; end; run; ... View more

I want to have a break in the spanning line between the categories ( Indicated n the Image in Red).  Is it possible to do that? Thank you for your suggestions. data check; pla = '80'; drug= '100'; col1=' Total'; pla_pct= '80.0'; drug_pct = '100'; run; ods _all_ close; options orientation = landscape errors = 2 missing = ' ' nobyline; ods escapechar = '^'; Ods results on; ods rtf file = "c:temp\check.rtf" style = custom; proc report data=check ls = 145 ps = 55 split = "?" headline center missing formchar(2) = '_' ; title1 j = l "Table 1"; column ("^R/RTF'\brdrb\brdrs '" col1 ("(*ESC*)S={borderbottomcolor=black borderbottomwidth=2} category" ("(*ESC*)S={borderbottomcolor=black borderbottomwidth=2} Placebo ?(N=)" pla pla_pct ) ("(*ESC*)S={borderbottomcolor=black borderbottomwidth=2} Drug ?(N=.)" Drugdrug drug_pct))); define col1 / 'Statistics' order style(header) = [just=l] id ; define pla / "count" style(header) = [just=c] style(column) = [just=c vjust=b cellwidth=11% asis=on] ; define pla_pct / "Percent" style(header) = [just=c] style(column) = [just=c vjust=b cellwidth=11% asis=on]; define drug / "count" style(header) = [just=c] style(column) = [just=c vjust=b cellwidth=11% asis=on] ; define drug_pct / "Percent" style(header) = [just=c] style(column) = [just=c vjust=b cellwidth=11% asis=on]; run; ods rtf close; ods listing close;   ... View more

I want to create a dataset like an image. It checks multiple datasets and gives information about which dataset has which variable. This dataset I eventually use it to export to keep track of variables present in all datasets. How can I achieve this? For this purpose, I am only giving two datasets, but these can sometimes be 20- 30 datasets. Thank you for your suggestions and tips data have1; age = 12; name = "Ram"; height =170; run; data have2; age = 12; name = "Ram"; weight =156; run;   ... View more

I have a dataset that will be sent to ods rtf output. I want to compare the dataset with mine, Some variables have characters that are used to create white space or 'ESC" for reporting.  I am not sure how to remove them. I tried to compress and translate functions to manipulate. but I am having difficulty removing them."(*ESC*)R'\par '" is the extra string that I want to remove. When I used to compress it removing breakers (parenthesis) for others. How I can achieve this? Thank you for your suggestions. Also what exactly does this String  (*ESC*)R'\par ') do?   data chk; have = "55 (43.8%)(*ESC*)R'\par '92"; want = "55(43.8%)92"; run;     ... View more

I am aware of the importance of  January 1 1960 in SAS (considers them as Birthday), SAS stores the days counting from this particular date.                 I am not  100% sure but when sometimes I used the wrong date format / informat I used to see this date in my datasets. Can you guys please share some information on this and also provide an example where we see January 1, 1960, in the dataset because of giving the wrong format / informat?   Thanks in advance ... View more