Thank you for your input, but I did not use an INPUT statement. I also made sure both sets are character variable with 49 length.  ... View more

Wait! It is being truncated based on census tract number length. For example, "Census Tract 10.01, Mesa County, Colorado" is coming out "Census Tract 10.01, Mesa County, Colorad", but "Census Tract 101.05, Teller County, Colorado" is coming out "Census Tract 101.05, Teller County, Colora" ... View more

Okay- based on this code, it looks like the last letter of the word in the observations is being cut off ('Colorado' is coming out 'Colorad'). This is interesting, as the variables in both data sets appear correctly on their own and are both character variables with length 49. Man oh man, SAS can be confusing.  ... View more

I see your point. I tried this with my data, and it had the same problem, no matter which came first in the statement. Below I have attached the two files I am working with, along with some updated code: ***************************************************************************************** *CREATING REFERENCE TABLE*; *Rename CT in PhysicalActivity to TRACT_NAME*; DATA Phy_Act1; SET CoImpt.PhysicalActivity; *RENAME CT = TRACT_NAME; RUN; DATA Phy_Act2; LENGTH TRACT_NAME $49; SET CoImpt.PhysicalActivity; RUN; PROC SORT DATA=Phy_Act2; BY TRACT_NAME; RUN; PROC SORT DATA=CoImpt.Geo_Reference_Table; BY TRACT_NAME; RUN; *Merge PhysicalActivity with reference table (KEEP TRACT_NAME adult_pop COUNTY FIPS)*; DATA Ref_Tab; MERGE CoImpt.Geo_Reference_Table Phy_Act2; BY TRACT_NAME; KEEP TRACT_NAME adult_pop COUNTY FIPS; RUN; PROC PRINT DATA = Ref_Tab; RUN; ... View more

It does not give me a warning, it is just adding those lines. The code runs with no errors or warnings at this point, but I should only have 1249 observations. ... View more

A follow-up: I have just realized that TRACT_NAME in Geo_Reference_Table is 49 in length and PhysicalActivity is 48 in length (they are both character variables). Could this be the problem? How do I address this? ... View more

  Thank you both for your responses. Here is my log. I am happy to provide additional information as needed.  1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 %LET CourseRoot = /home/u63571562/BIOS6680_2023; 70 LIBNAME CoImpt "&CourseRoot/CDPHE Study/Data/2_Import"; NOTE: Libref COIMPT refers to the same physical library as _TEMP0. NOTE: Libref COIMPT was successfully assigned as follows: Engine: V9 Physical Name: /home/u63571562/BIOS6680_2023/CDPHE Study/Data/2_Import 71 LIBNAME CoAnl "&CourseRoot/CDPHE Study/Data/4_Analysis"; NOTE: Libref COANL was successfully assigned as follows: Engine: V9 Physical Name: /home/u63571562/BIOS6680_2023/CDPHE Study/Data/4_Analysis 72 73 *Rename CT in physical activity to tract_name*; 74 DATA Phy_Act1; 75 SETCoImpt.PhysicalActivity; 76 *RENAMECT= TRACT_NAME; 77 RUN; NOTE: There were 1249 observations read from the data set COIMPT.PHYSICALACTIVITY. NOTE: The data set WORK.PHY_ACT1 has 1249 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1200.40k OS Memory 23192.00k Timestamp 11/08/2023 08:24:10 PM Step Count 81 Switch Count 2 Page Faults 0 Page Reclaims 98 Page Swaps 0 Voluntary Context Switches 19 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 520 78 79 proc sort data=CoImpt.PhysicalActivity; 80 by TRACT_NAME; 81 run; NOTE: Input data set is already sorted, no sorting done. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 696.71k OS Memory 23188.00k Timestamp 11/08/2023 08:24:10 PM Step Count 82 Switch Count 0 Page Faults 0 Page Reclaims 91 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 82 83 proc print data=CoImpt.PhysicalActivity; 84 run; NOTE: There were 1249 observations read from the data set COIMPT.PHYSICALACTIVITY. NOTE: PROCEDURE PRINT used (Total process time): real time 0.93 seconds user cpu time 0.94 seconds system cpu time 0.00 seconds memory 1390.62k OS Memory 23188.00k Timestamp 11/08/2023 08:24:11 PM Step Count 83 Switch Count 0 Page Faults 0 Page Reclaims 79 Page Swaps 0 Voluntary Context Switches 1 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 704 85 86 *REFERENCE TABLE*; 87 *Merge physical activity with the reference table* 88 *Keep fips, county, tract_name, and adult_pop*; 89 *DATA Ref_table; 90 * MERGE CoImpt.PhysicalActivity CoImpt.Geo_Reference_Table; 91 *BY TRACT_NAME; 92 * KEEP FIPS COUNTY TRACT_NAME adult_pop; 93 * RUN; 94 proc sort data=CoImpt.Geo_Reference_Table; 95 by TRACT_NAME; 96 run; NOTE: Input data set is already sorted, no sorting done. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 537.81k OS Memory 23188.00k Timestamp 11/08/2023 08:24:11 PM Step Count 84 Switch Count 0 Page Faults 0 Page Reclaims 50 Page Swaps 0 Voluntary Context Switches 5 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 97 98 proc print data=CoImpt.Geo_Reference_Table; 99 run; NOTE: There were 1249 observations read from the data set COIMPT.GEO_REFERENCE_TABLE. NOTE: PROCEDURE PRINT used (Total process time): real time 0.58 seconds user cpu time 0.59 seconds system cpu time 0.00 seconds memory 648.46k OS Memory 23188.00k Timestamp 11/08/2023 08:24:12 PM Step Count 85 Switch Count 0 Page Faults 0 Page Reclaims 66 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 456 100 101 DATARef_Table; 102 MERGECoImpt.Geo_Reference_Table 103 CoImpt.PhysicalActivity; 104 BYTRACT_NAME; 105 RUN; NOTE: There were 1249 observations read from the data set COIMPT.GEO_REFERENCE_TABLE. NOTE: There were 1249 observations read from the data set COIMPT.PHYSICALACTIVITY. NOTE: The data set WORK.REF_TABLE has 2009 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 1658.62k OS Memory 23708.00k Timestamp 11/08/2023 08:24:12 PM Step Count 86 Switch Count 2 Page Faults 0 Page Reclaims 181 Page Swaps 0 Voluntary Context Switches 18 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 520 106 107 PROC PRINT DATA = Ref_Table; 108 RUN; NOTE: There were 2009 observations read from the data set WORK.REF_TABLE. NOTE: PROCEDURE PRINT used (Total process time): real time 1.96 seconds user cpu time 1.94 seconds system cpu time 0.01 seconds memory 848.21k OS Memory 23188.00k Timestamp 11/08/2023 08:24:14 PM Step Count 87 Switch Count 0 Page Faults 0 Page Reclaims 65 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 373 Block Input Operations 0 Block Output Operations 1344 109 110 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 120 ... View more

Thanks, this worked perfectly. The last piece I am struggling with is the SexCd. How do I make the values uniform? ... View more