Hi,   ive made a dataset and changed the format of all columns with digits into char-format. Example:   Insgesamt_sum_char = put(Insgesamt_sum,numx20.);     Reason: If the digit (of a the variable Insgesamt_fz) is <71, the cell should get a "/" instead of the numeric result. Is the result >71 and <119 then put the result into parentheses.For example:     if Insgesamt_fz <71 then do; Insgesamt_sum_char="/";end; if Insgesamt_fz >=71 and Insgesamt_fz <=119 then do; Insgesamt_sum_char="("||strip(Insgesamt_sum_char)||")"; end;   Afterwards I export the result into a excel-file. This works pretty well and I get the correct results in a nice file (and it wouldnt work, if the column-format would be numeric). But nevertheless I have a problem: I open the exported excel-file and click into a Cell with a parenthesized value. By unselecting that cell, the parenthesized value changed into a minus value. For example: The correct value is (1,0). By clicking and unselecting that cell it changed to -1 (parentheses vanished).   Why is that happen? Do you know a way, to avoid this? ... View more

Hi,   I tried several options but it doesnt work for me. What I want: A hole row shall be bold, if one column has a specific value. For example with the sashelp.cars-data: I want to have a bold row, if the Make-Value is "Kia". Thank you for help!     proc tabulate data=sashelp.cars; class make type; var msrp; table make,type*msrp; run; ... View more

Hi,   I want to build a table with proc-tabulate and want to construct it with one single step. But I dont know, if this is actually doable. For example: The columns shall represent the the number of men. Thr first line shall be the number in general, the second shall be the number of men with a height>60 and the third one shall give me the number of men with an height >60 and a name, that starts with an "J". As you can see: I have multiple filters. My hope: Are multiple where-conditions within one proc-tabulate or within the table-statement possible? I tried different things but it didnt work.   So: Do you have a solution, to combine these 3 have-datasets? Thank you!   proc tabulate data=sashelp.class; class sex age; table sex, age; where sex="M"; run; proc tabulate data=sashelp.class ; class sex age; var height; table sex, age; where sex = "M" and height>60; run; proc tabulate data=sashelp.class ; class sex age; var height; table sex, age; where sex = "M" and height>60 and name like "J%"; run; ... View more

Hello, my dataset has ~100 columns. I want to order the columns alphabetically with sql or sas-code (the Column with the number 1 shall appears first, 2 second and so on)... Is it implementable with little code?   Thank you!   Data have: 5 3 2 50 6 8 7 … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … … …   data want: 2 3 5 6 7 8 50 … … … … … … … … … … … … … … … … … … … … … ... View more