I have airline origin and destination data that looks like:
Departure Destination Current Count Previous Count
CYEG CYYZ 51 22
CYYZ CYEG 53 67
RPLL CYYZ 21 6
CYVR CYYC 11 9
CYYC CYVR 15 1
What really matters is the total traffic between COMMON city pairs. What would be good would be to get output as:
Common City Pair Current Count Previous Count
CYEG <--> CYYZ 104 89
RPLL <--> CYYZ 21 6
CYVR <--> CYYC 26 10
The values in the Current Count and Previous count are now the sums of the COMMON city pairs in the original data. Common city pairs can be anywhere in the dataset and not necessarily right after one another.
Thanks!
thanks!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.