Client received a file from Qualtrics (attached) of individual utilities. Instead of a binary, received a dataset with all numerics. We’ve instructed the client to create new variables where each variable has its own threshold of scores to turn it into binary data.

Client requests a tool to make this process easier.

[^Individual Utilities.csv]

Here is the advice we gave to the client to make this work:

So - with the excel file you sent over, we'll want to merge this file with your existing Qpack.

From there - we will use Tim's code to turn these numeric variables into binary variables.

{noformat}if (util1 > threshold_value) 1

else 0{noformat}

(you can use the arrows to drop in variable names so you don't have to type them all out)

This will create a numeric variable that's either a 1 or a 0.