I have imported a list which is one variable and over 66k records (A1:A66000). I then need to create a list adding an apostrophe in order to query these IDs in the next data step for how the field is stored as VARCHAR. I am unable to create a list from the Proc Import since there are too many records. It appears I may need to run this below step several times to use the list(s) in my where statement. Is there a way in the below to add in a range from the proc import? Then maybe I can have NPI_LIST1, NPI_LIST2, NPI_LIST3 etc? Is there a way I an make sure the excel import is clean enough so that I do not need to add the apostrophes and change the records to VARCHAR? Or is there a better solution I am not considering? I am new to SAS so any guidance is greatly appreciated. PROC SQL: Select CATS(" ' ",NPI_ID," ' ") AS VARCHAR into: NPI_LIST1 separated by " ' " From Work.npis; Quit;
... View more