BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Mathis1
Quartz | Level 8

Hello there !

I'm looking to keep in a table the observations whose values of a price variable are close, for instance (1% to each other).

 

For instance 

Obs1 - 356.12

Obs 13 - 356.13

Obs 26 - 234.13

Obs 73 - 234.14

Etc...

 

Thanks a lot for your help !

(I precise that I do not have a very advanced level on SAS)

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

Sort by the price variable, then you can use lag() and a look-ahead to compare with previous and following values.

For (tested) code, provide an example of your dataset in usable form (a data step with datalines).

View solution in original post

2 REPLIES 2
Kurt_Bremser
Super User

Sort by the price variable, then you can use lag() and a look-ahead to compare with previous and following values.

For (tested) code, provide an example of your dataset in usable form (a data step with datalines).

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 2 replies
  • 1412 views
  • 0 likes
  • 2 in conversation