Understanding Society User Support

hello,

I have two concerns and would like to thank you in advance for your support!

First, a brief description of my project: I aim to analyze gender differences in pro-environmental behavior (PEB) using data from the UK Household Study. My analysis focuses on Waves 10 and 13. Since the PEB variables and the variable "sex" are not in the same dataset, I need to merge the datasets.

1st Concern:
I attempted to merge the following two datasets from Wave 13: "m_hhresp" and "m_indresp". Unfortunately, I was unable to do so using the syntax provided on your website:
https://www.understandingsociety.ac.uk/wp-content/uploads/documentation/main-survey/syntax/spss/sps-distributing-household-level-information-individual-level.sps

Additionally, merging via the SPSS menu did not work either. I received the following error message:

"Warning number 5132: Duplicate key in a file. The BY variables do not uniquely identify each case in the specified file. Please check the results carefully."

I also attempted the same process for Wave 10 with "j_hhresp" and "j_indresp", but encountered the same issue.

Do you have any suggestions on how to correctly merge these datasets? Alternatively, is it possible to obtain pre-merged datasets?

2nd Concern:
In Waves 10 and 13, I was unable to find some variables in the dataset, even though they are listed on your website:
https://www.understandingsociety.ac.uk/documentation/mainstage/variables/?wpsolr_fq%5B0%5D=index_term_str%3AEnvironmental%20Issues&wpsolr_fq%5B1%5D=variable_wave_mainstage_str%3A10&wpsolr_fq%5B2%5D=variable_wave_mainstage_str%3A

The missing variables are as follows:

Wave 13: carfuel and solar (Note: recglass, recpaper, and recplastic are available in Wave 13). According to the website, these variables should be in "m_hhresp".

Wave 10: carbuy, carfuel, envhabit1 - envhabit11, flyes, nflyeu, nflyin, nflyos, recglass, recpaper, recplastic, and solar. These variables should be in "j_hhresp" and "j_indresp" according to the website.

Were these variables actually collected for these waves, or are they located in a different dataset?

Thank you very much in advance for your help!

Best regards,
Leon Arlt