Thanks Nick for the promt response. I've fixed it using the string functions you recommended.
Alexander Quarshie
>>> [email protected] 05/27/03 01:46PM >>>
Alexander Quarshie
> I am trying to merge two files in Stata 8 based on a unique
> identifier (ID). However some of the values or ID's are in
> upper cases in one file, and lower cases in the other.
> Stata seems to treat each of these as unique.
> I wish therefore to convert all the ID's to one uniform
> format ( either Upper or Lower case) in Stata before doing
> the merge.
> How can l do this conversion in Stata?
The -upper()- and -lower()- functions can be found
documented under string functions.
There is a presumption here that the ids are not
themselves case-sensitive.
Nick
[email protected]
*
* 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/
*
* 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/
