Table of contents:

• & and the delimiter (2 messages)
• Any clever way to find if a char field contains anything that isn't a number? (3 messages)
• Automatic reply: Test for measuring trend
• COMMA. (2 messages)
• Content-type: text/html (4 messages)
• Convert data view to data set (6 messages)
• Converting Narrow Data Set to Wide Data Set (6 messages)
• Counting Max Trails using Level by ID (4 messages)
• DSD and the ending missing values (3 messages)
• Directly reference dataset created view lost the reference? (4 messages)
• FW: Internet2 Connection Established
• Framington Score
• Fwd: Much Faster Bootstraps Using SAS? -- Yes, the fastest to date... (3 messages)
• Fwd: Resolving macro variable in macroname
• Fwd: proc sql
• Hash vs OBS= (How to make a tie, not a winner) (4 messages)
• How to read this instream/raw data (2 messages)
• I got it RE: identify starting and ending column numbers
• ICD9 CM Removing large blocks text (3 messages)
• Importing .xlsx files with worksheet names >29 characters (2 messages)
• Incorporating a Baseline Hazard for a Binomial Logit
• Input reading beyond specified length. (7 messages)
• Job opening (NYC)
• NLMIXED Output combinations (2 messages)
• NLMIXED and GLIMMIX -Beta distribution
• New Computer
• Nonlinear optimization
• OT: Thursday Theory (2 messages)
• PRINT fileref in the FILE statement? (5 messages)
• Parsing regular table (3 messages)
• Proc Freq Horiz and Verticle lines
• Proc SQL left join speed being affected significantly by option (rename=)? (5 messages)
• Q: new computer (2 messages)
• RES: understanding spatial autocorrelation
• Resolving macro variable in macroname (8 messages)
• SAS code for calculating Framingham Risk Score (2 messages)
• SAS time (6 messages)
• Test for measuring trend (3 messages)
• Use symput to make a macro var (6 messages)
• Using value of a macro variable into another macro? (6 messages)
• X and Y in ODS REGION statement (PDF destination)
• [Poll] Your analytic career: how do you see yourself at 55? (4 messages)
• appropriate regression model for 12 level categorical response variable?
• change macro variable name dymacro? (5 messages)
• class statement in Proc PRINT (5 messages)
• coefficients for random effects (2 messages)
• data merging question (7 messages)
• dollar9. and comma9. (3 messages)
• duplicates emails from SAS-L (10 messages)
• equivalent of an offset in proc mixed (5 messages)
• file shortcuts question remade (2 messages)
• formatted input vs column input
• funny code, formatted input or list input or neither (2 messages)
• how to convert one variable into multiple columns according its value? (2 messages)
• how to get macro variable length (4 messages)
• identify starting and ending column numbers (11 messages)
• input statement vs. put statement (2 messages)
• length of numeric variables (12 messages)
• new computer (3 messages)
• output, loop, PDV (3 messages)
• proc report (3 messages)
• proc sql (6 messages)
• random functions (3 messages)
• reminder: EG v4.1 dies on Dec 1, 2010
• the d value of an informat, as in w.d or comma9.d (4 messages)
• variable-length records (3 messages)
• versions of SAS 9.2 (4 messages)

1. & and the delimiter
   • & and the delimiter (37 lines)
   • Re: & and the delimiter (52 lines)

2. Any clever way to find if a char field contains anything that isn't a number?
   • Re: Any clever way to find if a char field contains anything that isn't a number? (47 lines)
   • Re: Any clever way to find if a char field contains anything that isn't a number? (52 lines)
   • Re: Any clever way to find if a char field contains anything that isn't a number? (89 lines)

3. Automatic reply: Test for measuring trend
   • Automatic reply: Test for measuring trend (11 lines)

4. COMMA.
   • COMMA. (34 lines)
   • Re: COMMA. (41 lines)

5. Content-type: text/html
   • Content-type: text/html (40 lines)
   • Re: Content-type: text/html (50 lines)
   • Re: Content-type: text/html (80 lines)
   • Re: Content-type: text/html (98 lines)

6. Convert data view to data set
   • Convert data view to data set (21 lines)
   • Re: Convert data view to data set (31 lines)
   • Re: Convert data view to data set (44 lines)
   • Re: Convert data view to data set (66 lines)
   • Re: Convert data view to data set (78 lines)
   • Re: Convert data view to data set (58 lines)

7. Converting Narrow Data Set to Wide Data Set
   • Converting Narrow Data Set to Wide Data Set (65 lines)
   • Re: Converting Narrow Data Set to Wide Data Set (85 lines)
   • Re: Converting Narrow Data Set to Wide Data Set (110 lines)
   • Re: Converting Narrow Data Set to Wide Data Set (129 lines)
   • Re: Converting Narrow Data Set to Wide Data Set (104 lines)
   • Re: Converting Narrow Data Set to Wide Data Set (160 lines)

