Using SAS Enterprise Guide I have 22 excel data sets that all include the same variables in the same order. These datasets are broken down 2016 weeks 1-5, 2016 weeks 6-10, 2016 weeks 11-15, etc..... I am using "Import Data" in SAS Enterprise Guide to import all 22 files, and then would like to append all 22 so I have one long dataset. However, when importing the files some of the variables by default have different formats. In dataset 1 , "Volume" has [TYPE=NUMBER, SOURCE INFORMAT=BEST12, LENGTH=8] however in dataset 2, "Volume" has [TYPE=NUMBER, SOURCE INFORMAT=BEST12, LENGTH=10]. Since the variable volume has different formats, I am unable to append the datasets. This is a simplified example as I have approx. 90 variables in each of the 22 datasets. Around 20 or so of the variables are having the issue of different formats. Is there any way to have the datasets all upload with the same formats? The only solution I know would be to individually change the formats in the "Determine Field Attributes" during the upload process which would be very time consuming.
... View more