Hi SAS Forum,
Could anyone help me to understand what this green highlighted 'n means in this SQL right joining?
PROC SQL;
CREATE TABLE WORK.A33 AS
SELECT A11.Audit_num LABEL ="Audit_num",
A11.IDnum LABEL ="IDnum",
A11.Amount_month1 LABEL ="Amount_month1",
A22.IDnum LABEL ="IDnum" AS 'IDnuma (IDnum)'n,
A22.Amount_month1 LABEL ="Amount_month1" AS Amount_month1a
FROM WORK.A22 A22 RIGHT JOIN
WORK.A11 A11 ON
(A22.Audit_num = A11.Audit_num);
QUIT;
Thanks
Miris
It asks SAS to accept the string "IDnuma (IDnum)" as a variable name. - PG
It asks SAS to accept the string "IDnuma (IDnum)" as a variable name. - PG
Hi PGStats,
Thank you very much for explaining this to me.
Regards
Miris
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.