8. Counting Max Trails using Level by ID
   • Counting Max Trails using Level by ID (109 lines)
   • Re: Counting Max Trails using Level by ID (149 lines)
   • Re: Counting Max Trails using Level by ID (257 lines)
   • Re: Counting Max Trails using Level by ID (307 lines)

9. DSD and the ending missing values
   • DSD and the ending missing values (26 lines)
   • Re: DSD and the ending missing values (13 lines)
   • Re: DSD and the ending missing values (29 lines)

10. Directly reference dataset created view lost the reference?
    • Re: Directly reference dataset created view lost the reference? (74 lines)
    • Re: Directly reference dataset created view lost the reference? (115 lines)
    • Re: Directly reference dataset created view lost the reference? (143 lines)
    • Re: Directly reference dataset created view lost the reference? (178 lines)

11. FW: Internet2 Connection Established
    • FW: Internet2 Connection Established (18 lines)

12. Framington Score
    • Re: Framington Score (241 lines)

13. Fwd: Much Faster Bootstraps Using SAS? -- Yes, the fastest to date...
    • Re: Fwd: Much Faster Bootstraps Using SAS? -- Yes, the fastest to date... (834 lines)
    • Re: Fwd: Much Faster Bootstraps Using SAS? -- Yes, the fastest to date... (1031 lines)
    • Re: Fwd: Much Faster Bootstraps Using SAS? -- Yes, the fastest to date... (1521 lines)

14. Fwd: Resolving macro variable in macroname
    • Fwd: Resolving macro variable in macroname (132 lines)

15. Fwd: proc sql
    • Fwd: proc sql (131 lines)

16. Hash vs OBS= (How to make a tie, not a winner)
    • Hash vs OBS= (How to make a tie, not a winner) (68 lines)
    • Re: Hash vs OBS= (How to make a tie, not a winner) (86 lines)
    • Re: Hash vs OBS= (How to make a tie, not a winner) (112 lines)
    • Re: Hash vs OBS= (How to make a tie, not a winner) (91 lines)

17. How to read this instream/raw data
    • How to read this instream/raw data (29 lines)
    • Re: How to read this instream/raw data (35 lines)

18. I got it RE: identify starting and ending column numbers
    • I got it RE: identify starting and ending column numbers (42 lines)

19. ICD9 CM Removing large blocks text
    • ICD9 CM Removing large blocks text (77 lines)
    • Re: ICD9 CM Removing large blocks text (13 lines)
    • Re: ICD9 CM Removing large blocks text (133 lines)

20. Importing .xlsx files with worksheet names >29 characters
    • Importing .xlsx files with worksheet names >29 characters (28 lines)
    • Re: Importing .xlsx files with worksheet names >29 characters (29 lines)

21. Incorporating a Baseline Hazard for a Binomial Logit
    • Incorporating a Baseline Hazard for a Binomial Logit (25 lines)

22. Input reading beyond specified length.
    • Input reading beyond specified length. (65 lines)
    • Re: Input reading beyond specified length. (89 lines)
    • Re: Input reading beyond specified length. (74 lines)
    • Re: Input reading beyond specified length. (100 lines)
    • Re: Input reading beyond specified length. (118 lines)
    • Re: Input reading beyond specified length. (125 lines)
    • Re: Input reading beyond specified length. (147 lines)

23. Job opening (NYC)
    • Job opening (NYC) (29 lines)

24. NLMIXED Output combinations
    • NLMIXED Output combinations (62 lines)
    • Re: NLMIXED Output combinations (148 lines)

25. NLMIXED and GLIMMIX -Beta distribution
    • NLMIXED and GLIMMIX -Beta distribution (22 lines)

26. New Computer
    • Re: New Computer (35 lines)

27. Nonlinear optimization
    • Nonlinear optimization (73 lines)

28. OT: Thursday Theory
    • OT: Thursday Theory (20 lines)
    • Re: OT: Thursday Theory (24 lines)

29. PRINT fileref in the FILE statement?
    • PRINT fileref in the FILE statement? (20 lines)
    • Re: PRINT fileref in the FILE statement? (37 lines)
    • Re: PRINT fileref in the FILE statement? (40 lines)
    • Re: PRINT fileref in the FILE statement? (72 lines)
    • Re: PRINT fileref in the FILE statement? (88 lines)

30. Parsing regular table
    • Parsing regular table (45 lines)
    • Re: Parsing regular table (64 lines)
    • Re: Parsing regular table (79 lines)

31. Proc Freq Horiz and Verticle lines
    • Proc Freq Horiz and Verticle lines (31 lines)

