About Cecillia_Mao

Cecillia_Mao · ‎08-24-2021

Hi Tom, Thanks for the reply! I made the case a little bit confused in the original post. If only considering running the model itself, the class statement would be enough. However, I just want to change character variables to 0,1,2,3... for assumption check, which sometimes requires the data in numeric format. Thanks again!

Cecillia_Mao · ‎08-24-2021

Thanks for pointing that out, it had been a little bit confusing. I revised the original post a little bit. They are about 20 independent character variables that need to be converted to numeric ones.

Cecillia_Mao · ‎08-24-2021

Thanks so much, Chris! It's not exactly what I'm looking for, but it's much better than if-then and proc format in some cases! Thanks for sharing!

Cecillia_Mao · ‎08-24-2021

Hi Paige, Thanks for the reply! I'm checking the MULTICOLLINEARITY assumption, and I'm using the "Correlation matrix" criteria, which means I need to use “proc corr ” that needs numerical variables. BTW, this is the material I'm referring to https://www.lexjansen.com/wuss/2018/130_Final_Paper_PDF.pdf .

Cecillia_Mao · ‎08-23-2021

Hi everyone, I'm doing a logistic regression. However, I need to convert about 20 independent characteristic variables to numeric ones in order to check assumptions. I have seen something like an option(probably in a proc step) to change yes/no to 0/1 in just one step (Not if then, not proc format, not array), but I totally forgot where it came from. I tried my best to search similar stuff( "categorical variable to 1 2 3 in one step",etc), but I haven't found anything like an option that can do the job. I'm sorry that I can't provide more information, any hints would be APPRECIATED!

Cecillia_Mao · ‎12-06-2020

Thanks a lot! I really appreciate it! Sometimes, if there is no available options, we do need to calculated step by steps.

Cecillia_Mao · ‎12-06-2020

Thank you so much Reeza. That totally make sense why mean squared error or the mean absolute error measures are used more often. I was supposed to ask how to calculate mean deviation. Unlike to standard deviation, I believe meand deviation can't be calculated using proc means options directly.

Cecillia_Mao · ‎12-06-2020

Thank you Ballardw, I'm sorry for the late reply. I was confused with the following two staitistics: "mean error" and "mean deviation" mean deviation,which is sum(X-X̄)/n. Thanks for clarification.

Cecillia_Mao · ‎12-03-2020

Also from RGB percentage to RGB codes: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=graphref&docsetTarget=p0edl20cvxxmm9n1i9ht3n21eict.htm&locale=en#n0ye3r7vscamjun1uxyzeo84xml2 /* Compute the RGB percentages */ data _null_; r = 231; g = 179; b = 180; call symputx("r", round((r/255)*100)); call symputx("g", round((g/255)*100)); call symputx("b", round((b/255)*100)); run; /* Convert to RGB color name */ %COLORMAC; data _null_; put "%RGB(&r,&g,&b)"; run;

Cecillia_Mao · ‎12-02-2020

Hi everyone, does anyone know how to calculate mean error(ME) in SAS. I checked the proc means, its statistical list does not contain ME. So I'm wondering are there any procedures that can calculate ME directly? Thanks for any hints.

Cecillia_Mao · ‎08-29-2020

You can try to use the dlm option. The see the example below: proc import datafile="C:\temp\test.txt" out=test dbms=dlm replace; dlm=','; run;

Cecillia_Mao · ‎08-10-2020

Thank you! That works perfectly!

Cecillia_Mao · ‎08-10-2020

Hi SAS experts, For the below codes, I don't understand why &varlist only catched “height”, and low only catched '1'. It supposed to be "height weight" for &varlist; and "1.0 25" for &lowlist. Any thoughts would be appreciated! Thanks in advance~ data a; input var $ low high; cards; height 1.0 2.0 weight 25 200 ; run; proc sql; select Var, low, high into:varlist,:lowlist,:highlist separated by ' ' from a; quit; %put varlist: &varlist --- lowlist: &lowlist --- highlist:&highlist;

Cecillia_Mao · ‎06-25-2020

Thanks for the point! That would be a nice try.

Cecillia_Mao · ‎06-23-2020

After trying : 1. #m works in ODS PDF but not in HTML and RTF 2. Leading space for #_: works in HTML and PDF but not RTF

Online Status	Offline
Date Last Visited	‎01-11-2024 07:02 AM

Re: Y/N(char) variable to 0/1(num) with an option in Regression

Re: Y/N(char) variable to 0/1(num) with an option in Regression

Re: Y/N(char) variable to 0/1(num) with an option in Regression

Re: Y/N(char) variable to 0/1(num) with an option in Regression

Y/N(char) variable to 0/1(num) with an option in Regression

Re: How to calculate mean error(ME) in sas

Re: How to calculate mean error(ME) in sas

Re: How to calculate mean error(ME) in sas

Re: Converting Microsoft Office colors to SAS colors

How to calculate mean error(ME) in sas

Re: force showing all (label/group) values on y axis

Renaming unconventional Variable names

Re: Removing Subtitle from PROC LIFETEST Plot

Re: how to set the decimal points for LOGISTIC Regression

Re: Changing the title of a histogram, proc univariate, ods rtf

Re: order=formatted when no format specified for a CATEGORICAL variabl...

Re: Y/N(char) variable to 0/1(num) with an option in Regression

Re: Y/N(char) variable to 0/1(num) with an option in Regression

Re: Y/N(char) variable to 0/1(num) with an option in Regression

Re: Y/N(char) variable to 0/1(num) with an option in Regression

Y/N(char) variable to 0/1(num) with an option in Regression

Re: How to calculate mean error(ME) in sas

Re: How to calculate mean error(ME) in sas

Re: How to calculate mean error(ME) in sas

Re: Converting Microsoft Office colors to SAS colors

How to calculate mean error(ME) in sas

Re: proc import got unwanted variable when converting a tab-delimited ...

Re: Multiple macro variable: PROC SQL select into does not work as exp...

Multiple macro variable: PROC SQL select into does not work as expecte...

Re: ODS escapechar Line Wrapping: #m and #_ in RTF

Re: ODS escapechar Line Wrapping: #m and #_ in RTF