@Kurt_Bremser @SASKiwi Okay, when I import both of my excel files as csv files and press the run on both of the code files, it does output all the information with commas and all. But now when I create a permanent dataset for the SexAgeInfo, it doesn't output the exact format as my original data in the csv files. How can I fix this? Should I use format keyword when creating a permanent data? Also, how will I solve the problem of getting the men and women into my dataset for each year so a user can know which gender is associated with the age ranges in my SexAgeInfo dataset? Here is my generated output for each dataset named EthnicitySexInfo and SexAgeInfo: More Info: You can take a look back at the original dataset before I split up it between the two datasets now (this is so you know how it originally looks -if you want to https://communities.sas.com/t5/Base-SAS-Programming/Is-SAS-dataset-Okay-to-work-with/m-p/413753#M101305) EthnicitySexInfo datset Obs Characteristic VAR2 VAR3 VAR4 VAR5 1 Men 48,746 49,310 920 942 2 Women 36,698 37,163 743 766 3 Men 6,445 6,728 680 718 4 Women 7,142 7,235 615 641 5 Men 3,684 3,888 1,129 1,151 6 Women 2,954 3,142 877 902 7 Men 11,142 11,666 631 663 8 Women 7,168 7,284 566 586 SexAgeInfo dataset: Obs Characteristic VAR2 VAR3 VAR4 VAR5 1 16 to 24 years 5,476 5,646 510 512 2 25 years and over 55,270 56,284 947 969 3 16 to 24 years 4,314 4,430 450 486 4 25 years and over 44,020 44,731 761 784
... View more