Hi all,   I have downloaded a SAS dataset but as soon as I open it, I get this error: NOTE: Data file TMP1.CORE.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance.   If I try to do any further analyses, I get this error:  ERROR: Some character data was lost during transcoding in the dataset TMP1.CORE. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.   Please let me know how do I fix this.    Thanks!! ... View more

Hi everyone!!   I needed some help to find multiple variables "YEAR10_1,YEAR10_2.. so on" containing a diagnostic code string to make a new variable "Year_Diagnosis". The data looks as follows: ID YEAR10_1 YEAR10_2  YEAR10_3 YEAR11_1 YEAR11_2 YEAR12_1 YEAR12_2 YEAR12_3 YEAR_DIAGNOSIS 1       C34.0 C50.2 C34.0 C34.2   2011 2 C34.0 C50.2 C34.0 C34.2         2010 3           C34.0 C50.2 C34.0 2012 4 C34.0               2010 5 C50.2 C34.0   C34.0         2011 6       C34.0         2011   I am interested in the string starting with "C34" and the first one that appears in the column. For example, in ID=1, "C34" appears in YEAR11_1 and YEAR12_1 but I want the output diagnosis year as 2011.    I am sure there are many ways to do this but I was hoping if someone could help me find a more efficient way since I have do this many times with my data and on thousands of patients.   Thanks!!!! ... View more

Hello all,   I have dataset for a patient population with a start and an end date. I have also have the date for their visits to the hospital. I want to create a new variable which counts their visits to the hospital including the months with zero visits.    The dataset looks like this: ID Startdate Enddate Visitdate 1 15JAN2016 09AUG2016 10MAR2016 1 15JAN2016 09AUG2016 13MAR2016 1 15JAN2016 09AUG2016 09JUN2016 2 08MAR2016 12JUL2016 15MAR2016 2 08MAR2016 12JUL2016 25MAR2016 2 08MAR2016 12JUL2016 6JUNE2016 2 08MAR2016 12JUL2016 3JUL2016     What I want is: ID Startdate Enddate Visitdate Newdate Count 1 15JAN2016 09AUG2016 10MAR2016 JAN2016 0 1 15JAN2016 09AUG2016 13MAR2016 FEB2016 0 1 15JAN2016 09AUG2016 09JUN2016 MAR2016 2 1 15JAN2016 09AUG2016   APR2016 0 1 15JAN2016 09AUG2016   MAY2016 0 1 15JAN2016 09AUG2016   JUN2016 1 1 15JAN2016 09AUG2016   JUL2016 0 1 15JAN2016 09AUG2016   AUG2016 0 2 08MAR2016 12JUL2016 15MAR2016 MAR2016 2 2 08MAR2016 12JUL2016 25MAR2016 APR2016 0 2 08MAR2016 12JUL2016 6JUNE2016 MAY2016 0 2 08MAR2016 12JUL2016 3JUL2016 JUN2016 1 2 08MAR2016 12JUL2016   JUL2016 1   I am looking to create these two variables in the dataset so I can get the counts for the visits by each month between the first and last date. Please help me find a solution for this.    Thanks! ... View more