Can anyone pls explain what actually happen in the below sas script. I am unable to understan .AS in the script.
PROC SQL;
CREATE TABLE in.AAAA as
SELECT
Client AS IDNumber,
CIDNumber AS au_IDNumber,
. as Emp,
BN871,
BN562,
BN123,
BN346,
. as MT111,
. as MT112,
. as MT113,
. as MT114,
D_host,
AXZ_host,
TJD_AG,
FROM in.PME_SDC;
QUIT;
Extra comma at the end. 🙂
PROC SQL;
CREATE TABLE in.AAAA as
SELECT Client AS IDNumber, CIDNumber AS au_IDNumber, . as Emp, BN871, BN562, BN123, BN346, . as MT111, . as MT112, . as MT113, . as MT114, D_host, AXZ_host, TJD_AG
FROM in.PME_SDC;
QUIT;
/*Now try*/
Thanks Satish... it works now...
. as Emp
means "assign a missing numerical value to newly created variable Emp".
Thanks a lot folks!!!:)
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.