Got it to work. Just had to add a SET statement and it was fine. Thanks so much for your help! ... View more

  DATA WORK.Vitals_UtPre; SET HypTabs.Src_Utah_Vitals_2010 HypTabs.Src_Utah_Vitals_2011 HypTabs.Src_Utah_Vitals_2012 HypTabs.Src_Utah_Vitals_2013 HypTabs.Src_Utah_Vitals_2014; RUN; PROC SORT; BY SSN ApptDate; RUN; PROC TRANSPOSE DATA = WORK.Vitals_UtPre OUT= WORK.Vitals_UT; ID Measure; IDLABEL Measure; BY SSN ApptDate; VAR Value; RUN; DATA WORK.Vitals_UT (RENAME (ApptDate = VisitDt SSN = SSN1 Height__In_ = HtIn Weight__Lb_ = WtLb Systolic_BP = SBP Dystolic_BP = DBP)); RETAIN SSN VisitDt HtIn WtLb SBP DBP; SSN2 = INPUT(SSN1, 12.); SSN = PUT(SSN1, SSN11.); KEEP SSN VisitDt HtIn WtLb SBP DBP; LABEL SSN = "Social Security Number" VisitDt = "Visit Date" HtIn = "Height (In)" WtLb = "Weight (Lb)" SBP = "Systolic BP (mmHg)" DBP = "Diastolic BP (mmHg)"; KEEP SSN VisitDt HtIn WtLb SBP DBP; PROC SORT; BY SSN VisitDt; RUN; This is my whole code right now. I am just not able to get the rename statement to work. The ID statement works, but ultimately does not make the variable names I want, so I still included the rename statement.   ... View more

I was eventually able to get the right format with this code:   data work.Vitals_UtPre; set HypTabs.Src_Utah_Vitals_2010 HypTabs.Src_Utah_Vitals_2011 HypTabs.Src_Utah_Vitals_2012 HypTabs.Src_Utah_Vitals_2013 HypTabs.Src_Utah_Vitals_2014; run;   proc sort; by SSN ApptDate; run;   proc transpose data = WORK.Vitals_UtPre out= WORK.Vitals_Ut; by SSN ApptDate; var Value; run;   My only question now is where would I put my rename statement to get these renames done. I have tried some options and it didn't work.   (RENAME (ApptDate = VisitDt SSN = SSN1 COL1 = HtIn COL2 = WtLb COL3 = SBP COL4 = DBP));     ... View more

Ok, that makes sense, but I still can't get it to work. Just to give you a better idea, here are all the columns of my data. Even though the SSNs are fake, I just grayed them out so no one gets worried.       I guess I am confused by the fact that we are using "by year".   Here is the code I tried, but maybe this is not what you were thinking.   data WORK.Vitals_Utah; set HypTabs.Src_Utah_Vitals_2010 HypTabs.Src_Utah_Vitals_2011 HypTabs.Src_Utah_Vitals_2012 HypTabs.Src_Utah_Vitals_2013 HypTabs.Src_Utah_Vitals_2014: indsname=tmp; year=scan(tmp,4,"_"); run;   proc transpose data=WORK.Vitals_Utah out=WORK.Vitals_Ut; by year; var value; idlabel measure; run; ... View more

  This it the format I ultimately want to end up with. We have learned arrays, so that could be an option. I just remember hearing something about using MERGE, so I think that's why I thought of that. ... View more

Is it possible to do it with a MERGE statement? We just haven't learned about PROC TRANSPOSE in class yet, so I think we are expected to use MERGE, but I'm not super good at it yet. ... View more

Yes, that makes sense. Silly mistake. Thank you!! ... View more

