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...)
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: