PROC SQL;
/* Entwicklung */
CREATE TABLE TEMP AS
SELECT case when t1.KONTO_ID in (&Nostrokonten)
then 0 /* Nostrokonten */
else t2.MLR_ProduktgruppeID
end as MLR_ProduktgruppeID format=mlr_produktgruppe.,
sum(Bilanzsaldo) as Bilanzsaldo format=commax18.2,
t1.Stichtag
FROM S1_KONTO&stichtag t1
LEFT JOIN DB.MAPPING_GAB2MLR_PRODUKTGRUPPE t2
ON t1.GAB = t2.GAB
GROUP BY MLR_ProduktgruppeID,
Stichtag;
quit;
Either use an alias for the case statement that is not the same as the variable (t2.)MLR_ProduktgruppeID: i.e. ..AS MLR_ProduktgruppeID_2 and use the alias in the GROUP BY. Ambiguity between VAR and alias may be the issue AND/OR if that doesn't fix, also put the CASE statement longhand in the GROUP BY (without the AS...)
Either use an alias for the case statement that is not the same as the variable (t2.)MLR_ProduktgruppeID: i.e. ..AS MLR_ProduktgruppeID_2 and use the alias in the GROUP BY. Ambiguity between VAR and alias may be the issue AND/OR if that doesn't fix, also put the CASE statement longhand in the GROUP BY (without the AS...)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.