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: 
SR2019
‎10-26-2021
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Retrieve First and Last Subject with no grouping variable

by Calcite | Level 5 in SAS Programming
‎10-26-2021 02:23 PM
‎10-26-2021 02:23 PM
No, prevsubj is entered in the way i have shown in the post. I created this test data for testing. first set has 3 records....Not sure i understand your question. Can you please clarify? ... View more

Re: Retrieve First and Last Subject with no grouping variable

by Calcite | Level 5 in SAS Programming
‎10-26-2021 02:20 PM
‎10-26-2021 02:20 PM
1. Logic is to get the newsubj (last screened subject). In the example data given: first set, 1001->1002->1003. And so newsubj should be 1003. second set, 1011->1012. And so newsubj should be 1012. third set, 2010->2011->2012->2013->2014. And so newsubj should be 2014.   2. I tried merging datasets by splitting subj and prevsubj but this only works for one level.          I am not trying to combine datasets, trying to see if there is a way to loop around each subject and see if we can get the expected solution. ... View more

Retrieve First and Last Subject with no grouping variable

by Calcite | Level 5 in SAS Programming
‎10-26-2021 01:21 PM
‎10-26-2021 01:21 PM
Hello All,   I have raw data as shown below. I do not know of how many times rescreening will be done. so, first set has 2 entries and second set has 1 entry and third set has 4 entries.   subj       prevsubj /*** First set - 2 times ****/ 1001 1002     1001 1003     1002 /***Second set - 1 time ****/ 1011 1012     1011 /***Third set - 4 times ****/ 2010 2011     2010 2012     2011 2013     2012 2014     2013   The final dataset should look like:   subj      prevsubj      newsubj 1001                        1003         1002    1001            1003 1003    1002            1003 1011                        1012 1012    1011            1012 2010                        2014 2011     2010           2014 2012     2011           2014 2013     2012           2014 2014     2013           2014   Can you please let me know of how can this be achieved?   Thank You.     ... View more

Re: Creating pdf with hyperlinks

by Calcite | Level 5 in ODS and Base Reporting
‎08-23-2019 06:26 PM
‎08-23-2019 06:26 PM
Thank You for the help Cynthia!   I opened a track with Tech Support Team. ... View more

Re: Creating pdf with hyperlinks

by Calcite | Level 5 in ODS and Base Reporting
‎08-23-2019 11:00 AM
‎08-23-2019 11:00 AM
Thank You Cynthia for the reply.   So, Here is the code I have:   !S={url='docnm.pdf#page=26, 42' foreground=blue linkcolor=_undef_} Assigned, Page 26, 42.   So, in the above regardless of the page number 26, 42. It takes to the last page of the document.pdf.   Can this be updated in a way that both pages can be hyperlinked to the correct page numbers.   Thank You, Sudha. ... View more

Creating pdf with hyperlinks

by Calcite | Level 5 in ODS and Base Reporting
‎08-23-2019 08:23 AM
‎08-23-2019 08:23 AM
Hello All,   I tried creating a pdf with hyperlinks but all hyperlinks in the same column only point to the first page of the document instead of the actual page. Can you please help me resolve this issue. Did anyone successfully create a pdf with multiple hyperlinks in the same column.   Thank You, Sudha. ... View more

Excel and SAS GRID

by Calcite | Level 5 in SAS Programming
‎03-26-2019 08:20 AM
‎03-26-2019 08:20 AM
Hello All,   Is there an easy solution to read in an existing excel and add few columns to that excel in SAS GRID?   Thank You, SR. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-26-2021 05:00 PM
Quick links