In addition to the request from @andreas_lds , please tell us if this is the entire data set, or if this is just a small part of a much larger data set. (If it is much larger, please tell us how many rows). Are there different subjects or different IDs in this larger data set? Would the code need to be smart enough to make different replacements for different subjects/different IDs? ... View more

@KB131619 wrote: No there is no 0. I'm afraid this doesn't really explain anything. Are you doing one-sample or two-sample t-tests? If you don't want to compare to zero, what do you want to compare to? ... View more

So row 21 reads EMPIRE POST MEDIA, INC. (EMPM)   and you want EMPIRE POST MEDIA INC   Am I understanding correctly? ... View more

So someone tells you the N (sample size), mean and variance, and you want to test if the mean is zero??? Is this a one-sample test or a two-sample test? You don't tell us.   If so, then you can do this with a calculator, the formula is here: https://en.wikipedia.org/wiki/Student%27s_t-test#One-sample_t-test. I don't think you can do this in PROC TTEST.   Or you can program that formula into a SAS data step, and also use the SAS function CDF('T', t, df [, nc]) to replace looking up the probability in a statistical table.   ... View more

Excellent idea, @FreelanceReinh  ... View more

@ballardw    Custom format or custom informat, and then stop writing your own DUMMY variables and use SAS PROCs to compute the dummy variables behind the scenes. ... View more

Is the little table you show us the input, or the desired output? If it is the input, please show us the desired output. If it is the output, please show us the input SAS data set. ... View more

@subhashmantha wrote: white = (missing(race) or (race=1))*1; Or don't even try to create the dummy variables yourself, SAS can create them for you from your data by using the CLASS statement in a modeling procedure, so you don't have to create the dummy variables. ... View more

NOTE: No observations were selected from data set TSA.CLAIMS_CLEANED. NOTE: There were 0 observations read from the data set TSA.CLAIMS_CLEANED. WHERE 0 /* an obviously FALSE WHERE clause */ ;   Showing us the ERRORs or NOTEs without showing us the code, and without showing us a portion of the data, is never sufficient. There are a gazillion reasons why you might get these NOTEs in the log. So please show us the entire log for this PROC or for this DATA step. Please show us a portion of the relevant data. ... View more

Why do you need dummy variables at all? Almost every SAS modeling procedure creates the dummy variables for you behind the scenes so you don't have to, avoiding all of these pitfalls and potential errors. And you can specify which level is the reference (or baseline) level. This is one of the great advantages of using SAS for modeling. ... View more

data a; string_to_find='%put('||"'ERROR"; intext='%put('||"'ERROR"; if index(intext, string_to_find)=0 then put 'ABC'; else put 'XYZ'; run; ... View more

When I read the original question, and then see the difficult programming that @Patrick provides, I feel compelled to ask @StickyRoll  why this data set needs to be transposed in the first place. What is the benefit of re-arranging the data in this fashion? It seems to me that re-arranging the data set just makes programming the next step(s) much more difficult. If the goal is to create a wide table for output, then no transpose is needed, and PROC REPORT will do this without the difficulties of transposing. ... View more