Update: The first dataset is using a previous SAS code that imports data from Excel. The excel file, has the PIDs of AA-1000, but in this code is where it gets truncated to AA-100 when we run the code. So now we believe the issue to come from this initial setup SAS code. Or is this an issue with Excel? When we run the setup program we have a lot of import statements for multiple Excel files and sheets. When we merge the data, we get the same errors I had shown before, about various lengths being given to the PID variable as well as others. Running PROC Contents after merging shows that PID still has a format and informat of $6. I also ran PROC Contents on the first dataset imported from Excel and it gives me the same results. We are a little stumped because this is the very beginning of the data analysis. I even asked to be sure if there was nothing that came before that might have defined PID from a previous program but no. We have a format catalog inside one of the libraries we are referencing so I thought maybe the issue could be there but from what they told me there is nothing before this program that defined PID with something from the format catalog.
... View more