**EDITED FOR CLARITY** Hi SAS Experts, I would like to analyze lab data from a small number of samples. My data looks like this: SUBID LBTESTCD LBTESTCD_DEC LBORRES LBORRESU_DEC LBORNRLO LBORNRHI 0001 4 C4 6 mg/dL 14 44 0006 1 C1-INH antigenic levels 10 mg/dL 19 37 0004 1 C1-INH antigenic levels 4 mg/dL 21 39 0008 4 C4 <2 g/L 10 40 0002 2 C1-INH functional levels .08 % of normal 67 100 0002 3 C1q 28 mg/dL 12 22 ... ... ... ... ... ... ... I would like that data to look like this: Test Results --> --> --> --> --> Test Name Number of Tests Mean (SD) Median Min Max Kurt Skew C1-INH antigenic levels (units) N= C1-INH functional levels (units) N= C4 (units) N= C1q (units) N= Each row in the dataset represents a lab test and as such subjects can have multiple rows. This does not matter to me because I am looking for basic descriptive on the number of tests performed for each test type and the associated descriptive values of test results for each test type. I am looking at the raw dataset and I see that within the same test type there are a variety of units for the test result displayed (e.g., mg/dL, g/L, %. % of normal), I am assuming I would first have to start off with cleaning the data to make the units all the same? So would the steps I take look like: 1. clean the raw dataset and convert all values for each result to be consistent for each test type 2. group each lab test type into its own category - would I generate a new variable or use if and then statements? 3. run the following for each lab test? 4. Would this also include the low and high reference ranges? PROC IMPORT OUT = LB
DATAFILE = 'M:\SAS\TAKEDA EDR/LB.xlsx'
DBMS = xlsx;
RUN;
DATA LB2;
SET LB;
OVERALL = "Overall";
RUN;
TITLE "Type of Lab Test Name - how to clean data, convert units, therafter use this data to calculate means etc. and include ref ranges??";
PROC FREQ DATA=WORK.LB2;
TABLE LBTESTCD_DEC * OVERALL;
RUN;
DATA WORK.LB2;
SET LB;
IF LBTESTCD_DEC="C1-INH functional levels" THEN C1INH_F=1;
ELSE C1INH_F = .;
RUN;
TITLE "Lab Results by Lab Test Type";
PROC MEANS DATA=WORK.LB2 MEAN STDDEV MEDIAN MIN MAX KURT SKEW;
CLASS OVERALL;
VAR insert test name here;
RUN; Thank you in advance for your assistance. Best wishes, T.
... View more