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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.