Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SAS (Statistical Analysis System) HWQueation - Please modify the code below so it would run successfully. Highlight any portions that you change. PROC SORT DATA=DATABASE_S;

SAS (Statistical Analysis System) HWQueation

- Please modify the code below so it would run successfully. Highlight any portions that you change. PROC SORT DATA=DATABASE_S; BY RECORD_ID REDCAP_REPEAT_INSTANCE; RUN; DATA DAILYMON; SET DATABASE_S; BY RECORD_ID; SUMSYMP=SUM(SYMPTOMS___1-SYMPTOMS___9, SYMPTOMS___11, SYMPTOMS___16); DO i=1 to 4; IF symptom[i]=1 THEN symptoms=1; IF LAST.RECORD_ID AND SYMPTOMATIC_IND=1 THEN LATEST_SYMP=1; ELSE LATEST_SYMP=0; RUN; PROC SQL; CREATE TABLE DAILYMONFIELDS AS RECORD_ID, MAX(SYMPTOMATIC_IND) AS SYMP_IND, MAX(DATE) AS LATEST_CHECKIN FORMAT MMDDYY10, FROM DAILYMON GROUP BY RECORD_ID; QUIT; PROC SQL; CREATE TABLE RECORD_DATES2 AS SELECT * FROM RECORD_DATES1 R LEFT JOIN DAILYMONFIELDS D ON R.RECORD_ID; QUIT;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases DeMYSTiFieD

Authors: Andy Oppel

2nd Edition

0071747990, 978-0071747998

More Books

Students also viewed these Databases questions