Search results for query: *

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 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.

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...

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...

So I apologize in advance. I know this question continually pops up, but I'm to the point of frustrated and have no idea what to try next. My problem seems simple, and I've read all the postings I could find about the issue, but nothing I seem to try works. Scenario: tblCustomers <customerID>...