%macro bowling(alley); proc sql; %let nwords=%sysfunc(countw(&alley,%str( , ))); create table as ( select * from ( %do j = 1 %to &nwords; %let alley = scan(j,&alley); select( *, "&alley" as allnm from bowling ) %if &j ne &nwords %then %do; union %end; %end; ) ; quit;   In a single query, I am trying to pull information from several datasets in a macro and stack them all on top of each other.   The macro will take in a single argument, alley, which will provide a list of bowling alleys.  Next, the macro should look up information from a dataset called &alley.sas (ie: if the alley name is Henderson, it's info will be in a dataset called Henderson.sas).  I am trying to loop through the list of alleys given, which is what the nwords macro is for, and stack all of that information on each other.  When it gets to the alley name in the list, it should end.  obviously this macro logic is flawed and there are probably several syntax errors, but this is a rough draft for what I am trying to achieve ... View more

How can I create a title based on the values of several macros    I have %let  name = Mary; %let id = 10021;  %let key = Z;    I want my title to look like this (MaryID10021KeyZ) How can I make this in the titles statement? ... View more

I' am trying to read in my data using an infile statement and then use a do loop to replicate the data several times based on the value of two variables, replicates and Samp.  When I add the do loop in, I get this error : v  Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY        expression is missing, zero, or invalid.   Does anyone have any idea why this is happening.   For reference here is what the data looks like before:    ID       Replicate        Samp  1329     5                    2    and here is what I want it to look like afterwards:  ID       reps.          Samp             rep1.        samp1 1329     5                   2               1              1 1329     5                   2               1              2 1329     5                   2               2              1 1329     5                   2               2              2 1329     5                   2               3              1 1329     5                   2               3              2 1329     5                   2               4              1 1329     5                   2               4               2 1329     5                   2               5              1 1329     5                   2               5              2   Here is my current code to do this  The data is formatted a little weird so the infile and do while loops are necessary to properly read in the data  data carsim; infile 'S:\sasdata\cars.txt' firstobs=2 dlm='09'x truncover ; input dist : $6. reps : samp @ ; /*Remove any observations where size is missing*/ do while(not missing(Samp)); output; input Samp @; end; /* rep1 = observation number within the sample*/ /* samp1 = Sample Number /*Replicate dataset according to rep and size variables*/ do rep1 = 1 to reps by 1; do samp1 = 1 to size by 1; output; end; end; run; ... View more

data empraw;  infile empdat firstobs=2 dlm='09'x ; input name : $6.  lastname : $6. @ ; input score $ @@ ; run; I am having trouble with line hold specifiers.   My input data looks like this (ignore the formatting issues like spacing)   FirstName LastName Score  Sally    Mae      30       40       50    60  John    Goe      30       40       50    60  Matt     Miller      30       40       50    60  Henry   Mae      30       40       50    60    where score should be read in several times and First and Last name should be retained to output something like this    Sally       Mae      30  Sally       Mae      40 Sally       Mae      50 Sally       Mae      60   I'm currently trying this:  data empraw;  infile empdat firstobs=2 dlm='09'x ; input name : $6.  lastname : $6. @ ; input score $ @@ ; run;   Right now, it doesn't hold the input buffer, and outputs like this:   Sally       Mae      30  40           50        60   What am I doing wrong? ... View more