Sorry for the mistake Jeffrey. There was a minus sign
missing in the substring command.
The right one is here :
.gen v`i'=substr(var2,-(7-`i'),1)
--- Jeffrey Simons <[email protected]> wrote:
> Thanks to both nick and nikos.
>
> Nick's solution works well provided that I have a
> number value that takes
> on 6 digits otherwise it assigns the value for code6
> as missing
>
> That is
>
> var1
> 29
>
> Results in
>
> var1 binary code1 code2 code3 code4 code5
> code6
> 29 11101 1 1 1 0 1
>
> But
>
> var1
> 29
> 35
>
> Results in
>
> var1 binary code1 code2 code3 code4 code5
> code6
> 29 011101 0 1 1 1 0
> 1
> 35 100011 1 0 0 0 1
> 1
>
> So , I can just make sure I include a data point
> that will require a 6 digit
> binary code and it will work well.
>
> Nikos solution seems to shift the numbers and puts
> in trailing zeros rather
> than leading zeros
>
> That is
>
> var1
> 29
>
> Expands to
>
> var1 var2 v6 v5 v4 v3 v2 v1
> 29 11101 1 1 1 0 1 0
>
>
> Thank you both for your prompt and thoughtful
> solutions.
>
> -egenmore- on SSC has a function -base()- that
> gets you halfway with this.
>
> . egen binary = base(var1)
> . forval i = 1/6 {
> . gen str1 code`i' = substr(binary,`i',1)
> . }
>
> Nick
> [email protected]
>
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[email protected]]On
> Behalf Of
> > Jeffrey Simons
> > Sent: 10 March 2004 13:48
> > To: [email protected]
> > Subject: st: Re: decimal to binary conversion
> >
> >
> > I want to take a variable that is in decimal
> format and
> > convert it to a six
> > digit binary number. Then take that and form six
> new
> > indicator variables.
> >
> > For example,
> >
> > . inbase 2 29
> > 11101
> >
> > Provides this. I would like to write a do file to
> loop
> > through the values of
> > a variable and do this. Converting the answer to
> six new indicator
> > variables.
> >
> > So if var1 took on values of 15, 29, 35, ...
> > I'd like to get
> >
> > var1 v1a v1b v1c v1d v1e v1f
> > 15 0 0 1 1 1 1
> > 29 0 1 1 1 0 1
> > 35 1 0 0 0 1 1
> > ....
>
>
> *
> * For searches and help try:
> *
> http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
