cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MarkusWeick
Online
  • 332 Posts
  • 551 Likes Given
  • 21 Solutions
  • 331 Likes Received
About
Since completing a Master's Course at the Department of Operational Research (now the Department of Management Science) at the University of Lancaster in England in 1990, I have been a devoted Operational Researcher. With this educational background, I have gained experience in various areas of the Financial Services sector, including Treasury, Capital Markets, Planning and Control, and Risk Management. Throughout my career, I have worked both in operational roles within organizations and as a consultant. The common thread running through my work has been a focus on providing quantitative decision support, particularly through the use of modeling (which is why I have a strong affinity for SAS) and fostering the growth and development of individuals. Currently I am working as Team Lead Treasury & Portfolio Management for EY ifb in Germany. In this role, my main areas of focus are SAS Risk Solutions and Scenario Planning. Additionally, I assist and mentor colleagues, both new and experienced, in their learning journeys with SAS. I genuinely appreciate the comprehensive SAS learning system.

Re: PROC CORR?

by Barite | Level 11 in SAS Procedures
‎10-14-2024 02:33 PM
‎10-14-2024 02:33 PM
 @robertrao , could you please provide the full text of your task. Best Markus ... View more

Re: PROC CORR?

by Barite | Level 11 in SAS Procedures
‎10-14-2024 03:22 AM
‎10-14-2024 03:22 AM
Starting with yout table new_EST I would calculate the average score per ID and then start the ttest:   proc sql; create table TTest_2 as select ID, APPOINTMENT_TYPE, avg(SCORE) as AVERAGE_SCORE from new_EST group by ID; quit; proc ttest data=TTest_2; class APPOINTMENT_TYPE; var AVERAGE_SCORE; run; ... View more

Re: PROC CORR?

by Barite | Level 11 in SAS Procedures
‎10-14-2024 01:25 AM
‎10-14-2024 01:25 AM
Hi @robertrao, would "are the average scores of the new IDs significantly different from the average scores of the established IDs?" be an alternative to "what is the correlation between average scores of the new IDs and their appointment type?" for you? Best Regards Markus ... View more

Re: Creating a Model Nutrition Label: Model Cards for SAS Model Studio...

by Barite | Level 11 in SAS Communities Library
‎08-19-2024 02:12 PM
‎08-19-2024 02:12 PM
Good model documentation is so important! ... View more

Re: How to start SAS for Programming 1 & 2 Certificate

