Yes, you can use DISPLAY VARIABLES on both files to
compare the length of the (string) variables. If they
are not of equal length, you can use STRING (correct
length), then COMPUTE new = old. to create an ID with
the correct length.
Cheers!!
Albert-Jan
--- Daniel E WILLIAMS <
[hidden email]>
wrote:
> You should be able to merge on the strings, as long
> as they are the same
> length in each of the files.
>
> Dan Williams
> Forecasting, Research and Analysis Office
> Department of Human Services
> State of Oregon, USA
> 503 947 5354
>
> >>> "Scott Roesch" <
[hidden email]>
> 5/9/2007 10:55:10 AM
> >>>
>
> --------------------------------------------------
> Here is a message for you from
http://web2mail.com> The easy way to read and send POP email on the web
> --------------------------------------------------
>
> Hi all:
>
> I have some large data sets that I am working with
> that I need to
> merge. The issue is that the ID variables are
> string. A sample ID for
> one participant is PMS270 whereas for another
> participant it is SMF117.
> I need to use the common id to merge these files.
> Any ideas would be
> greatly appreciated. Thanks in advance!
>
> Scott
>
Cheers!
Albert-Jan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Did you know that 87.166253% of all statistics claim a precision of results that is not justified by the method employed? [HELMUT RICHTER]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Locked
