DATA Step, Macro, Functions and more

PROC SQL

Reply
Occasional Contributor
Posts: 10

PROC SQL

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;

Frequent Contributor
Posts: 109

Re: PROC SQL

Extra comma at the end. Smiley Happy

 

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*/
Occasional Contributor
Posts: 10

Re: PROC SQL

Posted in reply to Satish_Parida

Thanks Satish... it works now... 

Super User
Posts: 9,580

Re: PROC SQL

. as Emp

means "assign a missing numerical value to newly created variable Emp".

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Occasional Contributor
Posts: 10

Re: PROC SQL

Posted in reply to KurtBremser

Thanks a lot folks!!!Smiley Happy

Ask a Question
Discussion stats
  • 4 replies
  • 96 views
  • 0 likes
  • 3 in conversation