Hi, I am doing a research project examining the association between Vitamin A intake and CVD in Hispanic women. I am using 5 datasets: demographics, smoking, medical conditions, total dietary intake, and body measures. I want to merge these data sets. However, the total dietary intake dataset would need to transform the detailed file into a person-level file (with one record for each person) before merging it with NHANES demographic and other data files by using seqn as the unique identifier. How can I do this in SAS? I have attached the total dietary intake dataset for reference. Thanks!
... View more