Hi, I am working with a large dataset containing 500,000 rows and 4,000 columns, which requires 10 GB of memory. I imported the data into SAS, but only a portion of the data was successfully loaded, and many variables were not detected during analysis. My computer has limited memory, with only 16 GB available. Consequently, SAS is unable to open the entire dataset. How can I open the full dataset and ensure all variables are available for analysis in SAS? ... View more

Hi I want to explore the relationship between fruit consumption and diabetes. I've categorized fruit intake into tertiles, while diabetes status is binary (yes/no). I want to adjust the findings to age (continuous), gender (categorical), race (categorical), and physical activity (categorical) in the analysis. Is the logistic regression code that I want to use correct? proc logistic data=SS plots(only)=(effect oddsratio); class Gender(ref='1') race(ref='1') physical_activity(ref='1')/param=ref ; model diabetes(event='1')= fruitcode age Gender race physical_activity/Clodds=wald; title " Association of fruit with diabetes (adjust for age, gender, race, physical activity) "; run; Fruitcode: I used fruit tertile in this code.   For finding the P-trend, I used this code: proc logistic data=SS plots(only)=(effect oddsratio); model diab(event='1')= fruit age Gender race physical_activity/Clodds=wald;; run; Fruit is continuous ... View more

Hi  I would appreciate it if you could answer my question quickly. I want to see the dietary iron among case (patient) and control (healthy). The variable for disease is risk factor. I want to adjust sex, alcohol (yes/no), drug (yes/no), and BMI. Is this the correct code? proc glm data=SS;    class risk factor sex alcohol drugs;    model Iron= risk factor sex alcohol drugs BMI_A / solution;    lsmeans risk factor/ stderr pdiff cov out=adjmeans; run; ... View more

Hi, I want to do post hoc power analysis for Co regression. I want to calculate power in SAS for cox regression. I can find the hazard ratio and confidence interval from other studies. How can find R square and standard deviation for these code  proc power; coxreg hazardratio = 1.4 rsquare = 0.15 stddev = 1.2 ntotal = 80 eventprob = 0.8 power = . ; run; ... View more

Hi I want to calculate sample size by SAS for a clinical trial study which use repeated measure ANOVA test. We want to obtain P interaction between time and treatment. We have intervention and control group and three time point" baseline, 3 month, 6 month". We want to see the effects of nut on systolic blood pressure (SBP) compare to control group. These are mean and stardand deviation : nut : baseline :6±3    after three month:5±4   after 6 month: 4±2   control : baseline :7±3    after three month:6±4   after 6 month: 5±2     I want to use this code: proc glmpower data=WellnessMult; class Treatment; weight ?; model WellScore1 WellScore3 = Treatment; repeated Time 3; power effects=(Treatment) mtest = hlt alpha = 0.05 power = .9 ntotal = . stddev = ? matrix ("WellCorr") = lear(0.85, 1, 3, 1 3 6) corrmat = "WellCorr"; run;   I have question: what should I put for stddev? what should I put for weight? Is the code correct? ... View more