Hi, I have 8 observations of clinical results expresed in expenential counts (e.g., 1.94E+4) plus their corresponding log values within parentheses, e.g., (4.29) in a chracter string. I would like to parse this string and extract the two sets of values into two separate variables (counts, logCounts). I think a perl or scan function can help me with this. A "no results" would also be carried forward to the variable.   string                             wanted result: Counts          wanted result: logCounts "1.94E+4 (4.29)"            1.94E+4                               4.29 "5.54E+4 (4.74)"            5.54E+4                              4.74 "1.19E+4 (4.08)"            1.19E+4                              4.08 "2.76E+4 (4.44)"             2.76E+4                             4.44 "8.29E+4 (4.92)"             8.29E+4                             4.92 "< 2.00E+1 (1.30)"          <2.00E+1                           1.30 "2.99E+5 (5.48)"             2.99E+5                              5.48 "No results found"           No results found                 No results found   I am running SAS 9.4 on Windows 7.    Thanks   --tim ... View more

Hi, I have a string variable (var) that contains a sequence of characters or numbers. I wish to assign to another to variable (seq) a sequence of numbers that are embedded in this number, usually between two non-numeric delimiters (e.g., '/' or '-'). For example,  var=14025/1258/669. I would like save to seq the charater 1258. The problem that I have is the first set of numbers vary in length as does the seq I want to save.   Here is a theoretical database;   var                                              seq (I want to save) ---                                               ------------------------ 14025/1258/669                         1258 145890/0048/4458                     0048 1212/1-1515                               1 14589/49/1247                           49 124/12458/1                               12458 4545-00001-999                         00001 45*784CH21                               784   I think SAS string functions may help (e.g., find, index). If anyone can solve I'd appreciate as always. Thanks.   Using 9.4, 64-bit under Windows 7 --Tim ... View more

Hi, I have some data, lets say three observations: ID     firstname     lastname       bdate               residence     sex      score1     score2     score3     newdate 001     James         Jones          24Aug1986       Urban          M          200          458          1.25     05May2012 002     Suzie          Smith            10Mar1982       Rural           F          .               1285         0.86    04Feb2015 003     Henry          Marks           01Jun1972       Rural           M         246             324        2.06     24Sep2014 I would like to produce output that will show the data transposed, and display a report, one observation per page. In addition, I would like to display column heading and add comment fields. As an example for obs 1.: Variable Name          Value                         Comment1               Comment2          Comment3 ID                              001 firstname                    James lastname                    Jones bdate                         24Aug1986 residence                   Urban sex                            M score1                       200 score2                       458 score3                       1.25 newdate                     05May2012 Page 1 then a second page would display Suzie Smith's data (obs 2), etc.The comment fields are place holders for comments to be completed late. I wonder if the transposition can be accomplished in proc transpose or SQL. Then an output file using proc report. Thanks for you help community. --Tim ... View more

Hi all, I have two databases - one of which is has 25 individual member observations with  4 variables (vars1-vars4). Each observation is identified by a unique ID number (id). Obs id var1 var2 var3 var4 1 860880007 2 . . . 2 860880013 . 1 1 2 3 860880015 . 1 1 2 4 860880023 2 . . . 5 861560006 . 1 1 1 6 861560009 . 1 1 2 7 861560012 . 1 1 2 8 861560013 . 1 1 2 9 861560017 1 1 1 2 10 861560030 1 1 1 2 11 861560031 2 . . . 12 861560040 . 1 1 2 13 861560041 . 1 1 2 14 861780002 2 . . . 15 861780012 2 . . . 16 861780013 2 . . . 17 861780024 . 1 1 2 18 861780027 2 . . . 19 861780036 1 1 1 2 20 861780050 . 1 1 2 21 861780053 1 1 1 2 22 862440006 1 2 . . 23 862440007 1 1 1 2 24 862440016 . 1 1 2 25 862440025 . 1 1 2 I have a second database - a paired database (12 observations) - in which each observation represents a pair of members that may have a corresponding member data in the database above. Each member of the pair is identified by a unique ID (one called left_id, the other right_id): Obs left_id right_id 1 861560006 861560005 2 861560013 861560012 3 860900004 860900003 4 861560031 861560030 5 860880024 860880023 6 861560041 861560040 7 861780013 861780012 8 861780002 861780001 9 861780050 861780049 10 862440007 862440006 11 862440016 862440015 12 862988001 862988000 I would like merge the data from the individual member database (if present) to the paired database with the structure below. I would like each left/right variable list to be populated with corresponding data from the individual database (filled in the first two rows as an example). The output database should have 12 observations like the paired database. If data are not available for one or both members of the pair then the var should be missing (see observation 12 on the paired database which does not have a corresponding individual data for either member). Obs left_id left_var1 left_var2 left_var3 left_var4 right_id right_var1 right_var2 right_var3 right_var4 1 861560006 . 1 1 1 861560005 . . . . 2 861560013 . 1 1 2 861560012 . 1 1 2 3 860900004 860900003 4 861560031 861560030 5 860880024 860880023 6 861560041 861560040 7 861780013 861780012 8 861780002 861780001 9 861780050 861780049 10 862440007 862440006 11 862440016 862440015 12 862988001 862988000 Any solution using data step and Proc SQL would be much appreciated. Thanks community. --Tim ... View more

Hi, I wonder if someone can offer a solution to my problem of assigning SAS formats to a list of variables. I So, have a list of variables with a variety of SAS variable naming conventions (e.g., SEX, AGE_GROUP, var1-var100, a1A, a1B, etc.). I also have formats for each variable using the name of the variable plus an 'f' suffix as a naming convention (e.g., SEXf, AGE_GROUPf, var1f, a1Af, etc). Instead of writing a format statement that assigns the format for each variable (e.g., format var1 var1f.;) I wonder if it is possible to do this with a %array and a macro statement. Thanks in advance. --Tim ... View more