32. Proc SQL left join speed being affected significantly by option (rename=)?
    • Proc SQL left join speed being affected significantly by option (rename=)? (49 lines)
    • Re: Proc SQL left join speed being affected significantly by option (rename=)? (70 lines)
    • Re: Proc SQL left join speed being affected significantly by option (rename=)? (62 lines)
    • Re: Proc SQL left join speed being affected significantly by option (rename=)? (143 lines)
    • Re: Proc SQL left join speed being affected significantly by option (rename=)? (64 lines)

33. Q: new computer
    • Q: new computer (23 lines)
    • Re: Q: new computer (18 lines)

34. RES: understanding spatial autocorrelation
    • RES: understanding spatial autocorrelation (54 lines)

35. Resolving macro variable in macroname
    • Resolving macro variable in macroname (20 lines)
    • Re: Resolving macro variable in macroname (53 lines)
    • Re: Resolving macro variable in macroname (95 lines)
    • Re: Resolving macro variable in macroname (103 lines)
    • Re: Resolving macro variable in macroname (159 lines)
    • Re: Resolving macro variable in macroname (173 lines)
    • Re: Resolving macro variable in macroname (145 lines)
    • Re: Resolving macro variable in macroname (152 lines)

36. SAS code for calculating Framingham Risk Score
    • SAS code for calculating Framingham Risk Score (17 lines)
    • Re: SAS code for calculating Framingham Risk Score (28 lines)

37. SAS time
    • SAS time (40 lines)
    • Re: SAS time (53 lines)
    • Re: SAS time (114 lines)
    • Re: SAS time (144 lines)
    • Re: SAS time (160 lines)
    • Re: SAS time (177 lines)

38. Test for measuring trend
    • Test for measuring trend (36 lines)
    • Re: Test for measuring trend (88 lines)
    • Re: Test for measuring trend (7 lines)

39. Use symput to make a macro var
    • Use symput to make a macro var (66 lines)
    • Re: Use symput to make a macro var (76 lines)
    • Re: Use symput to make a macro var (68 lines)
    • Re: Use symput to make a macro var (82 lines)
    • Re: Use symput to make a macro var (107 lines)
    • Re: Use symput to make a macro var (139 lines)

40. Using value of a macro variable into another macro?
    • Using value of a macro variable into another macro? (70 lines)
    • Re: Using value of a macro variable into another macro? (95 lines)
    • Re: Using value of a macro variable into another macro? (79 lines)
    • Re: Using value of a macro variable into another macro? (108 lines)
    • Re: Using value of a macro variable into another macro? (108 lines)
    • Re: Using value of a macro variable into another macro? (141 lines)

41. X and Y in ODS REGION statement (PDF destination)
    • X and Y in ODS REGION statement (PDF destination) (89 lines)

42. [Poll] Your analytic career: how do you see yourself at 55?
    • [Poll] Your analytic career: how do you see yourself at 55? (14 lines)
    • Re: [Poll] Your analytic career: how do you see yourself at 55? (30 lines)
    • Re: [Poll] Your analytic career: how do you see yourself at 55? (49 lines)
    • Re: [Poll] Your analytic career: how do you see yourself at 55? (42 lines)

43. appropriate regression model for 12 level categorical response variable?
    • Re: appropriate regression model for 12 level categorical response variable? (21 lines)

44. change macro variable name dymacro?
    • change macro variable name dymacro? (25 lines)
    • Re: change macro variable name dymacro? (34 lines)
    • Re: change macro variable name dymacro? (33 lines)
    • Re: change macro variable name dymacro? (39 lines)
    • Re: change macro variable name dymacro? (41 lines)

45. class statement in Proc PRINT
    • class statement in Proc PRINT (52 lines)
    • Re: class statement in Proc PRINT (74 lines)
    • Re: class statement in Proc PRINT (73 lines)
    • Re: class statement in Proc PRINT (89 lines)
    • Re: class statement in Proc PRINT (77 lines)

46. coefficients for random effects
    • coefficients for random effects (27 lines)
    • Re: coefficients for random effects (34 lines)

47. data merging question
    • data merging question (42 lines)
    • Re: data merging question (67 lines)
    • Re: data merging question (61 lines)
    • Re: data merging question (59 lines)
    • Re: data merging question (71 lines)
    • Re: data merging question (114 lines)
    • Re: data merging question (156 lines)

48. dollar9. and comma9.
    • dollar9. and comma9. (10 lines)
    • Re: dollar9. and comma9. (19 lines)
    • Re: dollar9. and comma9. (29 lines)

