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

Re: Date variable as a character

by Calcite | Level 5 in SAS Programming
‎05-05-2016 12:39 PM
‎05-05-2016 12:39 PM
This worked! Thanks! ... View more

Re: Date variable as a character

by Calcite | Level 5 in SAS Programming
‎05-04-2016 06:29 PM
‎05-04-2016 06:29 PM
I have a lot of missing data (only about 1/3 came for a revisit). How should I address that? I found the following code that worked for changing the first visit date (everyone has a value for this variable)     dopv=input(substr(strip(firstposvisit),1,10),MMDDYY10.);   but it doesnt work for the revisit date. I get the error: NOTE: Invalid numeric data, dateofrevisit='                                           08/23/2015' , at line 1205 column 4. ... View more

Date variable as a character

by Calcite | Level 5 in SAS Programming
‎05-04-2016 06:14 PM
‎05-04-2016 06:14 PM
I have a variable called dateofretest and the actual cells look like this:   01/26/2015 07/08/2014 05/06/2015   but the variable itself has $34. format, when i need it to be in mmddyy8. I have tried using input, subsrtn, and other formatting things but the result is always a bunch of missing cells. How do i get this in date-format??   Thanks! ... View more

Re: Transposing with many columns

by Calcite | Level 5 in SAS Procedures
‎05-03-2016 06:14 PM
‎05-03-2016 06:14 PM
Ahhhh thank you so much!!! This was exaclty what I needed and not complicated at all. ... View more

Re: Transposing with many columns

by Calcite | Level 5 in SAS Procedures
‎05-03-2016 05:31 PM
‎05-03-2016 05:31 PM
Each encouter was a patient coming in for a test. I am looking at retesting and repositivity rates.   For restesting, I want to assess associations with risk of not coming back to get retested after  a positive test results (patients should come back within 3-6 months). I wanted to transpose the data because I planed on having these variables 1) Postive test date 2)Re-tested within a year? (yes or no) 3) if yes revisit date 4) if yes, time between positive test and revisit. In addition to these, I want the behavior and demographic questions from the first visit because I will be building a  Cox proportional hazard regression model with these variables.   Next I will be building a logisitc regression model focused on only those who came back for a visit within a year after their positive test result. I will be using demographic/behavior variables from both first postive visit and the revisit to investigate associations with repositivity (so whether or not when the person returns for their second test, if that test is also positive). This means I really just need retest results for this one, but only from those whose last test was a positive.   If there is a way to get to these analyses with long data, then suggestions on how to do so are very welcome!!     ... View more

Transposing with many columns

by Calcite | Level 5 in SAS Procedures
‎05-03-2016 04:30 PM
‎05-03-2016 04:30 PM
This question might be fairly straight forward but I am new to SAS so I do not know how to execute this.   I have a dataset based on encounter level data for clinic visits. At each encounter, a person had various information collected. There are people with multiple encounters in the dataset and I would like to transpose the long encouter-based data to wide individual-based data (each individual has an spefific ID). However, I have about 50 variables per encounter (again, a lot of information was collected). From my research, proc transpose seems to only handle one variable at a time? Also, I would like a way to label the transposed information by visit number, based off visit date. Thus I would want to see question1_visit1 rather than question1_11-24-2010 and also have a way to see the date of the visit (i.e. have a date_visit1 column with the date). I imagine I will have to do this all in several steps, since the visit number wont be known until the data is transposed. If anyone can atleast point me in the right direction I would be thankful. ... View more

Complicated merging question

by Calcite | Level 5 in SAS Programming
‎04-20-2016 05:54 PM
‎04-20-2016 05:54 PM
I have a complicated merging question that may not even be possible in SAS. I have two datasets on testing results for a certain condition. One has names of patient, dob, date of visit, site number, and client ID. The other one has dob, date of visit, site number, and client id in addition to risk behavior questions,demographic information, and test results.   I want to merge these two datasets to get one observation per each visit for each client, and also have a way to display this information in wide format when I need to do longitudinal analysis . The only thing is, there is a chance that the client ID has been used on multiple people (not that often, but a few instances of it) This is usually because different testing sites might both assign the same number for the respecitve patients. This means I need to merge not only on client ID, but DOB (assuming the chance that two people who have the same ID had the same DOB is close to 0), site number, and date of visit as well.   Any ideas on how to execute this? ... View more

Re: New to loops, need help

by Calcite | Level 5 in SAS Programming
‎04-19-2016 03:05 PM
‎04-19-2016 03:05 PM
Sorry for that last question. First time on here and I didn't realize that I couldn't see all the code, until I clicked print and all of it showed up. Thanks!!!! ... View more

Re: New to loops, need help

by Calcite | Level 5 in SAS Programming
‎04-19-2016 12:55 PM
‎04-19-2016 12:55 PM
Thanks! Yes, pftsdate has the date while the other two are the actual measurements?  How do I incorporate enrolldate into this? By that I mean how do I ensure that the pftsdate I am geting the most recent prior to enroll date? The only way I can think of is taking the difference from the dates (enrolldate-pftsdate{_n_ ) and writing a command that finds the smallest negative number? ... View more

New to loops, need help

by Calcite | Level 5 in SAS Programming
‎04-19-2016 12:27 PM
‎04-19-2016 12:27 PM
Hello,   I have a data set with several pulmonary function test dates for each patient (i.e. pftsdate1 pftsdate2...pftsdate20) where patients had gotten FEV and FVC taken at each date (recorded as fevdate1 fvcdate1...fevdate20 fvcdate20). These measurements were pulled from patients charts and so could have taken place many years before the patients were enrolled in the study that the data was collected for. I also have a variable of when a patient was enrolled in the study (enrolldate). I am currently creating a table that averages the FEV measurements for the pulmonary function test measurements taken closest to enrollment, but not after enrollment. This means, for all patients, I have to find the pftsdate that corresponds to the most recent one prior to that patient's enroll date, then create new variables called "tablefev" and "tablefvc" that pulls the fevdate information from that pftsdate.   I am in the middle of creating a long code that hopefully gives me this, but I feel like there has to be a 10 times easier loop way of getting a column of these numbers.   Any help? Thanks. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-11-2016 06:25 PM
Quick links