Hi everyone,
I've got a question about combining and analyzing my data. I will try to explain it as good as possible:
I've got 4000 subjects, and for each subject 200 different variables with food intake. For each variable of food intake, I have three different values, which I have to (separately) multiply with the variable to create new variables. So at the end, for each subject, I would have 600 more variables?
For example:
potato
subject 1: 50
Then I have to multiply the 50 g/d potato with 0,55 , 0,46 and 0,83 into three new variables. And repeat this for the 3999 other subjects. However, the next variable, bread needs to be multiplied with three values as well, but these values are different values as mentioned above.. And is there a procedure which I can use to do it faster?
At the moment I have a wide data set, but I guess I should make it a long data set. So I would have 3 observations for each subject, but the observations would be the same?
I really hope someone can help me.
I'm having a hard time envisioning your data. But my first thought would be to make it into a long narrow dataset with 200 records per subject. So you would have 4,000 subjects * 200 foods = 800,000 records.
It would look like:
Subject Food Intake Factor1 Factor2 Factor3 1 Potato 50 .55 .46 .83 1 Milk 75 .33 .68 .99 1 Honey 25 .02 .34 .33 ...
With a structure like that, it should be straight forward to make new variables. In general, working with long narrow datasets is easier than wide datasets.
You could even take it further, and transpose each of the above records into three records (one for each factor). So your variables would be Subject Food Intake FactorID (1-3) and Factor. But depending one what you will be doing with these data, that might be overkill.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.