Hi, The final two columns are causing a problem with my import. The full "room type" name is not appearing, only a small portion (if any) and the room rate column (final column) is sometimes appearing in the "room type" column. I believe the issue is tied to the spaces in the room type column and I am not coding appropriately to handle them. Any recommendations? I have searched a ton, and the options I have found have not worked. Current code is: DATA Hotel; INFILE 'E:\Users\skm190000\Desktop\Datasets\Hotel.dat'; informat roomnumber 4. guests$ 1. CI_month 1. CI_day 2. CI_year 4. CO_month 1. CO_day 2. CO_year 4. Internet$ 3. DaysInternetUse 2. RoomType$ 13. RoomRate 3. ; iNPUT roomnumber guests$ CI_month CI_day CI_year CO_month CO_day CO_year Internet$ DaysInternetUse RoomType$ RoomRate ; RUN; I changed the file from .dat to txt for this request. so code above will have a shift in the file name.
... View more