DATA Step, Macro, Functions and more

Record vs observation

Reply
Contributor
Posts: 53

Record vs observation

Hi,

 

I am reading topics on creating multiple observations from a single record {@,@@) and creating one observation per detail record.

 

I am getting confused between record and observation. Is there a easy way to understand the difference?

 

Thanks,

Archana

Super User
Posts: 5,516

Re: Record vs observation

Posted in reply to ArchanaSudhir

There's no real difference.  They both mean a single row of data.  SAS documentation uses "observation" to mean a row of data in a SAS data set, and "record" to mean a row of data from any other source.

SAS Super FREQ
Posts: 8,868

Re: Record vs observation

Posted in reply to Astounding
Hi:
These all mean the same thing:
observation=row=record
variable=column=field
dataset=table=file

For example, observation, variable and dataset are SAS terms; row, column and table are relational database terms; row, column and sheet are Excel terms; record, field and file are mainframe file terminology.

cynthia
New Contributor
Posts: 4

Re: Record vs observation

Posted in reply to Astounding
Just to add, because I was confused about this. There are times when a single observation may come from multiple rows of data (i.e multple records). eg:

Bob 2 Turtle
Green Michigan
Amy 3 Dog
Blue Alabama

When we read this correctly, there result will be 2 observations.
Ask a Question
Discussion stats
  • 3 replies
  • 483 views
  • 2 likes
  • 4 in conversation