Hello, I have a question about the data processing. I have a table, have three columns, e.g. V1, V2 and V3. The system will standardize the variables, will generate new column to store the results, e.g. STD_v1, STD_v2, STD_v3. But sometimes, value of a column only contains value 0, hence the STD_V# will not be generated. Can please suggest that code to 1. determine if the STD results exist, e.g.STD_v1, STD_v2 etc. 2. if yes, do nothing, but if no, generate a new column with values 0 in that column? e.g. if STD_v1 doesnot exist, generate a column in table with name STD_v1, and all values for that column is 0. Many thanks
... View more