Recent content by tweaked2005

I just want to thank everyone who contributed to this string. It helped me on a very similar issue. Just a reminder that this forum is beneficial to not only the original poster. Thanks all!

Yay! It worked. Thank you so much! I knew I was close.

I reviewed other post, and still can't seem to come up with a working solution. I have a dataset similar to below: id category 1 Fever 1 Headache 1 Nausea 1 Fever 2 Nausea 2 Accident 3 Fever 4 Accident I want to create a new variable: "conditions" that has a concatenated list...

I have a dataset with 5 variables (syndrome, patientClass, datatype, location, date). It is possible that multiple records can match on everything but date. So as an example: Dataset ======= Obs Syndrome PatientClass DataType Location Date 1 S1 Inpatient Pediatrics Hosp1...

I'm getting a Run-time error '438': "Object doesn't support this property or method" When I run the code you listed. I'll keep trying to fiddle with it. Thanks again for all of your help with this.

Forgive me for not knowing the answer to this. I've never coded VBA in Excel, only Access. I now have a macro called colorCount and the code looks like this Sub ColorCount() clrval=Cells(1,1).InteriorColorIndex If clrval=vbYellow Then Cells(2,2) = "yes" End Sub However, when I run the...

I'm trying to create a column, that is populated with "Yes" if the cell background color for a different column is "Yellow". So in other words if: If A1 Cell Color = Yellow, Then A2 = "Yes" Is there any way at all I can do this in MS Excel? Thanks in advance for any help.

I'm trying to create a column, that is populated with "Yes" if the cell background color for a different column is "Yellow". So in other words if: Format Cell Color A1 = Yellow, Then A2 = "Yes" Is there any way at all I can do this in MS Excel? Thanks in advance for any help.

Thank you so much!! That worked!

I'm using MS Access, and programming in VBA. I have a form, and want the code to run when I open the form, so I've created an event for on Open. I'm using the code below. Baseically, I want it to evaluate each record, and populate my comment field with "new" if the condition is true. This is...

So I'm trying to apply the following conditional code to each record in the dataset that is loading in my form. I know I need to loop through each record, but I can't remember the code necessary to do so (is it something like recordset.EOF). Any help on looping through records is greatly...

Does anyone have a good definition (without the word index in it) for what the the index= means in the dataset below. data new(index=var1); set old;run;

This might be a simple thing to do, but for the life of me I can't figure it out. I'm trying to schedule a task where someone might do a total of 8 hours of work over a 2 month period. For example, as mail comes in, they might spend 1 hour a week recording the mail, but this task needs to...

Thanks so much for the help. Any thoughts on how to still make sure indifferent could match up with other indifferents? Again - thanks for the logic help - super appreciated.

I'm stumped. I need to create a SAS program that randomly matches names for dinner. There are a few criteria to consider: There are 3 categories of folks, those that can go to dinner in groups of 3 only, can go to dinner in groups of 2 only, or are indifferent. The program needs to match folks...