The CONTENTS Procedure HYPTABS.SRC_IOWARESIDENTS 196 DATA 9 V9 0 11:17:29 15.09.2017 80 11:17:29 15.09.2017 0   NO   NO     WINDOWS_64   wlatin1 Western (Windows)    Engine/Host Dependent InformationData Set Page SizeNumber of Data Set PagesFirst Data PageMax Obs per PageObs in First Data PageNumber of Data Set RepairsExtendObsCounterFilenameRelease CreatedHost CreatedInode NumberAccess PermissionOwner NameFile SizeFile Size (bytes) 65536 1 1 817 196 0 YES /folders/myfolders/BIOS6680/Hypertension Study/1 - Data/2 - Tabulations/src_iowaresidents.sas7bdat 9.0401M2 X64_8PRO 77 rwxrwx--- root 128KB 131072  Alphabetic List of Variables and Attributes# Variable Type Len937281645 BirthDt Num 8 City Char 20 Ethnicity Char 12 Initials Char 4 Race Char 5 SSN Char 11 Sex Char 6 State Char 4 ZipCd Num 8 The CONTENTS Procedure  Data Set NameObservationsMember TypeVariablesEngineIndexesCreatedObservation LengthLast ModifiedDeleted ObservationsProtectionCompressedData Set TypeSortedLabel Data Representation Encoding  HYPTABS.SRC_MS_CITIZENS 207 DATA 10 V9 0 12:46:45 15.09.2017 110 12:46:45 15.09.2017 0   NO   NO     WINDOWS_64   wlatin1 Western (Windows)    Engine/Host Dependent InformationData Set Page SizeNumber of Data Set PagesFirst Data PageMax Obs per PageObs in First Data PageNumber of Data Set RepairsExtendObsCounterFilenameRelease CreatedHost CreatedInode NumberAccess PermissionOwner NameFile SizeFile Size (bytes) 65536 1 1 594 207 0 YES /folders/myfolders/BIOS6680/Hypertension Study/1 - Data/2 - Tabulations/src_ms_citizens.sas7bdat 9.0401M2 X64_8PRO 82 rwxrwx--- root 128KB 131072  Alphabetic List of Variables and Attributes# Variable Type Len51082743916 CityState Char 35 DOB Char 9 Eth Char 22 FirstInit Char 2 Gender Char 6 LastInit Char 2 MiddleInit Char 2 Racial Char 16 SocSecNum Char 11 ZipCd Char 5 The CONTENTS Procedure  Data Set NameObservationsMember TypeVariablesEngineIndexesCreatedObservation LengthLast ModifiedDeleted ObservationsProtectionCompressedData Set TypeSortedLabel Data Representation Encoding  HYPTABS.SRC_UT_RECORDS 195 DATA 10 V9 0 09:08:11 15.09.2017 72 09:08:11 15.09.2017 0   NO   NO     WINDOWS_64   wlatin1 Western (Windows)    Engine/Host Dependent InformationData Set Page SizeNumber of Data Set PagesFirst Data PageMax Obs per PageObs in First Data PageNumber of Data Set RepairsExtendObsCounterFilenameRelease CreatedHost CreatedInode NumberAccess PermissionOwner NameFile SizeFile Size (bytes) 65536 1 1 908 195 0 YES /folders/myfolders/BIOS6680/Hypertension Study/1 - Data/2 - Tabulations/src_ut_records.sas7bdat 9.0401M2 X64_8PRO 83 rwxrwx--- root 128KB 131072  Alphabetic List of Variables and Attributes# Variable Type Len10983651274 BirthDay Num 8 BirthMonth Num 8 BirthYear Num 8 CitySt Char 24 EthnicityCode Char 1 GenderCode Char 1 ID Num 8 Inits Char 6 RaceCode Char 1 ZipCode Char 5   So I can tell from the PROC CONTENTS that ZipCd is a numerical variable in the Src_iowaresidents data set. In my output it is however a character variable as I define that in my code. Is there someway I can fix this so that it becomes a character variable so that I can combine the datasets?       ... View more

Thanks for your reply. I have checked and it is a character variable in all three data sets. I have even put in a statement to ensure this. This is the full message I get if that gives any more clues to the problem:   NOTE: Data file HYPTABS.SRC_IOWARESIDENTS.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. NOTE: Data file HYPTABS.SRC_MS_CITIZENS.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. ERROR: Variable ZipCd has been defined as both character and numeric. NOTE: Data file HYPTABS.SRC_UT_RECORDS.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. ... View more

I totally understand your concern. This is however 100% fictional data that was made up for academic use. I’ll make sure to edit it though so no one else gets worried. ... View more

Sorry about that. Just realized part of the code got cut off. It is now marked in red. As for what goes wrong the data set WORK.Contacts does not even show up in the output. The only error message I get is    ERROR: Variable ZipCd has been defined as both character and numeric.   This does not really make sense to me because when I look at the data sets ZipCd is always a character variable. ... View more

Got it to work. Stupid spelling error.. ... View more

Ok, that makes sense. However I tried doing it like this and it still did not work.   proc format library = HypTabs.HypFormats; value CODCd . = 'Unknown' 1 = 'Heart Disease' 2 = 'Heart Failure' 3 = 'Stroke' 4 = 'Other COD' OTHER = 'Unanticipated Value'; value HypRelDeathInd . = 'Unknown' 0 = 'No' 1 = 'Yes' OTHER = 'Unexpected Value'; run;   data HypTabs.NDI (LABEL = "Death Data"); retain SSN DeathDt ICD10 COCd HypRelDeathInd; set HypTabs.NDI ( RENAME = ( DeathDt = DeathDt_Char ) );   Rest of code.... ... View more