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
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.
Ready to level-up your skills? Choose your own adventure.