I created a SAS macro, lets call it mymacro, that takes a single string as input. I have a list of about 30 strings (with no pattern) that I need to run the macro for. I thought I could somehow put the strings in an array and then create another macro that loops the original macro over each item in the array, but I can't find information on how to create an array outside of a data step.    For example:  List of input to mymacro  : foo, world, dog, cat, tree, ...   Need a more efficient way of doing:  %mymacro(foo) %mymacro(world) %mymacro(dog) ...   I'm sure there is a simple way of doing this, but I'm fairly new to macros in SAS. Thanks in advance!  ... View more

I am attempting to transform a dataset that has the following layout:  data have ; input ID type$ baseline peak diff ; cards ; 1 A 5 6 1 1 B 7 4 -3 2 A 12 3 -9 2 B 3 3 0 3 A 4 8 4 3 B 1 8 7 ; run ; Using the following code:  proc transpose data=have out=baseline prefix=baseline ; by ID ; ID type ; var baseline ; run; proc transpose data=have out=peak prefix=peak ; by ID ; ID type ; var peak; run ; proc transpose data=have out=diff prefix=diff ; by ID ; ID type ; var diff ; run ; data combined ; merge baseline peak diff ; by ID ; run ; The resulting dataset has this format:  data combined ; input ID baselineA baselineB peakA peakB diffA diffB; cards ; 1 5 7 6 4 1 -3 2 12 3 3 3 -9 0 3 4 1 8 8 4 7 ; run ; This is mostly the format I want, however I need the variables in a slightly different order, as follows:  data want ; input ID baselineA peakA diffA baselineB peakB diffB ; cards ; 1 5 6 1 7 4 -3 2 12 3 -9 3 3 0 3 4 8 4 1 8 7 ; run ; Basically, I variables for the same type (A,B) from each transpose listed sequentially.    One thing to note is that with the above example I could easily just reorder the variables using the retain statement. However, in my actual dataset rather than just having two types (A and B), there are 31 categories, and there are 4 rather than 3 transposes. This means 124 (31x4) columns to reorder, which would be a bit tedious.    What is the most efficient way to reorder the columns like I want? Is there a better method than transposing separately 3 times?   Thanks in advance!  ... View more

I have a dataset that has a large number of variables (2,880 to be exact). Right now, the variables have the default variable names var1, var2, var3, ..., var2880. I need to label the variables according to 30 second intervals of military time - 00:00:00, 00:00:30, 00:01:00, 00:01:30, 00:02:00,...,23:59:30. I'm trying to figure out a way to do this without having to type all 2,880 by hand. I was thinking of using an array somehow, but I don't have a list of the desired labels stored anywhere, so I would still have to hand type them into the array. Any suggestions are appreciated!  ... View more

If I have a dataset with X rows and Y columns, I'm trying to essentially make every Z number of sequential rows concatenated into one, so I end up with X/Z rows and Y*Z columns.    For example, X=6, Y=3, Z=2.    Have: VAR1 VAR2 VAR3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18   Want:  VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18   It seems simple enough, but I can't quite figure out a way that works. I should also note that the for the data I am using this on, X will always be divisible by Z. Thanks!    Edit:  The data provided above are just an example to show the type of thing I'm looking for. In reality, the dataset will have some multiple of 24 as the number of rows. Each row represents one hour out of one day, with each 24 rows coming from the same day. There will be 120 columns of numeric data for each row (no missing data). The goal is to get to the point of having each row be one day, with 2,880 (120x24) columns of data. What I'm going to end up doing is writing a macro to iterate the steps over multiple datasets with a different number of "days" (hence different number of total rows). Thanks to everyone who has responded!  ... View more

I'm trying to work with the bladder dataset obtained here http://support.sas.com/documentation/cdl/en/statug/66859/HTML/default/viewer.htm#statug_phreg_examples10.htm   As provided, the data are repeated measures with 4 observations for each subject. Each observation has a visit number from 1-4 and a binary status variable. I would like to have each subject only appear once with either the first visit where status=1 or if a subject never has status=1, then the last visit (visit=4). I'm thinking maybe I need to somehow use a do loop iterating over each ID, but I'm not sure how to implement. Any help is greatly appreciated!    ... View more