Thanks for the reply! I'm having a hard time getting the code to run. I ended up switching the proc sql to look like: proc sql; select distinct weight_status into : parameter separated by " " from heart where weight_status ne ""; quit; Could you further explain the line you suggested? select distinct cats("%","param(",weight_status, "," weight_status, ");"), weight_status into: parameter separated by " ",:nicename I received a character limit exceeded error on this. Not surprising given the number of distinct providers (each with 9-10 digit ids) was 3,570 but the number of records when they were at the patient level (not distinct providers) was 1.129 million. It was not immediately apparent what all parts of this were so I tried mine above as a fix to the error and it seemed to make a list just fine. But then on the next step I have (modified after my modification above): %macro param(parameter); ods graphics / reset width=5in height=3in imagename"histogramOverlay"; /* any other name caused an error about imagename so I stopped trying to add more*/ proc sgrender data=heart template=histogram; run; %mend; %param(¶meter); This gives an exception and recommends I contact technical support. Task name SGRENDER (2). ERROR: Read Access Violation SGRENDER (2) and it gives the location of the exception and task traceback. Ideas? Would better understanding the line in proc SQL solve this???? Thanks for the help!
... View more