CODEWITHSUNDEEP
sas
William Salzman
William Salzman

Reputation: 6446

In SAS Proc SQL what does a "." as a column name mean?

I'm Converting some Proc Sql statements to t-sql. I have one that looks like

 Proc SQL
 Select 
  ... (extra lines of code here that select normal columns)
 . as NewColumnAlias,
  ... (more lines of code here that select normal columns)
 From $syslast
END

What does the "." in the above code mean? What column does it select?

Upvotes: 1

Views: 256

Answers (1)

Reeza
Reeza

Reputation: 21274

In SAS a period denotes a numeric missing value. This essentially sets your column to missing everywhere.

enter image description here

Upvotes: 2

Related Questions