Hi all;  This text contains data on id, location ,date1, gender and dob, but dates in different formats. also the length of gender is different. how can i read this dataset using 'infile'?   id    location date1  gender DOB   001 pun 09-16-2010 male 04-28-1959 002 MUM 30MAY2010 F 15AUG1960 003 pun 08-18-2010 female 10-11-1961 004 MUM 12FEB2011 M 29APR1962   please answer the question. thanks. ... View more

i have a dataset like this. I want to use the first value of weight for the respective subjects.someone pls help me.         input                                 desired output id  weight                              id        weight  1    58                                    1        58 1     .                                      1        58 1     .                                      1        58 2    62                                    2        62 2     .                                      2        62 2     .                                      2        62 3    57                                    3        57 3     .                                      3        57 3    .                                       3        57     ... View more

hi all, I have a data set like this.   id  value 101  93 101  92 101  91 102  32 102  23 102  51 103  45 103  63 103  77   Whai I requires is to flag the minimum and max values out of this 3 values like:   id  value  min    max 101  93             Y 101  92 101  91     Y 102  32 102  23     Y 102  51             Y 103  45     Y 103  63 103  77             Y   someone please post the soln.thanks.   ... View more

input name $15. +5 age 2. what is the use of +sign here? ... View more

hi sub   var 110 new 111 1234 101  char 100  321 in the above table 'var' being a character variable, pls help me to solve newvar=input(var,best.);? ... View more

can anybody tell me the difference between find() and index() giving an example.  ... View more

how can I rename a datavalue down the column?ie to change the value of locale variable from en to English for all the observations? ... View more