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: 
miguelito
‎01-21-2017
  • 9 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: DO loop in PROC SQL.

by Fluorite | Level 6 in SAS Programming
‎01-17-2017 12:18 PM
‎01-17-2017 12:18 PM
Hi, The first piece of code is pretty straight forward since it loops from 1949 to 1999, each year. However, i do not know how the second proposition relates to that. I am wondering how we use the idea of the first piece of code, but instead of printing separate tables for each year, generate only one table containing all the years in one column and the whatever we SELECT to do in a second column. Thanks! ... View more

Re: assigning ones and zeros up and/or down missing values

by Fluorite | Level 6 in SAS Programming
‎01-13-2017 06:20 PM
‎01-13-2017 06:20 PM
The range I am interested is Start-Finish. Equivalently, we could use Start_year and End_year, but as you see above there are missing values that fall into the range and others that do not. Again, the range is defined by Start and Finish. Thank you and I hope you can provide some guidance with the code. ... View more

Re: assigning ones and zeros up and/or down missing values

by Fluorite | Level 6 in SAS Programming
‎01-13-2017 06:06 PM
‎01-13-2017 06:06 PM
outside of range would be below the start and above the finish per id as the 0's and 1's illustrate above. So, 0 means outside and 1 means inside the range ... View more

Create a flag to determine if year is within desired time period

by Fluorite | Level 6 in SAS Programming
‎01-13-2017 05:51 PM
‎01-13-2017 05:51 PM
Hello Dear SAS users,   I have the following tricky problem and I would appreciate your great help:   I have data, where I know the start and the end (finish) year per id as you see below. I want to assign 0 to a record that is outside of the range and 1 otherwise:   id    start     finish         start_year         end_year        want 1     2010    2015         2008                 .                       0 1     2010    2015         2009                 .                       0 1     2010    2015         2010                2011                 1 1     2010    2015         2011                2012                 1 1     2010    2015         2012                2013                 1 1     2010    2015         2013                2014                 1 1     2010    2015         2014                2015                 1 1     2010    2015         2015                .                        1 1     2010    2015         2016                .                        0 2     2008    2016         2008                2009                 1 2     2008    2016         2009                 .                       1 2     2008    2016         2010                2010                 1 2     2008    2016         2011                2012                  1 2     2008    2016         2012                .                        1 2     2008    2016         2013                2013                 1 2     2008    2016         2014                2015                 1     2     2008    2016         2015                2016                 1 2     2008    2016         2016                .                        1 3     2013    2014         2008                .                        0 3     2013    2014         2009                 .                       0 3     2013    2014         2010                .                        0 3     2013    2014         2011                .                        0 3     2013    2014         2012                .                        0 3     2013    2014         2013                2014                 1 3     2013    2014         2014                .                        1     3     2013    2014         2015                .                        0 3     2013    2014         2016                .                        0               ... View more

Re: tracking years across two columns by id

by Fluorite | Level 6 in SAS Programming
‎01-13-2017 12:34 PM
‎01-13-2017 12:34 PM
This solution nicely identifies under column i the year(s) in which there is a gap, but it does not add the row in the data for the gap as I indicated in red color in my original rpost.   Thanks a lot! What I can do to add it the row(s) attached to the year gap(s)? Thanks again ... View more

Re: tracking years across two columns by id

by Fluorite | Level 6 in SAS Programming
‎01-13-2017 11:01 AM
‎01-13-2017 11:01 AM
Hi RW9, Thank you for your help! Your code kind of works but not precisely. If you see your want table your code assigns a value of 1990 to obs. 14 for id = 3 when actually there is no a gap issue for that row. So, it should be a period value. On the other hand, the original data for id=3 has a gap for years 1987,1988 and 1989. Hence, your code should add three new rows for these three years. However, it adds five rows. In fact, what I would expect based on my question below is that row 10 is 1987, row 11 is 1988, and row 12 is 1989, with the remaining two rows for what it was. Do you any any solutions for these two problems? Thank you ... View more

tracking years across two columns by id

by Fluorite | Level 6 in SAS Programming
‎01-13-2017 09:58 AM
‎01-13-2017 09:58 AM
  Hi Everyone,   As illustration purposes I have a dataset with the following two SAS year variables:   id     start_year     end_year               1      1991            1992           1      1992            1993           1      1993            1993      1      1993            1993 1      1993            1993      1      1994            1998 1      1998            2015 2      1993            1994      3      1985            1986       3      1990            1991 3      1992            2000   id=1 starts in 1991 and ends in 2015 with no gaps; same for id=2. But id=3 has a gap in 1987, 1988, and 1989   First, how can I track and know if there is a gap or no by id?   Second, how can I add the years gap by id to my data? For example,   id     start_year     end_year               1      1991            1992           1      1992            1993           1      1993            1993      1      1993            1993 1      1993            1993      1      1994            1998 1      1998            2015 2      1993            1994      3      1985            1986 3      1987            1987      3      1988            1988 3      1989            1989 3      1990            1991 3      1992            2000   Thank you very much ... View more

Difference in days between two dates in two different rows and differe...

by Fluorite | Level 6 in All Things Community
‎01-12-2017 12:10 PM
‎01-12-2017 12:10 PM
Hi, I am trying to compute the difference in days between two dates that are located in two different rows and in different columns by id. For example,   id     date1               date2               diff 1      03/01/1991     08/31/1992      09/01/1992 - 08/31/1992    (or 08/31/1992 - 09/01/1992) 1      09/01/1992     07/31/1992      08/01/1996 - 07/31/1992 1      08/01/1996     06/30/1997      07/01/1997 - 06/30/1997 1      07/01/1997     07/31/1997 2     09/01/1993     01/15/1994      3     01/01/1994     01/01/1995       01/01/1995 - 01/01/1995 3     01/01/1995     05/02/1999       I will appreciate your help. Thanks! ... View more

interpol

by Fluorite | Level 6 in Graphics Programming
‎01-06-2017 10:21 AM
‎01-06-2017 10:21 AM
Hello, I am producing gplots using the proc gplot procedure that is available in SAS/GRAPH and I am wondering where I can get the whole list of Interpol methods (e.g., join, steplj, etc.) and where I can get an accurate description of the method called 'steplj'? I looked at the documentation and I was not able to find it anywhere. Is there an new alternative for steplj in the new STAT/GRAHP? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-21-2017 11:56 AM
Likes given to
View All
Quick links