Weight and in Range error

[Craig Smith]

Dear all,

Brand new to Stata and under pressure with urgent deadline. Need to take list of variables from UK BB and list into .CSV - can anyone tell me why it's not working and what code to enter?

BW,

Craig



keep [n_eid, age, n_21022_0_0, n_34_0_0, n_31_0_0, n_189_0_0, n_26410_0_0, n_26426_0_0, n_26427_0_0, n_1558_0_0, n_1558_1_0, n_1558_2_0, n_1558_3_0, n_20117_0_0, n_20117_1_0, n_20117_2_0, n_20117_3_0, n_20403_0_0, n_20414_0_0, n_20416_0_0, n_21001_0_0, n_21001_1_0, n_21001_2_0 n_21001_3_0, ts_40005_0_0 ts_40005_1_0 ts_40005_2_0 ts_40005_3_0 ts_40005_4_0 ts_40005_5_0 ts_40005_6_0 ts_40005_7_0 ts_40005_8_0 ts_40005_9_0 ts_40005_10_0 ts_40005_11_0 ts_40005_12_0 ts_40005_13_0 ts_40005_14_0 ts_40005_15_0 ts_40005_16_0 ts_40005_17_0 ts_40005_18_0 ts_40005_19_0 ts_40005_20_0 ts_40005_21_0 s_40006_0_0 s_40006_1_0 s_40006_2_0 s_40006_3_0 s_40006_4_0 s_40006_5_0 s_40006_6_0 s_40006_7_0 s_40006_8_0 s_40006_9_0 s_40006_10_0 s_40006_11_0 s_40006_12_0 s_40006_13_0 s_40006_14_0 s_40006_15_0 s_40006_16_0 s_40006_17_0 s_40006_18_0 s_40006_19_0 s_40006_20_0 s_40006_21_0 n_40008_0_0 n_40008_1_0 n_40008_2_0 n_40008_3_0 n_40008_4_0 n_40008_5_0 n_40008_6_0 n_40008_7_0 n_40008_8_0 n_40008_9_0 n_40008_10_0 n_40008_11_0 n_40008_12_0 n_40008_13_0 n_40008_14_0 n_40008_15_0 n_40008_16_0 n_40008_17_0 n_40008_18_0 n_40008_19_0 n_40008_20_0 n_40008_21_0 n_40009_0_0 n_40011_0_0 n_40011_1_0 n_40011_2_0 n_40011_3_0 n_40011_4_0 n_40011_5_0 n_40011_6_0 n_40011_7_0 n_40011_8_0 n_40011_9_0 n_40011_10_0 n_40011_11_0 n_40011_12_0 n_40011_13_0 n_40011_14_0 n_40011_15_0 n_40011_16_0 n_40011_17_0 n_40011_18_0 n_40011_19_0 n_40011_20_0 n_40011_21_0 n_40012_0_0 n_40012_1_0 n_40012_2_0 n_40012_3_0 n_40012_4_0 n_40012_5_0 n_40012_6_0 n_40012_7_0 n_40012_8_0 n_40012_9_0 n_40012_10_0 n_40012_11_0 n_40012_12_0 n_40012_13_0 n_40012_14_0 n_40012_15_0 n_40012_16_0 n_40012_17_0 n_40012_18_0 n_40012_19_0 n_40012_20_0 n_40012_21_0 s_40013_0_0 s_40013_1_0 s_40013_2_0 s_40013_3_0 s_40013_4_0 s_40013_5_0 s_40013_6_0 s_40013_7_0 s_40013_8_0 s_40013_10_0 s_40013_11_0 s_40013_12_0 s_40013_14_0 n_40019_0_0 n_40019_1_0 n_40019_2_0 n_40019_3_0 n_40019_4_0 n_40019_5_0 n_40019_6_0 n_40019_7_0 n_40019_8_0 n_40019_9_0 n_40019_10_0 n_40019_11_0 n_40019_12_0 n_40019_13_0 n_40019_14_0 n_40019_15_0 n_40019_16_0 n_40019_17_0 n_40019_18_0 n_40019_19_0 n_40019_20_0 n_40019_21_0 s_40021_0_0 s_40021_1_0 s_40021_2_0 s_40021_3_0 s_40021_4_0 s_40021_5_0 s_40021_6_0 s_40021_7_0 s_40021_8_0 s_40021_9_0 s_40021_10_0 s_40021_11_0 s_40021_12_0 s_40021_13_0 s_40021_14_0 s_40021_15_0 s_40021_16_0 s_40021_17_0 s_40021_18_0 s_40021_19_0 s_40021_20_0 s_40021_21_0 n_1309_0_0 n_1309_1_0 n_1309_2_0 n_1309_3_0 n_1309_0_0 n_1309_1_0 n_1309_2_0 n_1309_3_0 n_1299_0_0 n_1299_1_0 n_1299_2_0 n_1299_3_0 ts_40000_0_0 ts_40000_1_0 s_40001_0_0 s_40001_1_0 s_40002_0_1 s_40002_0_2 s_40002_0_3 s_40002_0_4 s_40002_0_5 s_40002_0_6 s_40002_0_7 s_40002_0_8 s_40002_0_9 s_40002_0_10 s_40002_0_11 s_40002_0_12 s_40002_0_13 s_40002_0_14 s_40002_1_1 s_40002_1_2 s_40002_1_3 s_40002_1_4 s_40002_1_5 s_40002_1_6 s_40002_1_7 s_40002_1_8 s_40002_1_9 n_40007_0_0 n_40007_1_0 n_40023_0_0 n_845_0_0 n_845_1_0 n_845_2_0 n_6138_0_0 n_6138_0_1 n_6138_0_2 n_6138_0_3 n_6138_0_4 n_6138_0_5 n_6138_1_0 n_6138_1_1 n_6138_1_2 n_6138_1_3 n_6138_1_4 n_6138_1_5 n_6138_2_0 n_6138_2_1 n_6138_2_2 n_6138_2_3 n_6138_2_4 n_6138_2_5 n_6138_3_0 n_6138_3_1 n_6138_3_2 n_6138_3_3 n_6138_3_4 n_6138_3_5 n_816_0_0 n_816_1_0 n_816_2_0 n_816_3_0 n_6142_0_0 n_6142_0_1 n_6142_0_2 n_6142_0_3 n_6142_0_4 n_6142_0_5 n_6142_0_6 n_6142_1_0 n_6142_1_1 n_6142_1_2 n_6142_1_3 n_6142_1_4 n_6142_2_0 n_6142_2_1 n_6142_2_2 n_6142_2_3 n_6142_2_4 n_6142_3_0 n_6142_3_1 n_6142_3_2 n_6142_3_3 n_21000_0_0 n_21000_1_0 n_21000_2_0 n_670_0_0 n_670_1_0 n_670_2_0 n_670_3_0 n_680_0_0 n_680_1_0 n_680_2_0 n_680_3_0 n_709_0_0 n_709_1_0 n_709_2_0 n_709_3_0 n_728_0_0 n_728_1_0 n_728_2_0 n_728_3_0 n_738_0_0 n_738_1_0 n_738_2_0 n_738_3_0 n_6149_0_0 n_6149_0_1 n_6149_0_2 n_6149_0_3 n_6149_0_4 n_6149_0_5 n_6149_1_0 n_6149_1_1 n_6149_1_2 n_6149_1_3 n_6149_1_4 n_6149_1_5 n_6149_2_0 n_6149_2_1 n_6149_2_2 n_6149_2_3 n_6149_2_4 n_6149_2_5 n_6149_3_0 n_6149_3_1 n_6149_3_2 n_6149_3_3 n_6149_3_4 n_4674_0_0 n_4674_1_0 n_4674_2_0 n_4674_3_0 n_6146_0_0 n_6146_0_1 n_6146_0_2 n_6146_1_0 n_6146_1_1 n_6146_1_2 n_6146_2_0 n_6146_2_1 n_6146_2_2 n_6146_3_0 n_6146_3_1 n_20116_0_0 n_20116_1_0 n_20116_2_0 n_20116_3_0 n_20161_0_0 n_20161_1_0 n_20161_2_0 n_20161_3_0 n_3436_0_0 n_3436_1_0 n_3436_2_0 n_3436_3_0 n_6183_0_0 n_6183_1_0 n_6183_2_0 n_6183_3_0 n_2867_0_0 n_2867_1_0 n_2867_2_0 n_2867_3_0 n_2867_0_0 n_2867_1_0 n_2867_2_0 n_2867_3_0 n_2887_0_0 n_2887_1_0 n_2887_2_0 n_2887_3_0 n_6194_0_0 n_6194_1_0 n_6194_2_0 n_6194_3_0 n_20401_0_0 n_20456_0_0 n_20457_0_0 n_20503_0_0 n_20504_0_0 n_20551_0_1 n_20551_0_2 n_20551_0_3]

save [in csv format]

[Rich Goldstein]

it is not at all clear what you tried to do but I think you need the -export delimited- command; see

h export

it is also not at all clear why a square bracket is the first character after -keep- as that is not allowed and is probably the genesis of the "weight not allowed" message; see

h keep

[Craig Smith]

Hi thanks for the reply.

So to clarify,

I am trying to "Keep" i.e remove all variables that aren't listed and then save to a .CSV file. Tried keep without square bracket now seems to be saying random variables are invalid.

BW,

Craig

[Rich Goldstein]

do not put commas between the variable names - commas are for separating the main command from command options and that is not what you are doing here; if the meaning of "varlist" is not clear, you could click on the blue link in the help file or see

h varlist

[Craig Smith]

Hi all,

Thanks for your replies. Tried removing commas and it didn't like some variables even though I copied them directly from the variable manager.

Wondering if it would be easier for all if maybe one of you were happy to walk me through this on MS teams at some point this week - could do Monday afternoon or Tuesday morning - Guessing its something straightfoward I'm missing?

Many thanks in advance,

Craig