Hi @SASKiwi    You definitely saved my date, I am wondering why some of my countries importing from Excel and the first observation after sorting is blank. After applying your approach, it works well.   Warmest regards. ... View more

A CSV file does not show what data "should look like in sas". CSV files do not have any data types but SAS differentiates between numeric and character with dates, times and datatime values specially valued numeric variables.   If your code, which looks reasonable, isn't providing the result you expect tell us why not.   I suspect that the informat you have specified for NumberWorkers2015 $8. NumberWorkers2016 $8. MedianEarnings2015 $5. MedianEarnings2016 $5.; are incorrect as you are using CHARACTER informats, that is what the $ means in this use.   I think you might want to use COMMA6. for the Number variables to capture numeric values and best8. for the Median variables if you are looking for numeric values. ... View more

@Kurt_Bremser, I went back and made some suggestions based on what told me. I can now import the two different xlsx files into SAS right? Can you take a look one which is attached as a pic and the other as file?   Distribution along sex and age:      ... View more