About gx2144

gx2144 · ‎04-04-2021

Hi, I am doing the dose-response relationship using restricted cubic splines in cox model and I need the code for %RCS_REG macro. Could someone provide the code for this macro? Or could someone provide any examples for this topic? Appreciated.

gx2144 · ‎01-28-2021

gx2144 · ‎01-28-2021

The orientation of the label in proc sgplot is vertical. How can I change the label into horizontal? proc sgplot data = baseline; histogram salary/datalabel; density salary; density salary/type= kernal; keylegend / location=inside position=topright; run;

gx2144 · ‎01-28-2021

title "Gender Distribution of Company A"; proc sgplot data = baseline; vbar Sex__Male_1_ /response=percent datalabel ; format Sex__Male_1_ sex.; run; response = percent not working the log shows: 35 ods trace on; 136 title "Gender Distribution of Company A"; 137 proc sgplot data = baseline; 138 vbar Sex__Male_1_ /response=percent datalabel ; ERROR: Variable PERCENT not found. 139 format Sex__Male_1_ sex.; 140 run; Need help to transform the yaxis into percent format

gx2144 · ‎01-27-2021

253 %kw_edu(se) MLOGIC(KW_EDU): Beginning execution. MLOGIC(KW_EDU): Parameter X has value se NOTE: Data file SHS.HSB2.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. MPRINT(KW_EDU): proc npar1way data = shs.hsb2 wilcoxon; MPRINT(KW_EDU): class s1edu_cat; MPRINT(KW_EDU): format s1edu_cat education.; MPRINT(KW_EDU): var se; MPRINT(KW_EDU): run; NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.49 seconds cpu time 0.37 seconds MLOGIC(KW_EDU): Ending execution. 254 %kw_edu((se_cr) MLOGIC(KW_EDU): Beginning execution. 255 %kw_edu((zn) MLOGIC(KW_EDU): Beginning execution. 256 %kw_edu((zn_cr) MLOGIC(KW_EDU): Beginning execution. 257 %kw_edu((sb) MLOGIC(KW_EDU): Beginning execution. 258 %kw_edu((sb_cr) MLOGIC(KW_EDU): Beginning execution. 259 %kw_edu((cd) MLOGIC(KW_EDU): Beginning execution. 260 %kw_edu((cd_cr) MLOGIC(KW_EDU): Beginning execution. 261 %kw_edu((pb) MLOGIC(KW_EDU): Beginning execution. 262 %kw_edu((pb_cr) MLOGIC(KW_EDU): Beginning execution. 263 %kw_edu((mo) MLOGIC(KW_EDU): Beginning execution. 264 %kw_edu((mo_cr) MLOGIC(KW_EDU): Beginning execution. 265 %kw_edu((w) MLOGIC(KW_EDU): Beginning execution. 266 %kw_edu((w_cr) MLOGIC(KW_EDU): Beginning execution. 267 %kw_edu((u) MLOGIC(KW_EDU): Beginning execution. 268 %kw_edu((u_cr) MLOGIC(KW_EDU): Beginning execution. 269 %kw_edu((sum_all) MLOGIC(KW_EDU): Beginning execution. 270 %kw_edu((sum_all_cr); MLOGIC(KW_EDU): Beginning execution. 271 272 /*smoking status*/ 273 proc sort data = shs.hsb2; 274 by s1smoke_n; 275 run; 276 277 proc univariate data = shs.hsb2 noprint ; 278 histogram se se_cr zn zn_cr sb sb_cr cd cd_cr pb pb_cr mo mo_cr w w_cr u u_cr/NORMAL; 279 qqplot/normal; 280 run; 281 282 proc means data = shs.hsb2 N Mean Median P25 P75 MaxDec = 3; 283 var se se_cr zn zn_cr sb sb_cr sum_all sum_all_cr cd cd_cr pb pb_cr mo mo_cr w w_cr u u_cr; 284 class s1smoke_n; 285 format s1smoke_n drink_smoke.; 286 run; 287 288 %macro kw_smoke(x); 289 proc npar1way data = shs.hsb2 wilcoxon; 290 class s1smoke_n; 291 format s1smoke_n drink_smoke.; 292 var &x; 293 run; 294 %mend; 295 296 %kw_smoke(se) MLOGIC(KW_SMOKE): Beginning execution. MLOGIC(KW_SMOKE): Parameter X has value se MLOGIC(KW_SMOKE): Ending execution. 297 %kw_smoke((se_cr); MLOGIC(KW_SMOKE): Beginning execution. 298 %kw_smoke((zn) MLOGIC(KW_SMOKE): Beginning execution. 299 %kw_smoke((zn_cr) MLOGIC(KW_SMOKE): Beginning execution. 300 %kw_smoke((sb) MLOGIC(KW_SMOKE): Beginning execution. 301 %kw_smoke((sb_cr) MLOGIC(KW_SMOKE): Beginning execution. 302 %kw_smoke((cd) MLOGIC(KW_SMOKE): Beginning execution. 303 %kw_smoke((cd_cr) MLOGIC(KW_SMOKE): Beginning execution. 304 %kw_smoke((pb) MLOGIC(KW_SMOKE): Beginning execution. 305 %kw_smoke((pb_cr) MLOGIC(KW_SMOKE): Beginning execution. 306 %kw_smoke((mo) MLOGIC(KW_SMOKE): Beginning execution. 307 %kw_smoke((mo_cr) MLOGIC(KW_SMOKE): Beginning execution. 308 %kw_smoke((w) MLOGIC(KW_SMOKE): Beginning execution. 309 %kw_smoke((w_cr) MLOGIC(KW_SMOKE): Beginning execution. 310 %kw_smoke((u) MLOGIC(KW_SMOKE): Beginning execution. 311 %kw_smoke((u_cr) MLOGIC(KW_SMOKE): Beginning execution. 312 %kw_smoke((sum_all) MLOGIC(KW_SMOKE): Beginning execution. 313 %kw_smoke((sum_all_cr) MLOGIC(KW_SMOKE): Beginning execution. It stops running after the first line of %kw_edu(se)

gx2144 · ‎01-27-2021

Hi, my macro will stop when running to a certain line. The log is as below: %kw_edu(se) runs well but %kw_edu(se_cr) stop running suddenly. Why did it happen? 244 245 %macro kw_edu(x); 246 proc npar1way data = shs.hsb2 wilcoxon; 247 class s1edu_cat; 248 format s1edu_cat education.; 249 var &x; 250 run; 251 %mend; 252 253 %kw_edu(se) NOTE: Data file SHS.HSB2.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.87 seconds cpu time 0.50 seconds 254 %kw_edu((se_cr) 255 %kw_edu((zn) 256 %kw_edu((zn_cr) 257 %kw_edu((sb) 258 %kw_edu((sb_cr) 259 %kw_edu((cd) 260 %kw_edu((cd_cr) 261 %kw_edu((pb) 262 %kw_edu((pb_cr)

gx2144 · ‎01-25-2021

Sgplot is doable. I use proc freq because I can simultaneously output freq table, chart, chisq table and fisher exact table.

gx2144 · ‎01-25-2021

Thank you. I used ods trace on but the log error shows: error: 856-580: This statement can only be used inside the Begingraph block"

gx2144 · ‎01-24-2021

The log shows the error: error: 856-580: This statement can only be used inside the Begingraph block

gx2144 · ‎01-24-2021

I want to control the output of the proc freq using proc template and I want to change the title of the plot I output using the option. Here is the code: proc format; picture pctfmt (round) other="009.9%"; run; proc template; define crosstabs Base.Freq.CrossTabFreqs; cellvalue frequency percent RowPercent ColPercent; define frequency; format=8.; header="Count"; end; define percent; format=pctfmt.; header="Overall %"; end; define RowPercent; header="Row Pct"; format=6.2; label="Percent of Row Frequency"; end; define ColPercent; header="Col Pct"; format=6.2; label="Percent of Column Frequency"; end; define header tableof; text "Table of " _row_label_ " by " _col_label_; end; define header rowsheader; text " "; end; define header colsheader; text " "; end; cols_header=colsheader; rows_header=rowsheader; header tableof; end; define statgraph Base.Freq.Graphics.ClusterPercentChart; /* more code here */ entrytitle "Distribution of" _row_label "by" _col_label; run; /*compare by sex*/ /*R5*/ proc freq data = subset; label y1p_G_GIRL = "Gender" R5status = "R5"; title "Table of Gender by R5 status"; table y1p_G_GIRL * R5status/nopercent chisq plots=freqplot(groupby=column twoway=cluster scale=percent); format R5status $normal.; format y1p_G_GIRL sex.; run; I want to change the variable name into Gender here using proc template, it seems that it is doable using "define statgraph Base.Freq.Graphics.xxxxxxx;", but I do not what is the plot name should I use in proc template. Looking for your reply.

gx2144 · ‎09-13-2020

ODS GRAPHICS OFF; 222 ODS GRAPHICS ON; 223 PROC TRANSREG DATA = work6 TEST; 224 MODEL BOXCOX(VT_ln) = IDENTITY(y1p_vs01A11 weight_kg y1p_G_AGE ); 225 RUN; ERROR: 187 invalid values were encountered while attempting to transform variable VT_ln. WARNING: Ordinary missing values were found or an UNTIE transformation or the UNTIE= option was specified. The utility of the hypothesis tests are dubious since one parameter must be estimated for each of these values. If you really want to do this, ensure that no observations are duplicated -- combine duplicate observations and use a FREQ statement. If you do not, the parameter count may be too large and the tests overly conservative. However, it is best to avoid this situation altogether. Can someone help with the warning here? What should I do with my response variable?

gx2144 · ‎08-25-2020

Hi, I wanted to apply quantile regression equation on my dataset. Below is the function: How can I apply these equations on my variables (age, weight, height and Z5)? Appreciated.

gx2144 · ‎08-23-2020

The equations were: R5 (KPa/L/s) = −3.841167 × logHeight + 8.671580; R20 (KPa/L/s) = −2.546561 × logHeight + 5.841867; X5 (KPa/L/s) = −0.000097 × Age + 1.018597 × logHeight − 2.343672. I had a data set that contains these variables(height, age, R5,R20,X5) and I wanted to apply these functions on my data set. And I wanted to see if these equations fit my data. If this makes sense to you.

gx2144 · ‎08-23-2020

Hi, I had a series of functions that I obtained from previous studies and I wanted to apply these functions to my data. And I also wanted to test if these functions fit our data. Could anyone give some hints on the coding ? Appreciated.

gx2144 · ‎08-22-2020

Hi, I have trouble with selecting proper model to fit the data. I first apply the simple linear regression with one independent variable and one dependent variable. However, it fits bad. I would like to now what model is appropriate for data distribution like this? Or what can I do to improve the fit?

Online Status	Offline
Date Last Visited	‎05-14-2021 01:14 PM

%RCS_REG SAS macro coding

Re: data label in proc sgplot

data label in proc sgplot

proc sgploy vbar

Re: SAS MACRO NOT RUNNING

SAS MACRO NOT RUNNING

Re: Proc template in Proc Freq; Change title of the Freq table

Re: Proc template in Proc Freq; Change title of the Freq table

Re: Proc template in Proc Freq; Change title of the Freq table

Proc template in Proc Freq; Change title of the Freq table

%RCS_REG SAS macro coding

Re: data label in proc sgplot

data label in proc sgplot

proc sgploy vbar

Re: SAS MACRO NOT RUNNING

SAS MACRO NOT RUNNING

Re: Proc template in Proc Freq; Change title of the Freq table

Re: Proc template in Proc Freq; Change title of the Freq table

Re: Proc template in Proc Freq; Change title of the Freq table

Proc template in Proc Freq; Change title of the Freq table

boxcox error

Quantile regression

Re: Need help with fitting data with an existing varaible

Need help with fitting data with an existing varaible

Need help with model choosing