Hi,  I am trying to calculate an average value for different variables based on the provider.  That is my code so far:    proc sql; select round(mean(durchschnitt_pnps)) into: avg_pNPS from xwrk.nps_durchschnittsebenen1; select round(mean(durchschnitt_cnps)) into: avg_cNPS from xwrk.nps_durchschnittsebenen1; select round(mean(durchschnitt_enps)) into: avg_eNPS from xwrk.nps_durchschnittsebenen1; select round(mean(durchschnitt_brand_attributes)) into: avg_brand_attributes from xwrk.nps_durchschnittsebenen1; quit; data xwrk.nps_ebenen_geglättet; set xwrk.nps_durchschnittsebenen1; if missing(durchschnitt_pnps) then durchschnitt_pnps = &avg_pNPS; if missing(durchschnitt_cnps) then durchschnitt_cnps = &avg_cNPS; if missing(durchschnitt_enps) then durchschnitt_enps = &avg_eNPS; if missing(durchschnitt_brand_attributes)then durchschnitt_brand_attributes = &avg_brand_attributes; run; Thanks for help 🙂  ... View more

Hi,  I am trying to create a scatterplot with my variables rNPS and pNPS. Unfortunately, the generated scatterplot looks very strange and I can't explain why.   This is my code and the output scatterplot:   ODS Graphics on; proc sgplot data=xwrk.nps_ebenen_vollständig; scatter x=pnps y=rnps; run; I already checked the correlation between those two variables and there is a positive and significant correlation.    Has anyone already had this problem and can help me?   Thanks a lot! ... View more