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: 
ygity
‎04-11-2016
  • 8 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: need some help with left join tables

by Calcite | Level 5 in SAS Programming
‎04-11-2016 12:09 AM
‎04-11-2016 12:09 AM
thanks so much... i am new to the SAS world.. thanks for the fast and helpful replys ... View more

Re: need some help with left join tables

by Calcite | Level 5 in SAS Programming
‎04-10-2016 11:53 PM
‎04-10-2016 11:53 PM
yep because i want from day-1 to day3 of the L.date.. ... View more

Re: need some help with left join tables

by Calcite | Level 5 in SAS Programming
‎04-10-2016 11:45 PM
‎04-10-2016 11:45 PM
not by month... the L.date is the date of an event happened.. and surrounding L.date there is the R table observations... i want to have the cumulative R.news to be joined with L.*.. the cumulative day0_day5 means L.date to L.date+5... and day-1_day3 means L.date-1 to L.date+3 ... View more

Re: need some help with left join tables

by Calcite | Level 5 in SAS Programming
‎04-10-2016 11:27 PM
‎04-10-2016 11:27 PM
nono... just these two here... Cumulative_news_day0_day5 Cumulative news from 01/01/1998 to 05/01/1998 Cumulative_news_day-1_day3 Cumulative news from 31/12/1997 to 03/01/1998 thanks ... View more

Left Join and aggregate on date intervals

by Calcite | Level 5 in SAS Programming
‎04-10-2016 10:27 PM
‎04-10-2016 10:27 PM
dear forum... i need some help on writeing up the code....     the L.* looks like this Date                    Code      01/01/1998          A   the R.* looks like this Date                    Code                   News 02/01/1998          A                         5 03/01/1998          A                         2 05/01/1998          A                         1   the combined i want looks like this   Date                   Code                  Cummulative_news_day0_day5           Cummulative_news_day-1_day3 01/01/1998         A                        8(5+2+1)                                              7(5+2)     where day 0 indicates the L.date and day1 day2 means the following dates... and day-1 means the previous day.. in the example here Cummulative_news_day-1_day3 it got no data from 31/12/1997...   i got stuck at this problem like a week... thanks for your time...you the best   ... View more

Re: need some help using proc expand

by Calcite | Level 5 in SAS Programming
‎03-19-2016 10:51 PM
‎03-19-2016 10:51 PM
proc expand data=BV out=temp to=day; id date; by code; convert BV / observed=(beginning,end); run;     the source data were in irregular periods for all the stockIDs eg stock A might have BV at 1999Q1 and the next ob could be 2008Q2; while stock B might have a BV at 2005Q2 and the next ob for stock B might be 2009Q3... and i want stock A have the same BV from 1st day of 1999Q1(19990101) to the last day of 2008Q2(20080630) have the same BV as in 2008Q2...same for stock B to have the same BV from 1st day of 2005Q2(20050301) to the last day of 2009Q3(200909030)...   and thanks so much for the reply ... View more

Re: need some help using proc expand

by Calcite | Level 5 in SAS Programming
‎03-19-2016 08:07 PM
‎03-19-2016 08:07 PM
the data come in irregular periods I want to convert them into regular daily obs showing the next(lead) BV value ... View more

need some help using proc expand

by Calcite | Level 5 in SAS Programming
‎03-19-2016 07:26 AM
‎03-19-2016 07:26 AM
dear forum, i am a new student learning with SAS, i got stuck at one thing for like a week and still cant figure out what to do to achieve the thing i want...   the beginning data set looks like this StockID       Date              BV A               1999Q1           202 A               2000Q2           308 A               2001Q3           405 B               1995Q2           507 B               1998Q1           609 B               1999Q4           201   the data i want looks like this StockID        Date              BV A               19990101        308 A               19990102        308 A               19990103        308 A               19990104        308 A                .                      . A                .                      . A                .                      . A               20000531        308 A               20000601        405 A               20000602        405 A               .                       . A               .                       . B              19950601         609 B              19950602         609 B              .                        . B              .                        . B              19971231        609 B              19980101        201 B              19980102        201     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-11-2016 12:40 AM
Likes given to
View All
Quick links