Hi @harveysarah0
As mentionned by @Tom (Thank you @Tom !), the DSD option will enable you to manage the release date variable properly, as this option specifies that when data values are enclosed in quotation marks, delimiters within the value are treated as character data.
The following code should work:
data albums;
infile cards dlm="," dsd;
input Album:$50. Artist:$50. ReleaseDate:anydtdte. TotalCertifiedCopies ClaimedSales Genre:$20.;
format ReleaseDate worddate.;
cards;
Thriller,Michael Jackson,"November 30, 1982",46.3,65,Pop
Back in Black,AC/DC,"July 25, 1980",26.1,50,Rock
The Dark Side of the Moon,Pink Floyd,"March 1, 1973",24.2,45,Rock
The Bodyguard: Original Soundtrack Album,Various Artists,"November 17, 1992",27.4,44,Soundtrack
...
Appetite for Destruction,"Guns N' Roses","July 21, 1987",21.6,30,Metal
;
Best,
... View more