rolandberry's articles:

Items(436) /44 Next >> Last >|

SQL for deriving treatment emergent adverse events 0 24 (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 version 0 22 (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 %unistats 1 37 (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 suppression 0 21 (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 needed 0 41 (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 problem 3 41 (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 %unistats 0 33 (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 reporting 1 34 (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 want 0 20 (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 %xlblocks 0 44 (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

rolandberry's replies:

Items(1053) /106 Next >> Last >|

Micro Welding Machine 1 37 (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 value 4 25 (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)

Creating an observation with each date bewteen date1 and date2 1 39 (10/6/2011 12:57:02 PM) comp.soft-sys.sas Hi I have some data that are organised with a orgid, start date and end date. I want to end up with orgid and date, running from date1 to date2. Data smat; input Orgid date1 data2; datalines; 12001 1889... jesper.nyholm (3)

regular expression help 2 36 (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 problem 3 41 (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 names 6 39 (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)

Logical macro statements with double ampersands not resolving correctly 3 21 (11/19/2011 12:52:16 AM) comp.soft-sys.sas Hello, I am having difficulties getting the macro variable to resolve correctly when used within a logical statement. Here is a minimal working example: /* Data set that contains the records to be edited */ d... robin.a.jeffries (8)

Problem in returning a value from SAS macro 3 21 (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 %unistats 1 37 (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)

Reduce hard coding by using the VCOLUMN table in SASHELP to get a list of your variables into a macro variable array. 1 39 (1/31/2012 11:14:14 AM) comp.soft-sys.sas Very often it is useful to have a list of all the variables you have in a certain table. You don=92t always want to type them out yourself (hard coding) but instead want an automatically generated list based on... admin1606 (2)