BookmarkSubscribeRSS Feed
Ashpak
Calcite | Level 5

Data set growth has 50K records

here are sample data set looks like, I would like to compare by node,period  of growth value  (REC1-Rec2)> +-5000 the select the Node or display the node

 

this needs to repeated all the records by node and period only

 

STRATEGYNODEPeriodFast_GROWTH_DAY_NUMGROWTH_VALUE
Mar9QF Strategy8929221132468.1295
MML Strategy8929221132468.1295
MML Strategy8929222136007.7485
Mar9QF Strategy8929222136007.7485
Mar9QF Strategy8929223136007.7485
MML Strategy8929223136007.7485
MML Strategy8929224136007.7485
Mar9QF Strategy8929224136007.7485

 

How to do this SAS

 

2 REPLIES 2
japelin
Rhodochrosite | Level 12

In this sample data, can you indicate which data you want to compare with which data?

andreas_lds
Jade | Level 19

Please post data in usable form and show what you expect as result.

The lag-function can be used to access values in prior observation(s).

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
  • 935 views
  • 0 likes
  • 3 in conversation