by Barite | Level 11 in New SAS User
‎07-27-2024 01:13 AM
‎07-27-2024 01:13 AM
Hi @choi041 , sas ondemand for academics (https://welcome.oda.sas.com/) is a webbased sas studio application. So you don't need to download it. You can access it with your sas user profile for free. Just try it. For an introduction into SAS studio have a look at https://video.sas.com/detail/video/4573016757001/getting-started-with-sas-studio.   Best, Markus ... View more

Re: abnormal if then output

by Barite | Level 11 in SAS Programming
‎07-07-2024 02:53 AM
2 Likes
‎07-07-2024 02:53 AM
2 Likes
Hi @pavank, regarding the second question: Please read https://communities.sas.com/t5/SAS-Programming/Difference-between-only-IF-with-and-IF-with-THEN-statement/td-p/245441. Your if statements select only the rowas with sex = "F" and (!) sex = "M". "and" and not "or". But there are now rows with sex = "F" and (!) sex = "M". Hope this answers your question.   Best Markus ... View more

Re: abnormal if then output

by Barite | Level 11 in SAS Programming
‎07-07-2024 02:42 AM
‎07-07-2024 02:42 AM
Hi @pavank, regarding question 1: the else relates only to the "if" which is before it. Try this: data k; x=2; if x=1 then y=100; else if x=2 then y=200; else if x=3 then y=300; else y=27; run; Mayve it gives the results you want. The comparison of this code and its results with the code and results of your question 1 should help to understand  how nested if else works.   Best Markus ... View more

Re: SAS Bowl XLI, SAS Viya Workbench

by Barite | Level 11 in Upcoming Events
‎06-12-2024 12:03 AM
‎06-12-2024 12:03 AM
Unfortunately (to me) I can't join today. Wish you a good bowl! ... View more

Re: How create multiple records from horizontal data

by Barite | Level 11 in SAS Programming
‎05-29-2024 01:13 AM
1 Like
‎05-29-2024 01:13 AM
1 Like
and here the corresponding code: /*handling the missing*/ data want1; set have1; if intermediatestoptime = . then intermediatestoptime = restarttime; if restarttime = . then restarttime = intermediatestoptime; run; /*The two sets:*/ data want2a; keep date usubjid starttime finalstoptime; set want1; if intermediatestoptime ne missing then finalstoptime = intermediatestoptime; run; data want2b; keep date usubjid starttime finalstoptime; set want1; where intermediatestoptime is not missing; starttime = restarttime; run; /* appending the two sets*/ PROC APPEND BASE=want2a data=want2b; quit; /* Formating */ data want; keep start_dttime stop_dttime usubjid; retain start_dttime stop_dttime usubjid; set want2a; start_dttime = cat(put(date,DDMMYYD10.),"T",put(starttime,TOD.)); stop_dttime = cat(put(date,DDMMYYD10.),"T",put(finalstoptime,TOD.)); run; ... View more

Re: How create multiple records from horizontal data

by Barite | Level 11 in SAS Programming
‎05-29-2024 12:40 AM
‎05-29-2024 12:40 AM
Hi @SASuserlot , one aproach would be to split the data in two sets, one with the first start and stop time and one with the second start and stop time. And the append the two sets. ... View more

Re: Call macro inside of array

by Barite | Level 11 in SAS Programming
‎05-18-2024 01:31 AM
1 Like
‎05-18-2024 01:31 AM
1 Like
another way might be to define v1 and v2 as (temporary) array: data have; input id var1 var2; datalines; 1 . 5 2 3 4 3 4 5 5 0 6 6 9 8 ; run; %let nvar = 2; data want; set have; array v{2} _temporary_; v{1} = 5; v{2} = 8; array var{2} var1 : var&nvar; array flag{2} flag1-flag&nvar; do i = 1 to 2; if var{i} >= 5 then flag{i} = 1; else flag{i} = 0; end; drop i; run; ... View more

Re: Call macro inside of array

by Barite | Level 11 in SAS Programming
‎05-18-2024 01:25 AM
1 Like
‎05-18-2024 01:25 AM
1 Like
Hi @sascode , v1, v2 is not an array but just two macrovariables. If you want to keep them as macrovariables, one way to achieve your goal might be using a macro in your second data step: data want; set have; array var{2} var1 : var&nvar; array flag{2} flag1-flag&nvar; %macro steps; %do i = 1 %to 2; if var{&i} >= &&v&i then flag{&i} = 1; else flag{&i} = 0; %end; %mend; %steps; run; ... View more

Re: proc transpose: adjusting the length of the _name_ column

by Barite | Level 11 in SAS Procedures
‎05-17-2024 10:27 AM
‎05-17-2024 10:27 AM
Hi @ballardw, Thanks, and sorry for my badly prepared question. Next time I will do an example set before asking. (I found that the truncating was done later in proc append with forve option). Thanks again, Markus ... View more

proc transpose: adjusting the length of the _name_ column

by Barite | Level 11 in SAS Procedures
‎05-17-2024 09:42 AM
‎05-17-2024 09:42 AM
I am using proc transpose to change the table from wide to long. But in the column "old-column" the old some variable names are truncated. What can I do, to get them in the original length? proc transpose data=have name =old_column out=want by column_to_keep; run; Thanks, Markus ... View more

Re: SAS Bowl XL, SAS Innovate 2024 - Recap

by Barite | Level 11 in Upcoming Events
‎05-15-2024 07:27 AM
‎05-15-2024 07:27 AM
Sorry, can't join today, as I am with colleagues from EY ifb at a private Viya Update Workshop at SAS Germany in Heidelberg: ... View more
Contact Me
Online Status
Online
Date Last Visited
3 hours ago
Likes given to
View All
Quick links