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: 
hasnat
‎04-05-2019
  • 5 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: sorting by within values of a variable

by Calcite | Level 5 in New SAS User
‎10-07-2018 04:31 PM
‎10-07-2018 04:31 PM
Hi thanks. the idea of dissecting the variable from the start was great as it had more than one million obs. I did that in excel and imported and everything worked well. ... View more

sorting by within values of a variable

by Calcite | Level 5 in New SAS User
‎10-07-2018 05:22 AM
‎10-07-2018 05:22 AM
Hi. Is there anyone out there who can help me how to further sort this data.   Data E1; input KYGVKEY & FYYYYQ & EPSFIQ; *Sample data given, where KYGKEY=firm identifier, FYYYYQ=fiscal year and quarters, EPSFIQ= (an)earning per share; CARDS; 1690 1980.0 0.06 1690 1980.1 0.06 1690 1980.3 0.07 1690 1980.4 0.14 1690 1981.0 0.08 1690 1981.1 0.09 1690 1981.3 0.11 1690 1981.4 0.04 1730 1980.0 0.10 1730 1980.1 0.15 1730 1980.3 0.08 1730 1980.4 0.22 1730 1981.0 1.08 1730 1981.1 0.19 1730 1981.3 1.11 1730 1981.4 0.04 ; RUN; PROC PRINT DATA=E1; RUN; *Required is to sort/arrange this data by firm's identifier=KYGVKEY, and cross-sectional quarters: 1st quarters from 1980 and 1981 comes first and 2nd next and so on with corresponding EPSFIQ, to compare EPSFIQ of each quarter with corresponding quarter of last year; ... View more

Re: Splitting a set of positive & increasing values-growth, from the f...

by Calcite | Level 5 in New SAS User
‎10-03-2018 12:10 PM
‎10-03-2018 12:10 PM
Hi Marlene! Yes today my course coordinator spent a couple of hours and came up with desired results, your 'if' statement idea was incorporated. Once i do it myself, i would update here as well as i did not explicitly seek teacher's permission to share the code. ... View more

Re: Splitting a set of positive & increasing values-growth, from the f...

by Calcite | Level 5 in New SAS User
‎10-02-2018 10:09 AM
‎10-02-2018 10:09 AM
Hi. Thanks for your help and feedback. I ran your code and edited a bit but realized that description of the post was indeed not sufficient, I have elaborated further.   ... View more

Splitting a set of positive & increasing values-growth, from the fluct...

by Calcite | Level 5 in New SAS User
‎10-01-2018 02:08 PM
‎10-01-2018 02:08 PM
Hi.  Can someone help me how to sort this attached sample financial accounting data in SAS 9.4 or SAS Studio (the real data could be few hundred thousands obs).  Link to the SAS file as i could not attach here: https://1drv.ms/f/s!AhVkgVJPuTkWh03K4IT_COxuKZwP   Let EPSFIQ be the representative of earnings of the firm 1690. I want to see how many times over the sample period the firm 1690 has consecutively reported earnings more than last quarter, and by 'consecutive' i expect the firm should have reported earnings more than last quarter 5 consecutive times for the earnings string to be considered as consecutive. So this period of 5 consecutive increased earnings can be called an earnings string. In other words, the condition for such strings is 5 consecutive increases in EPSFIQ. I want to separate such earnings strings from the rest of the data.  (Updated) Thanks in advance for your time.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-05-2019 06:28 PM
Likes given to
View All
Quick links