BookmarkSubscribeRSS Feed
ArchanaSudhir
Obsidian | Level 7

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

3 REPLIES 3
Astounding
PROC Star

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.

Cynthia_sas
Diamond | Level 26
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
kellios
Fluorite | Level 6
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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 8359 views
  • 2 likes
  • 4 in conversation