Class assignment that I am stuck on. Sorry if this is simple. I need to split the last variable in the data City, state, zip code into 2 variables city and zip code. In the code I am calling the variables city and zipcode. I can not figure out how to have sas read the city separate from the zip code. I have tried the input statement that is blocked out with the /*.......*/ (this was done without the format statement and the other input statement shown below) but the city length is not the same distance. I tried a dlm comma statement but not all variables have commas separating, I tried the copied information statement to no avail. Data agentd; informat customer $1. date1 yymmdd10. date2 yymmdd10. city $30. zipcode 6.; /*input customer $ date1 : yymmdd10. date2 : yymmdd10. city $14. zipcode;*/ input customer date1 date2 city zipcode; format date1 date2 mmddyy8.; datalines; 1. 2014-03-11. 2014-05-31. Bremen, KS, 66412 2. 2015-08-06 2015-09-02. Little River, KS, 67457 Id love any suggestions from the masses of experts Ben
... View more