SQL for deriving treatment emergent adverse events024 (3/21/2012 8:11:51 AM) comp.soft-sys.sas I hope this is right. I can not claim to be an SQL expert. But in the example it works as expected. If there is a problem in the SQL then please let me know. http://www.datasavantconsulting.com/roland/sql_use.... RolandRB
proc report width= for the utf-8 version022 (3/6/2012 6:04:24 PM) comp.soft-sys.sas I was playing around with proc report on a utf-8 version and when I give a column with using the width= option it is strictly the number of bytes and not the number of characters. How do I get round this? ... RolandRB
Lab reporting using %unistats137 (1/8/2012 1:03:27 PM) comp.soft-sys.sas There are now 3 pages on the Spectre web site to show you how to do lab reporting using the %unistats macro. The new third page covers a very complicated requirement that is solved very easily. http://www.data... RolandRB
Q: proc report "across" variable line suppression021 (12/23/2011 6:00:19 PM) comp.soft-sys.sas Is there any way of suppressing the line taken up by an "across" variable when used in proc report? I know that you can give it a space label (" ") but it still takes up the line while showing nothing. Is it po... RolandRB
Asian version of my %splitvar macro needed041 (12/22/2011 7:15:23 PM) comp.soft-sys.sas I have a macro that is useful for aligning text that flows onto following lines. However, it only works for Western character sets where one letter is stored in one byte. For most asian languages it turns into ... RolandRB
strange format problem341 (11/14/2011 6:00:04 PM) comp.soft-sys.sas Any idea why I don't get the "#" at the end in the second case? 74 proc format; 75 value p63val 76 low-0.999-high=">0.999" 78 OTHER=[6.3] 79 ; 80 run; 81 82 data _null_; 83 length str $ 8; 84 str=trim(put(1,p... RolandRB
t Test and Satterthwaite approximation added to %unistats033 (11/7/2011 8:12:09 AM) comp.soft-sys.sas Maybe I should have done this years ago but I finally got round to adding use of the t Test (rather than ANOVA) with a control for the Satterthwaite approximation to my %unistats macro. This was in response to ... RolandRB
%aetab for multi-level AE reporting134 (11/3/2011 6:05:43 PM) comp.soft-sys.sas I have a new macro named %aetab for multi-level AE reporting. It can currently cope with nine levels. Five obvious levels are "System Order Class", "High Level Group Term", "High Level Term", "Preferred Term" a... RolandRB
put whatever stats value you want where you want020 (10/4/2011 4:16:40 PM) comp.soft-sys.sas I know you probably don't know the options you need to set for "proc freq" to get out the different stats values nor the names of the variables in the ODS tables created (sometimes they exist as Name1 Value1 va... RolandRB
2nd attempt at %xlblocks044 (9/23/2011 7:20:48 AM) comp.soft-sys.sas I have rewritten the main logic for %xlblocks. It reads an Excel spreadsheet with blocks of information and writes each block as a numbered dataset. http://www.datasavantconsulting.com/roland/Spectre/utilmacro... RolandRB
Micro Welding Machine137 (9/6/2011 6:03:08 AM) comp.soft-sys.sas Dear Sir/Madam Greetings. We are manufacturers on an innovative welding machine "Pocket Size Welding Machine" which carries the brand name Microweld. This product will take the industrial sector by storm, with... g22manalili(6)
Permanent macro value425 (9/20/2011 11:05:46 PM) comp.soft-sys.sas Hi All, I have a question, don't know if this is possible or not, but thought to give a try. If you assign a value to a macro variable then is there any way to make it permanent. For example if i assign value ... vdudhe.13(8)
regular expression help236 (10/12/2011 9:29:30 AM) comp.soft-sys.sas Hi All, wonder if someone can help with this regex. i want to match... zero or more occurrences of digits, followed by zero or one occurance of periods, followed by zero or more occurrences of digits --- my sy... rifazrazeek(84)
strange format problem341 (11/14/2011 6:00:04 PM) comp.soft-sys.sas Any idea why I don't get the "#" at the end in the second case? 74 proc format; 75 value p63val 76 low-0.999-high=">0.999" 78 OTHER=[6.3] 79 ; 80 run; 81 82 data _null_; 83 length str $ 8; 84 str=trim(put(1,p... rolandberry(1872)
Create a Macro Variable with all column names639 (11/15/2011 2:25:58 AM) comp.soft-sys.sas I want to create a Macro Variable with all column names. For example: A dataset has the columns: Col1, Col2, Col3 I want to create a Macro Variable: &Col=Col1 Col2 Col3 How to create it automatically? Cause ... litonchen(27)
Problem in returning a value from SAS macro321 (12/30/2011 3:51:44 AM) comp.soft-sys.sas I wrote a very short macro to extract the attribute of any sas dataset. It is basically just calling ATTRN function, but I included the data set open and close steps in the macro so I don't have to write it aga... zhiweiwang(16)
Lab reporting using %unistats137 (1/8/2012 1:03:27 PM) comp.soft-sys.sas There are now 3 pages on the Spectre web site to show you how to do lab reporting using the %unistats macro. The new third page covers a very complicated requirement that is solved very easily. http://www.data... rolandberry(1872)