Dear Stata community, dear Nick
I am looking for a command which allows me to create an if-statement which refers to about 40 variables.
I have got yearly bilateral FDI data for 40 different classes of foreign direct investment.
I want to delete an observation if a country reports only zeros on all FDI classes.

Thus, something similar to :
Code:
drop if var1-var40=0
I already tried that line but it did drop less observations than using:
Code:
drop if var1 =0 & var2 = 0 ... & var40 = 0
You can see my data below where the ID* abbreviations are representing different classes of FDI (var1-var40):

input str36 name str38 cpname int timeperiod double(IDA_G_DV IDA_G IDL_G IDL_G_DV)
"AfghanistanIslamic Republic of" "Germany" 2016 0 0 0 0
"AfghanistanIslamic Republic of" "Germany" 2017 0 0 0 0
"AfghanistanIslamic Republic of" "Italy" 2009 0 0 0 0
"AfghanistanIslamic Republic of" "Italy" 2010 0 0 0 421572.76040272
"AfghanistanIslamic Republic of" "Italy" 2011 0 0 0 1801631.46384125
"AfghanistanIslamic Republic of" "Italy" 2012 0 0 0 0
"AfghanistanIslamic Republic of" "Italy" 2013 0 0 0 0

Thank you very much for your time