I imported these files first as CSVs and then had an issue with the formatting so I saved them all as XLSX and reimported but had different issues with formatting. I went back and reimported them all again as CSVs and have this issue with the formatting. I want to keep the CSV imports but need to fix the formatting issues in variables: QUAL_CD, SALE_PRC1, SALE_YR1. Here is a screen shot of my SAS file from the CSV import: Here is a screen shot from the SAS file of my XLSX import: The CSV import has them all as Character and only keeps the first digit. The XLSX file has them as numeric and has the full value. All of them should be character except for sale_prc1. I am thinking all I need to do is some sort of format change, but am not quite sure how. I want to change the sale_prc1 to a numeric variable and accommodate for up to 10 digits. I want to keep those other variables at character but get all the digits to show.
... View more