I am currently writing a form that is linked to the Food Consumption Score Nutritional Quality Analysis (FCS-N).
Currently asking households over the last 7 days how many vegetables, eggs, meat, etc they have eaten. The answers come out as values 0-7.
Is there a way to automatically group these values into 3 groups? Never = 0 eaten (output variable = 1), Sometimes 1-6 (output variable = 2) and At least daily = (output variable = 3)
This would be helpful to then input a calculate function to observe the protein, hem iron and Vit A outcomes of this population.
Thanks for your time all and appreciate the amazing support,