This chuck of code will help to reshape the harmonised ELSA (Waves 1-7) to long format.
use "Harmonized_ELSA.dta", clear
rename s*tr20 s*rentr20
reshape long hh@hhid hh@hhidc h@coupid h@coupidc s@idauniq raspid@ ///
inw@ inw@sc r@iwstat s@iwstat r@cohort_e s@cohort_e ///
s@elsamp r@strat s@cwtresp r@lwtresp s@lwtresp r@scwtresp ///
s@scwtresp hh@hhresp h@cpl r@finr s@finr h@anyfin ///
r@hhr s@hhr r@hor s@hor hh@anyho r@proxy s@proxy hh@iwhh ///
hh@iwhhf hh@iwhhm hh@iwhhy r@iwind s@iwind r@iwindf ///
s@iwindf r@iwindm s@iwindm r@iwindy s@iwindy ///
s@byear s@fbyear s@dyear r@agey s@agey r@fagey ///
s@fagey s@gender s@fgendr s@racem s@racef s@edyrs_e ///
s@educ_e s@educl r@mstat s@mstat r@mpart s@mpart r@mstath ///
s@mstath r@mstatf s@mstatf r@mrct s@mrct r@mnev s@mnev ///
r@mdiv s@mdiv r@mwid s@mwid r@mend s@mend r@mcurln ///
s@mcurln r@mlen s@mlen s@bplace s@bcountry s@relig_e r@shlt ///
s@shlt r@shltf s@shltf r@shlta s@shlta r@shltaf s@shltaf r@hlthlm ///
s@hlthlm r@walkra s@walkra r@dressa s@dressa r@batha s@batha ///
r@eata s@eata r@beda s@beda r@toilta s@toilta r@mapa ///
s@mapa r@phonea s@phonea r@moneya s@moneya r@medsa s@medsa ///
r@shopa s@shopa r@mealsa s@mealsa r@housewka s@housewka r@walk100a ///
s@walk100a r@sita s@sita r@chaira s@chaira r@climsa s@climsa ///
r@clim1a s@clim1a r@stoopa s@stoopa r@lifta s@lifta r@dimea ///
s@dimea r@armsa s@armsa r@pusha s@pusha r@adla s@adla r@adlam ///
s@adlam r@adlwa s@adlwa r@adlwam s@adlwam r@iadla s@iadla ///
r@iadlam s@iadlam r@iadlza s@iadlza r@iadlzam s@iadlzam r@mobilb ///
s@mobilb r@mobilbm s@mobilbm r@lgmusa s@lgmusa r@lgmusam s@lgmusam ///
r@grossa s@grossa r@grossam s@grossam r@finea s@finea r@fineam ///
s@fineam r@depres s@depres r@effort s@effort r@sleepr s@sleepr ///
r@whappy s@whappy r@flone s@flone r@fsad s@fsad r@going ///
s@going r@enlife s@enlife r@cesd s@cesd r@cesdm s@cesdm ///
r@hibpe s@hibpe r@hibpf s@hibpf r@diabe s@diabe r@diabf s@diabf ///
r@cancre s@cancre r@cancrf s@cancrf r@lunge s@lunge r@lungf ///
s@lungf r@hearte s@hearte r@heartf s@heartf r@stroke s@stroke ///
r@strokf s@strokf r@psyche s@psyche r@psychf s@psychf r@arthre ///
s@arthre r@arthrf s@arthrf r@asthmae s@asthmae r@asthmaf ///
s@asthmaf r@hchole s@hchole r@hcholf s@hcholf r@catrcte ///
s@catrcte r@catrctf s@catrctf r@parkine s@parkine r@parkinf ///
s@parkinf r@hipe s@hipe r@memrye s@memrye r@memryf s@memryf ///
r@alzhe s@alzhe r@alzhf s@alzhf r@demene s@demene r@demenf s@demenf ///
r@bmi s@bmi r@bmicat s@bmicat r@height s@height r@weight s@weight ///
r@mammog s@mammog r@prost s@prost r@vgactx_e s@vgactx_e r@mdactx_e ///
s@mdactx_e r@ltactx_e s@ltactx_e r@drink s@drink r@drinkd_e s@drinkd_e ///
r@drinkn_e s@drinkn_e r@drinkwn_e s@drinkwn_e r@smokev s@smokev ///
r@smoken s@smoken r@smokef s@smokef r@shltc s@shltc r@shltcf ///
s@shltcf r@shltac s@shltac r@shltacf s@shltacf r@adlc s@adlc ///
r@adlf s@adlf r@grossc s@grossc r@grossf s@grossf r@finec s@finec ///
r@finef s@finef r@hibps s@hibps r@diabs s@diabs r@cancrs s@cancrs ///
r@lungs s@lungs r@hearts s@hearts r@stroks s@stroks r@psychs ///
s@psychs r@arthrs s@arthrs r@asthmas s@asthmas r@hchols ///
s@hchols r@catrcts s@catrcts r@parkins s@parkins r@hips s@hips ///
r@memrys s@memrys r@alzhs s@alzhs r@demens s@demens r@hipriv ///
s@hipriv r@hpsrc s@hpsrc r@lifein s@lifein r@cogimp s@cogimp ///
r@cogothp s@cogothp r@slfmem s@slfmem r@readrc s@readrc ///
r@imrc s@imrc r@dlrc s@dlrc r@mo s@mo r@dy s@dy r@yr s@yr ///
r@dw s@dw r@orient s@orient r@verbf s@verbf r@numer_e s@numer_e r@tr20 ///
s@rentr20 r@prmt1 s@prmt1 r@prmt2 s@prmt2 r@bwc20 s@bwc20 ///
r@ser7 s@ser7 r@scis s@scis r@cact s@cact r@mnrc s@mnrc r@pm s@pm ///
r@pres s@pres h@arles h@afrles h@absns h@afbsns h@aira h@afira ///
h@astck h@afstck h@achck h@afchck h@abond h@afbond h@adebt ///
h@afdebt h@ahown h@ahous h@afhous h@amort h@afmort h@atoth h@aftoth ///
h@aftothn h@atotf h@aftotf h@atotb h@aftotb r@itearn s@itearn ///
r@itifearn s@itifearn h@isemp h@iifsemp h@itrent h@itifrent h@ittrest ///
h@ittfrest h@icap h@ifcap h@itfcap r@itpena s@itpena r@itifpena ///
s@itifpena r@issdi s@issdi r@ifssdi s@ifssdi r@isret s@isret ///
r@ifsret s@ifsret r@ipubpen s@ipubpen r@ifpubpen s@ifpubpen ///
r@igxfr s@igxfr r@ifgxfr s@ifgxfr h@iothr h@ifothr h@itot h@iftot ///
h@ifttot hh@cfoodi hh@cfoodo1m hh@cfood1m hh@cclo1m hh@clei1m hh@crent ///
hh@cutil hh@ctot1m h@hhres r@dau s@dau r@son s@son r@child s@child ///
r@grchild_e s@grchild_e r@livsib s@livsib r@momliv s@momliv r@dadliv s@dadliv ///
r@momage s@momage r@dadage s@dadage r@livpar s@livpar h@coresd r@kcntf ///
s@kcntf r@kcntpm s@kcntpm r@kcnt s@kcnt r@rcntf s@rcntf r@rcntpm s@rcntpm ///
r@rcntm r@rcnt s@rcnt r@fcntf s@fcntf r@fcntpm s@fcntpm r@fcnt s@fcnt ///
r@rcaany s@rcaany r@gcaany s@gcaany r@gkcare s@gkcare h@gany h@tcany ///
h@toany h@tfany r@socyr s@socyr r@work s@work r@work2 s@work2 r@slfemp ///
s@slfemp r@lbrf_e s@lbrf_e r@inlbrf s@inlbrf r@unemp s@unemp r@jhours ///
s@jhours r@jhour2_e s@jhour2_e r@jweeks_e s@jweeks_e r@wgihr_e s@wgihr_e ///
r@wgiwk_e s@wgiwk_e r@wgfhr_e s@wgfhr_e r@wgfwk_e s@wgfwk_e r@jphysa ///
s@jphysa r@jpress s@jpress r@jcten s@jcten r@fjcten s@fjcten r@jcocc_e ///
s@jcocc_e r@jlastm s@jlastm r@jlasty s@jlasty r@retemp s@retemp r@retage ///
s@retage r@liv85 s@liv85 r@liv10 s@liv10 r@liv10a s@liv10a r@inher s@inher ///
r@beq50p s@beq50p r@beq150p s@beq150p r@workat s@workat r@workata s@workata ///
r@workl65 s@workl65 r@pnhm5y s@pnhm5y r@pubpen s@pubpen r@peninc s@peninc ///
r@peninm s@peninm r@penct s@penct r@jcpen s@jcpen r@ptyp1_e s@ptyp1_e ///
r@ptyp2_e s@ptyp2_e r@ptyp3_e s@ptyp3_e, i(idauniq) j(wave)