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: 
bluetail
‎09-01-2015
  • 10 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: convert to numeric by id?

by Calcite | Level 5 in SAS Procedures
‎08-23-2011 09:46 AM
‎08-23-2011 09:46 AM
bcos i need to run PROG PANEL later, as i said, and it needs string or numeric. ... View more

Re: convert to numeric by id?

by Calcite | Level 5 in SAS Procedures
‎08-22-2011 05:20 PM
‎08-22-2011 05:20 PM
yep . told it'd be simple.  have tried a similar command before myself but somehow did not work. ... View more

Re: convert to numeric by id?

by Calcite | Level 5 in SAS Procedures
‎08-22-2011 05:07 PM
‎08-22-2011 05:07 PM
hmm.. not exactly.  i tried this, idnumber=rank(idnname)-50; it starts with 1 but then misses some numbers. it shows as 1, 2, 4, 15.. and ends with 40 although i have 300 stocks (so the last idnumber should be 300). there are just stock names, so should be by 'idname'. ( PROC PANEL  will only run if for each stock  a numeric  is assigned) idname   year idnumber stockA        96               1 stockA        97               1 stockA        98               1 stockB        96               2 stockB        97               2 stockC        96               3 stockC        97               3 stockC        98               3 stockC        99               3 ... View more

convert to numeric by id?

by Calcite | Level 5 in SAS Procedures
‎08-22-2011 04:10 PM
‎08-22-2011 04:10 PM
need to convert id from character to numeric in the following fashion (to use in a panel data regression later):    idname  idnumber        a       1          a       1          a       1          a       1           a       1             b       2         b       2          b       2    c       3    c       3    c       3    c       3 ... View more

Re: how to add a rolling date?

by Calcite | Level 5 in SAS Procedures
‎08-21-2011 06:53 AM
‎08-21-2011 06:53 AM
oh art297, thanks again so much..:) i tried these this morning and both have worked. i was going mad about this - you're right im not a specialist, only using SAS as part of a project.  to this 1st command, SAS produced NOTE: Invalid argument to function MDY at line 31 column 15. which refers to monthmarch=mdy(month(date)-2,1,holdyear); however, despite of this, it has delivered the result alright. I just used this simple command, yearmarch=year(intnx('year.3',date,0)) since it allows me to compute variance and sum within each year.   Maria ♥ ... View more

Re: how to add a rolling date?

by Calcite | Level 5 in SAS Procedures
‎08-20-2011 02:28 PM
‎08-20-2011 02:28 PM
reading also about time intervals in SAS.. basically what i need, is to define an interval from march to march each year for the variable 'res', and then work with it (calculate sum, mean and var within each interval). maybe i could use the INTNX function & Year.3 to shift them... ... View more

Re: how to add a rolling date?

by Calcite | Level 5 in SAS Procedures
‎08-20-2011 12:08 PM
‎08-20-2011 12:08 PM
reports syntax errors so far...if i solve it i'll post.  ♥ data want; set have;   by id;     retain counter holdyear;   if first.id then counter=0;   if month(date) gt 2 then holdyear=year(date); counter=counter+1;   if counter gt 2 or month(date) gt 2 then monthmarch=mdy(month(date)-2),1,holdyear);    else monthmarch=mdy(month(date)+10),1,holdyear); run; ... View more

how to add a rolling date?

by Calcite | Level 5 in SAS Procedures
‎08-20-2011 10:13 AM
‎08-20-2011 10:13 AM
                     month        id    res              monthmarch   res                  1/1996       a       15  -----------  .           15     2/1996       a       10  -----------  .           10   3/1996       a       7   -----------  1/1996      7 4 /1996       a       10  -----------  2/1996      10 5/1996       a       6   ------------   3/1996      6 6 /1996       a       11  -----------  4/1996      11      7/1996       a       12  -----------  5/1996      12 8/1996       a       9   ----------- 6/1996        9 9 /1996       a       10 -----------  7/1996        10 10/1996      a       8  -----------  8/1996        8 11/1996      a       10 -----------  9/1996        10 12/1996      a        10 -----------  10/1996       10 1/1997       a       15 -----------  11/1996       15   2/1997       a       10 -----------  12/1996       10 3/1997       a       7 -----------   1/1997        7 4/1997       a       10 -----------  1/1997        10 1/1996       b       12 ------------ .             12 2/1996       b        8 ------------ .             8 3/1996       b       10 ------------ 1/1996         10 4/1996       b       8  ------------ 2/1996         8 5/1996       b       17 ------------ 3/1996        17 ; hello. i have the following problem - i need to construct a rolling year estimate, e.g. to create a column 'monthmarch' which  is 2 months after 'month'( the 1st month is 01/1996 so i want it to be rolled forward by 2 months..). this is for companies with id a,b...z which financial year starts in march rather than in january...then i'd be able to sum the data in res. thank you so much.  maybe this is a simple command but i just cant think of anything. i tried this, but it only changes months within the same year. data have; set have; format month date9.; a=(month(date)+2); if a>12 then a=1; month=mdy(a,1,year(date)); drop a; run;   Maria ... View more

how to sum within column with 2 sorting variables?

by Calcite | Level 5 in SAS Procedures
‎08-07-2011 11:56 AM
‎08-07-2011 11:56 AM
art297, thank you for a quick reply   - you're a star!   i tried it before but missed out the ' if last.date' part ... View more

how to sum within column with 2 sorting variables?

by Calcite | Level 5 in SAS Procedures
‎08-07-2011 11:07 AM
‎08-07-2011 11:07 AM
Hello, Suppose i have such dataset : date   id    res     sumres 1       a       10       1       a       15       1       a       10       35 2       a       12        2       a        8       2       a       10       30 1       b       10      1       b       17       1       b       12       39 ; I need to calculate these sumres (35, 30, 39....) in a new dataset which are for id=a and date=1, for id=a and date=2, id=b and date=1, id=b=2 and so on... i have dates from 1...30. its probably a loop,  if first.date=....do;..but cant figure it out. anyone knows how to do it? i'd be immesely grateful. cheers, M ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links