I am trying to convert ID's from 1A,1B,1C,and 1D to 2-001. But I have 66 id's (66A,66B,66C,66D to 2-066) so instead of typing them one at a time like below, is there a way to create a some sort of loop or array? I've tried to look something up but only find things for arrays of columns. Thanks! PROC SQL;    CREATE TABLE WORK.QUERY_FOR__Study_Data AS    SELECT t1.CISBR_ID,           t1.'Local ID'n,    (CASE    WHEN t1.'Local ID'n like "11%" then "2-011"    WHEN t1.'Local ID'n like "10%" then "2-010"    WHEN t1.'Local ID'n like "1%" then "2-001"    WHEN t1.'Local ID'n like "2%" then "2-002"    WHEN t1.'Local ID'n like "3%" then "2-003"    WHEN t1.'Local ID'n like "4%" then "2-004"    WHEN t1.'Local ID'n like "5%" then "2-005"    WHEN t1.'Local ID'n like "6%" then "2-006"    WHEN t1.'Local ID'n like "7%" then "2-007"    WHEN t1.'Local ID'n like "8%" then "2-008"    WHEN t1.'Local ID'n like "9%" then "2-009"   else "."    end)    Format $Char8. as Subject_ID,            t1.'Conc1 pg/mL'n,           t1.'Conc2  pg/mL'n,           t1.'Mean pg/mL'n,           t1.'Laboratory Code'n,           t1.'CISBR Comments to Investigator'n       FROM WORK.Study_Data  t1; QUIT; ... View more

Hi, I'm looking to create a scatter plot matrix with regression lines that also displays the r-squared and p value in an inset for each graph. I have tried using proc template with scatterplotmatrix, but I can only get a pearson correlation in the inset, and no regression line. I also tried proc sgscatter, but cannot get the inset to display the statistical information I need. Does anybody have any suggestions on how I can accomplish this? Thanks ods graphics on; proc sgscatter data=work.query_for_stabsummarytablesfilte; compare y=(FairnessIdxAvgTotal_Mean EqGiniVisibleTotal ) x=(GES1_SUM GES61_SUM COH4_SUM) / Legend=(Position=Bottom) reg=(clm nogroup) ; Title "Group Variables"; label FairnessIdxAvgTotal_Mean="Group Fairness Idx"   EqGiniVisibleTotal = "Equality Barrier Reveals"    GES1_SUM = "GES:Unity"    GES61_SUM = "GES:Proud"    COH4_SUM = 'PCQ:Best Anywhere'; WHERE groupName = 'A' OR groupName = 'B' OR groupName = 'C' OR groupName = 'D' OR groupName = 'E'; run; proc template; define statgraph spminset; begingraph; entrytitle "Group TPT Metrics and Cohesion"; entrytitle 'Concordia 2013'; layout gridded; scatterplotmatrix GES1_SUM GES61_SUM COH4_SUM/   rowvars=(FairnessIdxAvgTotal_Mean EqGiniVisibleTotal)   inset=(nobs pearson pearsonpval)   insetopts=( border=true opaque = true)   corropts=(nomiss=true vardef=df)   markerattrs=(size=4px)   ellipse=(alpha=.20 type=predicted); endlayout; endgraph; end; run; proc sgrender data=work.query_for_stabsummarytablesfilte template=spminset; WHERE groupName = 'A' OR groupName = 'B' OR groupName = 'C' OR groupName = 'D' OR groupName = 'E'; label FairnessIdxAvgTotal_Mean ="Group Fairness Idx"    EqGiniVisibleTotal = "Equality Barrier Reveals"    GES1_SUM = "GES:Unity"    GES61_SUM = "GES:Proud"    COH4_SUM = 'PCQ:Best Anywhere' ; run; ods graphics off; ... View more