When export to Excel, how to exclude one variable?

[Chiao yi Tung]

I use manual item "Data to Excel Spreadsheet" from File---Export. The codes are:

export excel using "/Users/Documents/MedifyMD/Extracted.xlsx" if search2 > 0, sheet("boston+model") firstrow(variables)

But I don't wanna search2 variable to be shown up in my Extracted.xlsx file. Is there a way to do that? In R, I know I can use "-search2", but I don't know how to do in Stata.

[Sergiy Radyakin]

preserve
    drop search2
    export excel using "/Users/Documents/MedifyMD/Extracted.xlsx" if search2 > 0, sheet("boston+model") firstrow(variables)
restore

[William Lisowski]

Alternatively

. ds
x  y  z

. ds z, not
x  y

. local vars `r(varlist)'

. display "`vars'"
x y

. export excel `vars' using gnxl.xlsx
file gnxl.xlsx saved

[Chiao yi Tung]

preserve
drop search2
export excel using "/Users/Documents/MedifyMD/Extracted.xlsx" if search2 > 0, sheet("boston+model") firstrow(variables)
restore

Hi, your method doesn't work. The error message pops out: search2 not found

[William Lisowski]

Try

preserve
keep if search2>0
drop search2
export excel using "/Users/Documents/MedifyMD/Extracted.xlsx", sheet("boston+model") firstrow(variables)
restore