cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
droydroy
‎11-04-2023
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Index

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-04-2023 07:31 AM
‎11-04-2023 07:31 AM
When to use index ? Please share some scenarios where Index can be used in case of data manupulation ... View more

Re: Calculate lag of 6 Quater percentage change for 300 variables

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-03-2023 07:52 AM
‎11-03-2023 07:52 AM
Now I understood the logic behind arrays. Thanks a lot for teaching. ... View more

Re: Calculate lag of 6 Quater percentage change for 300 variables

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-03-2023 07:39 AM
‎11-03-2023 07:39 AM
Shall I create another loop to calculate lag of of these percentage change values ? Can that step be incorporated in this loop ? Aim is to calculate lag1 or lagi for these percentage change values ... View more

Re: Calculate lag of 6 Quater percentage change for 300 variables

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-03-2023 07:20 AM
‎11-03-2023 07:20 AM
6qtr percentage change = [( value in 2011Q2 - value in 2010Q1)/ value in 2010Q1]*100 Need to code in such a way that it can be used for 3qtr / 10 Qtr / 12 Qtr etc. ... View more

Re: Calculate lag of 6 Quater percentage change for 300 variables

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-03-2023 06:54 AM
‎11-03-2023 06:54 AM
Period var1 var2 var3 ....... var276 2010Q1 2.3 9 10 ....... 50 2010Q2 5.3 24 44 ....... 3 2010Q3 18.4 16 15 ........ 55 2010Q4 20 2 3 ........ 4 2011Q1 2 5 18 ........ 11 2012Q2 5.6 2 22 ......... 50 2013Q3 7 10 30 ......... 5 2014Q4 1 30 50 ........ 18.5 Upto 2050Q4 ... View more

Calculate lag of 6 Quater percentage change for 300 variables

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-03-2023 06:36 AM
‎11-03-2023 06:36 AM
We have 300 variables in the data set. Each variable is having quaterly data , for an example starting from Q12010 to Q12020. Now I am trying to calculate for each variable what will be the lag value of 6 quater percentage change. So I need to create 6 quater percentage change of eaxh variable and then calculate their lag values. Please help. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-04-2023 11:08 AM
Likes given to
View All
Quick links