About cmendoza87

cmendoza87 · ‎12-16-2022

This worked, thank you!! I feel kind of dumb for not having tried that haha thank you for your help with this!

cmendoza87 · ‎12-16-2022

Sorry for the delay in responding. I do not see that message in the log. This is what I see: NOTE: The input data set is subset by WHERE, OBS, or FIRSTOBS. This provides a completely separate analysis of the subset. It does not provide a statistically valid subpopulation or domain analysis, where the total number of units in the subpopulation is not known with certainty. If you want a domain analysis, you should include the DOMAIN variables in a DOMAIN statement. NOTE: The BY statement provides completely separate analyses of the BY groups. It does not provide a statistically valid subpopulation or domain analysis, where the total number of units in the subpopulation is not known with certainty. If you want a domain analysis, you should include the DOMAIN variables in a DOMAIN statement. NOTE: The data set WORK.STATS1 has 30 observations and 10 variables. I included MEDIAN in the proc statement. I am using surveymeans because I am trying to get median values for the imputed data and I saw this post: Solved: Multiple imputation - caculating medians - SAS Support Communities I am certainly open to other options. Thank you!

cmendoza87 · ‎12-15-2022

My subgroups are male and female, but I only get one estimate instead of two in the output. Thank you!

cmendoza87 · ‎12-15-2022

Hello, I have run MI with 30 imputations and would like to calculate median estimates among subgroups. Using the code below, I was able to get median estimates, but I cannot seem to output the subgroup estimates. PROC SORT DATA=for_gee; BY _imputation_; RUN; PROC SURVEYMEANS DATA=for_gee MEDIAN; BY _imputation_; WHERE months_post = .; DOMAIN sex; VAR igg_value_new; ODS OUTPUT QUANTILES=stats1; RUN; I get this (one of the imputations): The SURVEYMEANS Procedure Imputation Number=30 Quantiles for Sex Domain sex Variable Percentile Estimate Std Error 95% Lower CL 95% Upper CL Female igg_value_new 50 Median 0.968816 0.009923 0.94935319 0.98827979 Male igg_value_new 50 Median 0.980282 0.013516 0.95377236 1.00679102 In the output, I am only getting one estimate per imputation (0.972689). Is there a way to change the output to include both estimates? Thank you!

cmendoza87 · ‎07-19-2022

Thank you so much, this worked perfectly!

cmendoza87 · ‎07-18-2022

Thank you, I was hoping for it to look something like this, but I think I would need to redo my datalines? Or is there a way to separate each group (i.e. overall, no_DS, etc) into baseline and visit 2? Thank you so much for your help!

cmendoza87 · ‎07-18-2022

I would like to connect: 109.97 to 106.58, 109.70 to 105.97, 110.72 to 107.55, 111.19 to 107.89, 109.32 to 107.09, 111.37 to 108.23, 110.81 to 107.40, 109.80 to 106.47, 110.59 to 107.30, 111.46 to 108.91. Ideally, the points would be slightly jittered so that the error bars could still show but that may not be possible.

cmendoza87 · ‎07-17-2022

Hello, I am trying to use proc sgplot with scatter and series to create a plot that shows differences between two time points for each group and would like to be able to connect the dots if possible. Code: DATA Change_all2; INPUT Time $ Group $ Variable2 $ Estimate Lower Upper; DATALINES; Baseline Overall eGFR 109.97 109.56 110.38 Baseline No_DS eGFR 109.70 109.18 110.22 Baseline DS eGFR 110.72 110.15 111.29 Baseline DS_Infreq eGFR 111.19 110.54 111.84 Baseline DS_Freq eGFR 109.32 108.32 110.32 Baseline DS_Bot eGFR 111.37 110.50 112.24 Baseline DS_NVNM eGFR 110.81 109.93 111.70 Baseline DS_Vit_Min eGFR 109.80 108.79 110.80 Baseline DS_NonNeph eGFR 110.59 109.99 111.20 Baseline DS_Neph eGFR 111.46 110.38 112.55 Visit2 Overall eGFR 106.58 106.13 107.03 Visit2 No_DS eGFR 105.97 105.38 106.56 Visit2 DS eGFR 107.55 106.88 108.22 Visit2 DS_Infreq eGFR 107.89 107.15 108.64 Visit2 DS_Freq eGFR 107.09 105.70 108.48 Visit2 DS_Bot eGFR 108.23 107.23 109.22 Visit2 DS_NVNM eGFR 107.40 106.27 108.54 Visit2 DS_Vit_Min eGFR 106.47 105.30 107.64 Visit2 DS_NonNeph eGFR 107.30 106.55 108.04 Visit2 DS_Neph eGFR 108.91 107.80 110.02 ; RUN; PROC SGPLOT DATA=Change_all2; WHERE Variable2 = "eGFR"; LABEL Estimate = "Age- and Sex-Adjusted ACR and eGFR"; SCATTER Y=Estimate X=Group / GROUP=Time GROUPDISPLAY=CLUSTER YERRORLOWER=Lower YERRORUPPER=Upper JITTER; SERIES Y=Estimate X=Group / GROUP=Time GROUPDISPLAY=CLUSTER; XAXIS TYPE=DISCRETE; TITLE "Baseline to Visit 2 eGFR by Group"; RUN; Ideally, I would like there to be a line from baseline to visit 2 for each group instead of what is shown above but I am not sure how to make that happen. Thank you!

