About hovicke

hovicke · ‎04-19-2023

That should have been obvious... thanks!

hovicke · ‎04-19-2023

Hi - I'm trying to mess with some name variables in proc sql and the last step is to create the name in the format J. DOE. I can figure out how to keep the last name as lowercase (J. Doe) but not how to make the last upper case. Any suggestions? I tried: upcase(last) as upcaselast in the create table, but that didn't work. Below is my code: proc sql; create table new as Select first as firstname length=25, last as lastname length=25, strip(scan(first,1,' ') || " " || scan(last,1,' ')) as fullname length=51, strip(substr(scan(first,1,' '),1,1) || ". " || scan(last,1,' ')) as filast length=28 from salaries; quit; proc print data=new; var firstname lastname fullname filast; run;

hovicke · ‎03-16-2023

I have three separate data sets below. I want to use a data step to show for each of the new employees and interns who their manager is and which department they will work in. Also, which department has the most new people. I don't know how to sort the new_employee and new_intern data sets to then have them merge with the manager data set. data New_Employee; length name $15; input name $ team training_course work_experience; datalines; Bohr,Neils 1 0 3 Zook,Carla 2 2 2 Penrose,Roger 1 3 1 Martinez,Maria 3 1 2 Orfali,Philip 2 1 1 ; run; data New_Intern; length name $15 major $20; input name $ team training_course major $; datalines; Capalleti,Jimmy 3 1 FashionDesign Chen,Len 2 0 BusinessAnalytics Cannon,Annie 1 0 Mathematics Davis,Brad 3 0 Art Einstein,Albert 1 1 ComputerScience ; run; data Manager; length mname $15 department $10; input mname $ team department $; datalines; Wilson,Kenneth 1 Operation Bardeen,John 2 Marketing Sorrell,Joseph 3 Design ; run;

hovicke · ‎02-20-2023

Hi - I am looking for some help on how to calculate birth year given the below data and assuming the data was run on June 1, 2022: Employee YOE Age A 1 21 B 2 22.4 C 3 25 D 4 25.7 E 5 29 This is just a sample set of data as the actual data file is much larger. My goal is to determine which year the employees were born if the data file was ran on June 1, 2022. I originally just subtracted the 'Age' column from '2022' with the int() function but realized that doesn't take into account the report being run in June. Can anyone help point me in the right direction?

hovicke · ‎11-15-2022

Thanks, Paige. I guess I was confused about what proc pls actually does and did not realize variables did not have to be removed due to the multicollinearity. The objective was to find the “best” model from a set of data. I used proc glmselect for model selection and then wanted to test for multicollinearity using proc pls due to having both continuous and categorical variables and not being able to check vif with proc reg. If I did want to remove variables using the proc pls output, how would I go about doing that? Or should that not even be done to fit a “best” model due to what proc pls does?

hovicke · ‎11-14-2022

Hi - I have a data set with both continuous and categorical variables and I am trying to figure out if I can remove any of them due to multicollinearity. I have tried using proc pls both pls and pcr methods, but I am not sure if this is the right way to go about it. proc pls data=Vehicle details method=pls; class number_of_cylinders drive_wheels vehicle_type; model msrp=horsepower mpg_hwy weight wheelbase width drive_wheels/solution; run; My output shows not much of a change to the dependent variable r square at 3 extracted factors: So then I ran: proc pls data=Vehicle nfac=3 details method=pls; class number_of_cylinders drive_wheels vehicle_type; model msrp=horsepower mpg_hwy weight wheelbase width drive_wheels/solution; run; I'm not sure at this point what to do with the output and how to determine which factors I can remove from the model. Any help would be appreciated! This is my first course using SAS so if I'm completely off base, please point me in the right direction, thanks.

Online Status	Offline
Date Last Visited	‎04-19-2023 03:39 PM

Re: Proc SQL upcase

Proc SQL upcase

Help with combining and merging data sets

Calculating birth year by subtracting age from date.

Re: Multicollinearity in Multiple Linear Regression with Continuous an...

Multicollinearity in Multiple Linear Regression with Continuous and Ca...