I'm trying to divide a large dataset into smaller 3 unequal sized groups. I used the following code: PROC SURVEYSELECT data = Original out = sample9 method = SRS seed = 12345678 sampsize = (1000 52175 13044); strata ID notsorted; *title; RUN; However, I'm getting the following error: ERROR: The sample size, 1000, is greater than the number of sampling units, 1. NOTE: The above message was for the following stratum: IID=TV20_2018. ERROR: The sample size, 52175, is greater than the number of sampling units, 1. NOTE: The above message was for the following stratum: IID=TV20_2018. ERROR: The sample size, 13044, is greater than the number of sampling units, 1. NOTE: The above message was for the following stratum: IID=TV20_2018. ERROR: The number of values in the SAMPSIZE= list must equal the number of strata. There are more strata than SAMPSIZE= values. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.SAMPLE9 may be incomplete. When this step was stopped there were 0 observations and 75 variables. Can you please suggest, how I can address this? TIA ... View more

I'm working with longitudinal data, wherein the person has multiple measurements at different time points as follows. I would like to how I can estimate the rate of decline in this variable over time? Also, what is the best way to visualize this data? Date GFR 1/1/15 53 4/7/15 53 8/18/15 54 12/20/15 50 5/13/16 48 10/25/16 49 3/9/17 47 7/15/17 46 1/4/18 48 I'm interested in looking at the distribution of decline in GFR over time.  ... View more

Hello everyone,    I would like to know how I can plot the density plot comparing the first and last decile group of a quantitive variable.    Thanks in advance ... View more

Hello everyone, I'm trying to import the .csv file containing data into SAS. However, the date column is converted to char and format as $12.   Please suggest to me a way import this data correctly into SAS. Here are the first few observations from the.csv file: Test_ID Test_date Test Test_unit Test_ref M00000001 27-05-19 2.92 g/dL 3.8-5.3 M00000001 03-06-19 3.08 g/dL 3.8-5.3 M00000001 05-06-19 3.24 g/dL 3.8-5.3 M00000001 10-06-19 3.51 g/dL 3.8-5.3 M00000001 18-06-19 3.76 g/dL 3.8-5.3 M00000001 13-03-20 3.06 g/dL 3.8-5.3 M00000001 23-03-20 3.4 g/dL 3.8-5.3 M00000001 03-04-20 3.72 g/dL 3.8-5.3 M00000002 11-01-17 3.39 g/dL 3.8-5.3 M00000002 18-01-17 3.53 g/dL 3.8-5.3 M00000003 24-11-16 4.18 g/dL 3.8-5.3 M00000003 07-06-18 4.44 g/dL 3.8-5.3 And here is the import code I have used:   %let path=E:\Lab_tests; options validvarname=v7; proc import datafile="&path\Lab_test.csv" out=Lab_test dbms=csv REPLACE; guessingrows=max; run;quit; Thanks in advance   ... View more