Hello! For an assignment, we merged two data sets "bp" (which include subject, date of visit, SBP and DBP; there were multiple observations per subject) and "demog" (which include variables like date of birth, date of entering the study, marital status, education, smoking, and drinking). I need to make sure that the subjects are all under the age of 55 and the blood pressure readings considered are only from the first visit date. So far in my code I did:   LIBNAME BIST0535 "C:\Users\Paula\Desktop\BIST0535";   *Narrowing down blood pressure data to first visit only* DATA BIST0535.bp_hw3_1;                 SET BIST0535.bp_hw3; RUN;   PROC SORT Data=BIST0535.bp_hw3_1;                 BY subject; RUN;   DATA BIST0535.bp_hw3_2;                 SET BIST0535.bp_hw3_1;                 BY subject;                 IF FIRST.subject; RUN;   *Merging of Datasets and narrowing subject list to people younger than 55* DATA BIST0535.HW3;                 SET BIST0535.demog_hw3 BIST0535.bp_hw3_2;                 age = (doe-dob)/365.25;                 IF age GT 55 THEN DELETE; RUN;   *Looking at relationship between marital status and smoking/drinking* PROC SORT DATA= BIST0535.HW3;                 BY marital; RUN;   PROC FREQ DATA= BIST0535.HW3;                 TABLES smoke drink smoke*drink;                 BY marital;                 TITLE "HW3 Frequencies of smoke, drink, and smoke*drink by marital status"; RUN;   Now I want to look at the relationship between educational attainment (education) and blood pressure readings (SBP and DBP), by looking at the break down of frequencies, as I did above with marital and smoking/drinking. However it is not working and I believe it is because the way the data was merged. Even if the subject is the same, the variables from the two different original data sets are appearing on separate observations. Here is a section of the proc print (I italicized subject 1, as it exemplifies this issue):   Obs subject site gender dob doe smoke drink marital education dov dbp sbp age 1 .   . . . . . . 14145 107 134 . 1 5 F -1092 14069 0 2 3 3 . . . 41.5086 2 .   . . . . . . 14447 115 143 . 3 .   . . . . . . 14082 103 148 . 4 .   . . . . . . 14632 87 110 . 4 1 F 892 14632 0 5 2 3 . . . 37.6181 5 .   . . . . . . 14650 66 108 . 5 2 F 259 14558 0 2 1 2 . . . 39.1485 6 .   . . . . . . 14520 75 133 . 6 4 F 1809 14429 1 2 3 3 . . . 34.5517 7 .   . . . . . . 14813 87 131 . 7 3 M -3979 14637 0 2 3 2 . . . 50.9678 8 .   . . . . . . 14285 112 149 . 8 5 M -3669 14285 0 4 2 3 . . . 49.1554 9 .   . . . . . . 14865 84 123 . 9 3 F 2438 14618 0 3 3 3 . . . 33.3470 10 .   . . . . . . 13967 88 120   HOW DO I FIX THIS PLEASE? ... View more

this is from BIST0535.hw3_1 As you can see I have sorted data by subject and then dov, such that the observations for a single subject are all clumped together and the observation from the first time they visited (date of visit, dov) is first. I need to create a new data set BIST0535.hw3_2 which contains only one observation from each subject with the first time they visited. I think we are meant to use an IF THEN statement, however if there is a easier way I am open to it. Obs subject dov dbp sbp 1 07/09/1998 108 157 1 09/23/1998 107 134 2 10/15/1998 114 149 2 01/14/1999 112 165 2 04/15/1999 105 158 2 07/22/1999 115 143 3 07/22/1998 103 148 3 10/07/1998 107 165 3 01/14/1999 102 159 4 01/23/2000 87 110 4 04/26/2000 85 128 5 11/10/1999 65 137 5 02/10/2000 66 108 ... View more

Hi!  I'm working with a data set and I'm trying to see if any of the pregnancy responses are invalid based on gender (i.e. male participants should not be recorded as having ever been pregnant).  The values are as follows:   GENDER M=Male  F= Female   PREGNANCY 0=never been pregnant 1=has been or is pregnant 9=not available   How do I write an IF THEN statement where if the participant is a man and has been pregnant than his category is 0 but any other combination of the two variables is category 1? ... View more

Hello! I'm trying to create a text file with this data set, that I have sorted by subject and then in descending order by glucose level. I will attach the data set now... subject  female   glucose Visit_Date Age 1 0 142 14860 59.9754 1 0 139 14579 59.2060 1 0 136 14662 59.4333 1 0 134 14765 59.7153 4 1 101 14478 38.3025 4 1 100 14392 38.0671 8 1 124 14129 48.4271 8 1 115 14222 48.6817 11 1 94 14006 31.5127 11 1 89 14082 31.7207 14 1 135 14351 60.6899 14 1 128 14632 61.4593 14 1 127 14536 61.1964 14 1 126 14438 60.9281 15 1 99 14283 44.3997 15 1 95 14183 44.1259 15 1 91 14387 44.6845 16 1 70 13971 28.2409 20 0 161 14265 62.3107 20 0 150 14350 62.5435   My code so far is this...   LIBNAME BIST0535 "C:\Users\Paula\Desktop\BIST0535";   DATA BIST0535.hw2;      SET BIST0535.hw2_data(RENAME= (dov=Visit_Date));      Age= (Visit_Date-dob)/365.25;      IF state NE 4 then delete; RUN;   PROC SORT;      BY subject DESCENDING glucose; RUN;   PROC PRINT;      VAR subject female glucose visit_date age; RUN;       Now I'm trying to output this data set into a text file, but I only want one observation to appear per subject and I want only the maximum glucose level (the first observation per subject) to appear. Essentially, the assignment is to only show the observation with the maximum glucose level per subject. How do I get it to look more like this....   OBS SUBJECT FEMALE  MAX_GLUCOSE VISIT_DATE             AGE  1      1               0                142                       7 September 2000     59.98  2      4               1                101                       22 August 1999         38.30  3      8               1                124                       7 September 1998     48.43 etc...         ... View more

Hello! I'm trying to find max glucose level per subject, but the subjects have multiple variables.   For example: DATA homework2; INPUT subject $ visit_date glucose; DATALINES; 1 06/14/16 113 2 05/21/16 107 3 08/17/17  98 1 12/01/17 110 2 03/21/17 118 3 04/04/17 106 1 01/23/18 117 ; RUN;   How do I get the system to realize that the different subjects occur at different frequencies and across separate observations but I want the maximum glucose value IN A NEW VARIABLE (max_glucose) per subject?     ... View more