cmendoza87 · ‎03-24-2022

You are my hero, thank you so much! In all of my googling, I did not realize that you could copy and paste the PROC SETINIT statements and that would do it. Thank you again!!!

cmendoza87 · ‎03-24-2022

Hello, I am trying to update the license for my SAS 9.4. I have tried running the Renew SAS Software 9.4 and the actual sasdm file as an administrator and every time, I get to the "User Access Control" prompt and click "yes", the screen goes away but nothing else happens. I have tried closing all other programs and still nothing. Then I tried to uninstall SAS so I could reinstall it again and of course the same Deployment Manager is needed and will not work. I looked at the logs and below is what it says. I bolded the error statements. I am not sure what to do. Thu Mar 24 18:12:15 2022 Launcher started.... path= C:\Users\John\AppData\Local\SAS\SASDeploymentWizard logfile= C:\Users\John\AppData\Local\SAS\SASDeploymentWizard\sasdm_2022-3-24-18.12.15.log Thu Mar 24 18:12:15 2022 INFO: LRun::start::templocation= Thu Mar 24 18:12:15 2022 INFO: LRun::start::USERHOME=C:\Users\John\AppData\Local\SAS\SASDeploymentWizard Thu Mar 24 18:12:15 2022 INFO: EnvCalls::isWow64=true Thu Mar 24 18:12:15 2022 INFO: DataControl::GetProperties::masterProperty=C:\Program Files\SASHome\sassw.config Thu Mar 24 18:12:15 2022 INFO: LRun::start::param= Thu Mar 24 18:12:15 2022 INFO: Launcher::Run::start::inifile=C:\Program Files\SASHome\SASDeploymentManager\9.4\sasdm.ini Thu Mar 24 18:12:15 2022 INFO: Launcher::Run::start::platform=wx6 Thu Mar 24 18:12:15 2022 INFO: Launcher::Run::start::startdir(launchhome)=C:\Program Files\SASHome\SASDeploymentManager\9.4 Thu Mar 24 18:12:15 2022 INFO: Launcher::Run::start::launchercmd=C:\Program Files\SASHome\SASDeploymentManager\9.4\products\privatejre__99572__wx6__xx__sp0__1\bin\java.exe Thu Mar 24 18:12:15 2022 INFO: Launcher::Run::start::launcherargs=-Xmx1024M "-Djavax.net.ssl.trustStore=C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\lib\security\jssecacerts" -jar "C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94546__prt__xx__sp0__1\deploywiz\setup.jar" -startuplocation "C:\Program Files\SASHome\SASDeploymentManager\9.4" -configure Thu Mar 24 18:12:15 2022 INFO: Launcher::Run::start::Run with stdout="C:\Program Files\SASHome\SASDeploymentManager\9.4\products\privatejre__99572__wx6__xx__sp0__1\bin\java.exe" -Xmx1024M "-Djavax.net.ssl.trustStore=C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\lib\security\jssecacerts" -jar "C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94546__prt__xx__sp0__1\deploywiz\setup.jar" -startuplocation "C:\Program Files\SASHome\SASDeploymentManager\9.4" -configure Thu Mar 24 18:12:15 2022 ERROR: ExeProc::ExeandDisplay::GetStdHandle::NULL=183 Thu Mar 24 18:12:15 2022 INFO: ExeProc::ReadFromPipe=Standard output Error: could not open `C:\Program Files\SASHome\SASDeploymentManager\9.4\products\privatejre__99572__wx6__xx__sp0__1\lib\i386\jvm.cfg' Thu Mar 24 18:12:15 2022 INFO: ExeProc::ExeandDisplay::GetExitCodeProcess=1 Thu Mar 24 18:12:15 2022 INFO: CWinlauncherApp::InitInstance=1 Thu Mar 24 18:12:15 2022 INFO: CWinlauncherApp::CleanupScript does not exist= Thu Mar 24 18:12:15 2022 INFO: CWinlauncherApp::ExitInstance=1 Thank you!

cmendoza87 · ‎02-15-2022

ahh I see that now, thank you!

cmendoza87 · ‎02-15-2022

Thank you for your response and apologies for the delay in responding! This worked! I also used it to check that the risk ratio estimates from the macro were the same as the PROC FREQ estimates when using a binary variable. Do you happen to know the estimation method used to calculate the confidence interval in the NLMEANS macro? It is different from the PROC FREQ estimation of confidence interval because the interval estimates are slightly different from each other. Thank you!!!!!

cmendoza87 · ‎02-10-2022

Hello, I am trying to measure relative risk and risk difference on a 3-categorical variable. I was easily able to calculate risk difference using a binary variable and proc surveyfreq: PROC SURVEYFREQ DATA=full ORDER=DATA; STRATA strat; CLUSTER PSU_ID; WEIGHT weight_final_norm_overall; TABLE KEEP_dssamp1*eids_user*PreCKD /row CL RISK OR; RUN; eids_user is a binary variable (0=non-user, 1=user). I was also able to calculate risk difference easily using proc surveyreg: PROC SURVEYREG DATA=full; STRATA strat; CLUSTER PSU_ID; WEIGHT weight_final_norm_overall; DOMAIN KEEP_dssamp1; MODEL PreCKD = eids_user /SOLUTION; ESTIMATE 'DS user' int 1 eids_user 1 /E CL; ESTIMATE 'non-user' int 1 eids_user 0 /E CL; ESTIMATE 'PD USER vs non-user' int 0 eids_user 1 /E CL; RUN; Thank you! I would like to do the above with a 3-category variable (eids_user_freq2) that takes into account frequency of use (0=non-user, 1=infrequent user, 2=frequent user) but when I do the above statements using this variable, I get percentage estimates and risk difference but not relative risk. I could manually calculate the relative risk but I wanted to see if one of the proc survey commands can calculate it. I used the code below: PROC SURVEYFREQ DATA=full ORDER=DATA; STRATA strat; CLUSTER PSU_ID; WEIGHT weight_final_norm_overall; TABLE KEEP_dssamp1*eids_user_freq2*PreCKD /row CL RISK OR; RUN; PROC SURVEYREG DATA=full ORDER=DATA; STRATA strat; CLUSTER PSU_ID; WEIGHT weight_final_norm_overall; DOMAIN KEEP_dssamp1; CLASS eids_user_freq2; MODEL PreCKD = eids_user_freq2 /SOLUTION; ESTIMATE 'non user' intercept 1 eids_user_freq2 1 0 0 /E CL; ESTIMATE 'infrequent user' int 1 eids_user_freq2 0 1 0 /E CL; ESTIMATE 'frequent user' int 1 eids_user_freq2 0 0 1 /E CL; ESTIMATE 'frequent vs non-user' int 0 eids_user_freq2 -1 0 1 /E CL EXP; RUN;

cmendoza87 · ‎08-15-2021

This worked! Thank you so much!!!! PROC SQL seemed really complicated to me before but this code will definitely help me use it more.

cmendoza87 · ‎08-14-2021

I have a large dataset with multiple observations per person. I am having trouble creating a separate dataset from this dataset where if a person has a given observation (fever = yes) that I can delete all of their observations, not just the observation with fever = yes. Is there a way to IF-THEN-DELETE a group? Have: ID Fever 1 N 1 N 1 N 1 N 1 N 1 N 1 N 2 Y 2 N 2 N 2 N 2 N 5 N 5 N 5 N 5 N 5 N Want: ID Fever 1 N 1 N 1 N 1 N 1 N 1 N 1 N 5 N 5 N 5 N 5 N 5 N Thank you!

Online Status	Offline
Date Last Visited	‎04-11-2023 03:15 PM

Re: PROC SURVEYMEANS, quantiles, and outputs

Re: PROC SURVEYMEANS, quantiles, and outputs

Re: PROC SURVEYMEANS, quantiles, and outputs

PROC SURVEYMEANS, quantiles, and outputs

Re: PROC SGPLOT scatter and series, connecting dots within group

Re: PROC SGPLOT scatter and series, connecting dots within group

Re: PROC SGPLOT scatter and series, connecting dots within group

PROC SGPLOT scatter and series, connecting dots within group

Re: SAS Deployment Manager Does Not Open

SAS Deployment Manager Does Not Open

Re: PROC SGPLOT scatter and series, connecting dots within group

Re: PROC SGPLOT scatter and series, connecting dots within group

Re: SAS Deployment Manager Does Not Open

Re: SAS Deployment Manager Does Not Open

Re: Relative risk using surveyfreq or surveyreg

Re: SAS Deployment Manager Does Not Open

Re: PROC SURVEYMEANS, quantiles, and outputs

Re: PROC SURVEYMEANS, quantiles, and outputs

Re: PROC SURVEYMEANS, quantiles, and outputs

PROC SURVEYMEANS, quantiles, and outputs

Re: PROC SGPLOT scatter and series, connecting dots within group

Re: PROC SGPLOT scatter and series, connecting dots within group

Re: PROC SGPLOT scatter and series, connecting dots within group

PROC SGPLOT scatter and series, connecting dots within group

Re: SAS Deployment Manager Does Not Open

SAS Deployment Manager Does Not Open

Re: Relative risk using surveyfreq or surveyreg

Re: Relative risk using surveyfreq or surveyreg

Relative risk using surveyfreq or surveyreg

Re: Deleting Group from single observation

Deleting Group from single observation