Prev: ODS Tagsets ExcelXP
Next: Help - Gini's Coefficient
From: Venky Chakravarthy on 19 May 2006 08:58 On Fri, 19 May 2006 00:52:55 -0700, Gaetan <gaetan.soulas(a)IFEN.FR> wrote: >Hello, > >excuse me for the language, I am french. > >I have a trouble : > >I have a colum in a data base and with values of this column, I would >like to create new var. > >ex : > >Name Sexe > >John Man >Rita Woman > >I would like to have in my database : > >Name Sexe Man Woman > >John Man 1 0 >Rita Woman 0 1 > >My trouble is : I have lots of differents values like (men, women, >men1, men2, men3 , ...) > >I have tried with macos functions SYMGET, SYMPUT to get automaticely >the values and create new columns bit I don't manage because the row : > >symget("var")=1 > >doesn't work. > >I hope you can understand what I say. > >Thank you > Ga?tan Gaetan, Sorry hit the send key prematurely. Can you present a small but representative sample of the data that you HAVE and the REPORT or the DATASET that you WANT out of it? Venky Chakravarthy |