I have two formats that I want to use for the variables "COCd" and "HypRelDeathInd". The formats do not seem to be working. Does it have something to do with the order of the code or is there another problem? No error messages come up.   data HypTabs.NDI (label = "Death Data"); retain SSN DeathDt ICD10 COCd HypRelDeathInd; set HypTabs.NDI ( rename = ( DeathDt = DeathDt_Char ) ); DeathDt = input(DeathDt_Char, YYMMDDD10.); format DeathDt YYMMDDD10.; drop DeathDt_Char; COCd1= substr(ICD10, 1, 3); if COCd1 = "I25" then COCd = 1; else if COCd1 = "I50" then COCd = 2; else if COCd1 = "I63" then COCd = 3; else COCd = 4; if COCd= 1 then HypRelDeathInd = 1; else if COCd= 2 then HypRelDeathInd = 1; else if COCd= 3 then HypRelDeathInd = 1; else if COCd= 4 then HypRelDeathInd = 0; label SSN = "Social Security Number" DeathDt = "Death Date" CODCd = "Cause of Death Code" HypRelDeathInd = "Hypertension-Related Death"; drop COCd1; run;   procformat 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; proc sort; by SSN; run; ... View more

I am wondering if there is way to make a label for entire data set. I have an assignment where I am supposed to have a label of "Study States" to my data set HypTabs.States. I know how to make variable labels, but is there a way to make a label for the actual data set?  ... View more

I am trying to combine the two datasets below. I am also adding formats so that they can be combined. I want the final dataset (WORK.AllSites) to look like this:     Institution SubjID Name SexCd 1 City Medics 102 Wilson, Steven M 2 City Medics 105 Moore, Chris M 3 City Medics 109 Jackson, Sharon F 4 St John’s 203 Taylor, Daniel M 5 St John’s 206 Davis, Helen F 6 St John’s 208 Smith, Betty F   When I combine them together the code does not work and I only get the CM data imported. What can I do to fix this?   data WORK.CM; infile datalines delimiter = ':'; input Institution :$11. SubjID :3. Name :$15. Gender :$6.; datalines; City Medics:102:Wilson, Steven:Male City Medics:105:Moore, Christ:male City Medics:109:Jackson, Sharon:Female ; data WORK.StJohns; infile datalines delimited = ','; input Site :$9. PatientID :3. FirstNm :$6. LastNm :$6. Sex :$1.; datalines; St John's,203,Daniel, Taylor,M St John's,206,Helen, Davis,F St John's,208,Betty, Smith,f ;   data WORK.AllSites; set WORK.StJohns; SexCd1=propcase(Sex); rename Site = Institution PatientID = SubjID SexCd1 = SexCd; Name = catx(',', LastNm, FirstNm); run;   data WORK.AllSites; set WORK.CM; SexCd = propcase(substr(Gender, 1, 1)); run; data WORK.AllSites; set WORK.StJohns WORK.CM; keep Institution SubjID Name SexCd; run;   proc sort data = WORK.AllSites; by Institution SubjID; run; ... View more

I am trying to make a DO Loop that does two things: 1) Create a variable called Mouse ID that repeats the values 1-15, which each value being repeated 8 times. 2) Create a variable called Day, so basically DO Day = 0 TO 28 BY 4. The issue is also getting this repeated for all the 15 mice.   The output should start like this, and at the end produce output with 120 variables.   Mouse ID       Day 1                     0 1                     4 1                     8 1                     12 1                     16 1                     20 1                     24 1                     28 2                     0 2                     4 ..... How do I make this DO Loop for this?   This is what I started with, but need ideas for how to get everything repeated an appropriate number of times data WORK.Illus; do MouseID = 1 to 15; do Day = 0 to 28 by 4; output; end; end; run;   ... View more

I am supposed to create a variable called SSN2. I currently have a variable called SSN that has the social security numbers in a format XXXXXXXXX, and want SSN2 to be in the format XXX-XX-XXXX, in other words adding hyphens in specific positions. I have tried using the CATX function, but I don't know if this is even the right function as I am just splitting the one variable up. Should I instead be using the SUBSTR function? ... View more

  I am trying to create a function that creates a numeric variable called BirthDt that basically combines the BirthYear, BirthMonth and BirthDay into one numerical variable, ie so the BirthDt for the first observation would be 199. I am struggling with which function to actually use for this. Any advice? ... View more

Using this code, I have understood that automatic variables FIRST.SubjID and LAST.SubjID are supposed to appear in the PDV. I am supposed to fill out the variables for FIRST.SubjID and LAST.SubjID, but am confused as to how to actually display these variables.   data    WORK.AEs;     infile  datalines;     input   SubjID             AEDesc  $;     datalines; 109 Nausea 109 Dyspnea 109 Headache 122 Dyspnea 146 Rash 146 Flushing ;  data    WORK.Analysis;     set WORK.AEs;     by  SubjID;     run; ... View more