As you can see, at observation 12, the value should be "Dracula:Dead and Loving It (1995)" for the title. However, I got what's shown in the picture above. This is my code: libname perm '/home/cheok19970/Assignment'; data perm.movies; informat MovieID 4. Title $60. Genre $50.; infile '/home/cheok19970/Assignment/movies.dat' dlm=':|'; input MovieID Title $ Genre $; run; Since I put colon and vertical pipe as the delimiter, the code is eliminating all the ":" and "|" in the data set. Besides, the output genre only shows one genre. How do i fix it?
... View more