Hello everyone,   I am trying to create a new, temporary SAS dataset (MultSBP) where the systolic blood pressures for each patient are contained in a single observation, with the variable names SBP1–SBP5. SBP1 is the systolic blood pressure at Time=1, SBP2 is the systolic blood pressure at Time=2, etc. I am trying to do this using a DATA step and all observations should contain 5 observations in the final dataset. However, I do not seem to be getting the logic right. It shows 18 values instead of 5 and it seems to be repeating the patient ids. I just want to output 5 patients with SBP values for each time. Please, could someone take a look at my code and output? I have included a dataset for which to get the values. data SBPvalues ; *initial dataset; input PTID Time SystolicBP ; datalines; 7 3 138 7 1 144 7 4 126 3 3 132 3 1 142 3 4 116 3 2 118 4 1 156 4 2 148 4 3 133 4 4 129 4 5 120 1 2 122 2 2 104 2 3 108 2 1 112 1 3 . 1 5 130 ; data MultSBP; *new dataset should have 5 observations set SBPvalues; array SBParray{5} SBP1 SBP2 SBP3 SBP4 SPB5; do i = 1 to 5; if time = i then SBParray{i}=SystolicBP; end; drop i; run; ... View more

Hi guys,   I am new to SAS and I am a bit confused on how to use the class statement for two datasets. I thought I would not need to merge them with a class but I am not sure. Please see the code I have written below which is missing the second dataset because I am not sure where it fits in: /* My question Using the SAS datasets demogdemo and visitdemo and PROC MEANS with the CLASS statement, compute the mean, median, 25th percentile, 75th percentile, and the number of non-missing values for the variables CD4, Weight, and Age for each value of civil status including missing. Report the statistics to three decimal places. In the same PROC MEANS, create a summary dataset with the OUTPUT statement containing the median and mean of CD4, Weight, and Age. Using _TYPE_, print only the overall (i.e. all civil status categories combined) mean and median from this summary dataset. */ /*My starter solution*/ title "Using a CLASS Statement with PROC MEANS"; proc means data=lb.visitdemo n mean median Q1 Q3 maxdec=3; *where do I put demogdemo? Do I need to merge it in with visit demo in a different datastep first?; class civilstatus; var CD4 Weight Age ; output out = newdataset; median = md_CD4 md_Weight md_Age; mean = m_CD4 m_Weight m_Age; run; proc ... View more

Hi everyone,   I am trying to solve the following question but I am lost as to how to do this. There are two datasets involved but they can be linked by patient id which is present in both datasets. However I am trying to calculate statistics of three variables as described in my code below: Any thoughts or queries. Sorry, I can't post the dataset but I'd appreciate some help. /*8 Using the SAS datasets demogdemo and visitdemo and PROC MEANS with the CLASS statement, compute the mean, median, 25th percentile, 75th percentile, and the number of non-missing values for the variables CD4, Weight, and Age for each value of civil status including missing. Report the statistics to three decimal places. In the same PROC MEANS, create a summary dataset with the OUTPUT statement containing the median and mean of CD4, Weight, and Age. Using _TYPE_, print only the overall (i.e. all civil status categories combined) mean and median from this summary dataset. */ title "Using a CLASS Statement with PROC MEANS"; proc means data=lb.visitdemo n mean median Q1 Q3 maxdec=3; *what about demogdemo?; class civilstatus; var CD4 Weight Age ; run; T  ... View more

Hi all,   I am quite confused about how to use the lengthn, cat, catx and substr functions all together for string manipulation. I am trying to add a variable that inserts a dash between the 2nd to last character and the last character of Item and wraps the value in parentheses. For example, Item 144L becomes (144-L). Use the LENGTHN, SUBSTR, CAT and CATX functions. The solution should be generalizable to any value of Item containing 2 or more characters. So far, I have been building the program using examples I have seen but I keep getting confused. Please can you help me fix my program and include explanations if u can. I just need to understand how all the functions work together to solve this problem. Thanks. data CustomerDB ; input Customer & $18. Item : $11. ; datalines; Bartco Corporation 143L Cost Cutter's 142 Minimart Inc. 188SW Bosco, LLC 908X321 K-MART. A122L Food Unlimited 1898XVWX Shop and Drop 24L Shop Marty's 222X Pet's are Us W100 Roger's Spirits 1522L Artful Spirits 407XxxXxx Up/Down mart Inc. ABCdefghxxx ; data newTemp; set CustomerDB; if lengthn(Item) ge 3 then secondtoLastRemoved = catx("-",(substr(Item,1,(lengthn(Item)-2))),(substr(Item,lengthn(Item), 1)) ); /*Dropping Second to last characters from string?*/ else secondtoLastRemoved = Item; if findc(Item,'mart','i') gt 0 then bool = 1; /*setting boolean for words that have the string "mart" in them */ else bool = 0; lowcaseCustomer = lowcase(compress(Customer,,'p')); /* Remove Punctuation and make letters lowercase */ run; proc print data = newTemp; title "CustomerDB string Manipulations"; run; ... View more

Hi Everyone,   I am totally new to sas and I am trying to find a way to specify a particular month when creating my date variable. I have included the problem question in the comment of my code. /*Question 4: Using the Hosp SAS dataset, create a new temporary SAS dataset which contains only patients born after August 05, 1950. Extract the day from the birth date (DOB) and the year from the admission date (AdmitDate). Create a new date variable named DateNew using these 2 variables and the month of May.Calculate each patient's age as of January 27, 2018. And using a date interval function with the ‘sameday’ option, identify a scheduled return visit date that is 5 months after the discharge date. Format all dates as YYYY-MM-DD and print observations for patients who have IDs between 15 and 45 inclusive.*/; libname cb "I:\My Documents\552\codybook"; data thosp; set cb.hosp (where = (DOB gt '05Aug1950'd)); /*Extracting day and year from DOB and AdmitDate Respectively*/ dy = day(DOB); yr = year(AdmitDate); mnth = mnth(‘May’); DateNew = mdy(mnth,dy,yr); Age = yrdif(DOB,'27Jan2018'd); ReturnVisitDate =intnx('month', DischrDate, 5, 'sameday'); format DOB yymmdd10. ReturnVisit yymmdd10. AdmitDate yymmdd10. DateNew yymmdd10. DischrDate yymmdd10.; run; proc contents data = thosp; run; proc print data = thosp (obs=2); run; proc print data = thosp; where ID in (15:45); run; Please see the attached screenshot error I keep getting and my code below:     ... View more