49. duplicates emails from SAS-L
    • duplicates emails from SAS-L (19 lines)
    • Re: duplicates emails from SAS-L (30 lines)
    • Re: duplicates emails from SAS-L (31 lines)
    • Re: duplicates emails from SAS-L (35 lines)
    • Re: duplicates emails from SAS-L (29 lines)
    • Re: duplicates emails from SAS-L (38 lines)
    • Re: duplicates emails from SAS-L (51 lines)
    • Re: duplicates emails from SAS-L (46 lines)
    • Re: duplicates emails from SAS-L (45 lines)
    • Re: duplicates emails from SAS-L (67 lines)

50. equivalent of an offset in proc mixed
    • equivalent of an offset in proc mixed (33 lines)
    • Re: equivalent of an offset in proc mixed (88 lines)
    • Re: equivalent of an offset in proc mixed (8 lines)
    • Re: equivalent of an offset in proc mixed (148 lines)
    • Re: equivalent of an offset in proc mixed (168 lines)

51. file shortcuts question remade
    • file shortcuts question remade (43 lines)
    • Re: file shortcuts question remade (61 lines)

52. formatted input vs column input
    • formatted input vs column input (16 lines)

53. funny code, formatted input or list input or neither
    • funny code, formatted input or list input or neither (50 lines)
    • Re: funny code, formatted input or list input or neither (78 lines)

54. how to convert one variable into multiple columns according its value?
    • how to convert one variable into multiple columns according its value? (15 lines)
    • Re: how to convert one variable into multiple columns according its value? (33 lines)

55. how to get macro variable length
    • how to get macro variable length (16 lines)
    • Re: how to get macro variable length (31 lines)
    • Re: how to get macro variable length (35 lines)
    • Re: how to get macro variable length (39 lines)

56. identify starting and ending column numbers
    • identify starting and ending column numbers (21 lines)
    • Re: identify starting and ending column numbers (55 lines)
    • Re: identify starting and ending column numbers (30 lines)
    • Re: identify starting and ending column numbers (56 lines)
    • Re: identify starting and ending column numbers (49 lines)
    • Re: identify starting and ending column numbers (66 lines)
    • Re: identify starting and ending column numbers (76 lines)
    • Re: identify starting and ending column numbers (90 lines)
    • Re: identify starting and ending column numbers (56 lines)
    • Re: identify starting and ending column numbers (81 lines)
    • Re: identify starting and ending column numbers (76 lines)

57. input statement vs. put statement
    • input statement vs. put statement (23 lines)
    • Re: input statement vs. put statement (64 lines)

58. length of numeric variables
    • Re: length of numeric variables (98 lines)
    • Re: length of numeric variables (185 lines)
    • Re: length of numeric variables (242 lines)
    • Re: length of numeric variables (177 lines)
    • Re: length of numeric variables (159 lines)
    • Re: length of numeric variables (195 lines)
    • Re: length of numeric variables (255 lines)
    • Re: length of numeric variables (186 lines)
    • Re: length of numeric variables (200 lines)
    • Re: length of numeric variables (20 lines)
    • Re: length of numeric variables (216 lines)
    • Re: length of numeric variables (243 lines)

59. new computer
    • Re: new computer (37 lines)
    • Re: new computer (65 lines)
    • Re: new computer (31 lines)

60. output, loop, PDV
    • output, loop, PDV (61 lines)
    • Re: output, loop, PDV (79 lines)
    • Re: output, loop, PDV (132 lines)

61. proc report
    • proc report (27 lines)
    • Re: proc report (46 lines)
    • Re: proc report (66 lines)

62. proc sql
    • proc sql (35 lines)
    • Re: proc sql (51 lines)
    • Re: proc sql (51 lines)
    • Re: proc sql (119 lines)
    • Re: proc sql (51 lines)
    • Re: proc sql (151 lines)

63. random functions
    • random functions (9 lines)
    • Re: random functions (23 lines)
    • Re: random functions (56 lines)

64. reminder: EG v4.1 dies on Dec 1, 2010
    • reminder: EG v4.1 dies on Dec 1, 2010 (33 lines)

65. the d value of an informat, as in w.d or comma9.d
    • the d value of an informat, as in w.d or comma9.d (22 lines)
    • Re: the d value of an informat, as in w.d or comma9.d (49 lines)
    • Re: the d value of an informat, as in w.d or comma9.d (42 lines)
    • Re: the d value of an informat, as in w.d or comma9.d (81 lines)

66. variable-length records
    • variable-length records (18 lines)
    • Re: variable-length records (38 lines)
    • Re: variable-length records (76 lines)

67. versions of SAS 9.2
    • versions of SAS 9.2 (12 lines)
    • Re: versions of SAS 9.2 (19 lines)
    • Re: versions of SAS 9.2 (34 lines)
    • Re: versions of SAS 9.2 (18 lines)