About viollete

viollete · ‎02-03-2021

Hello, I have data similar to this format Month bmi_perc xrays_perc 1 2.5 1.9 2 0.8 2.1 3 4.5 1.7 4 15.4 0.2 5 3.0 1.0 6 3.2 5.4 I want to create a graph, where x axis would be Month, results for bmi_perc and xrays_perc presented as bubbles and now y axis. Something like this graph: Thank you.

viollete · ‎07-01-2020

Hello, I have a data that contains weekly time periods, observed value, predicted value and its 95% confidence intervals. Example: Time observed predicted l95 u95 02jan2017 292 252 231 293 09jan2017 323 330 310 351 16jan2017 323 319 299 340 23jan2017 324 322 302 342 30jan2017 327 322 301 342 i want to plot a graph with observed and predicted plot as a lines and confidence interval as a grey filled plot. How could i do it? Thank you.

viollete · ‎06-27-2019

Hi all, I want to do cluster analysis in SAS and I am little bit confused. I know that first you have to normalised your data and choose appropriate distance matrix (for example Euclidean distance) and then you do your cluster analysis. However, in SAS it is not very clear. Most examples I saw dont use distance matrix, like in proc cluster or proc fastclus. Why? Thanks.

viollete · ‎01-31-2019

Hello, I have this type of longitudinal data (I have over 130 hospitals in my data set): Hospital_id price ... 1 56 1 75 1 45 1 74 2 52 2 57 2 49 2 75 3 34 3 45 3 56 ......... I want to do leave one out cross validation. Something like this: 1. split data into train (hospitals 2 and 3) and test (hospital 1). 2. do analysis on train . 3. when i want to split data again into train (hospitals 1 and 3) and test (hospital 2). and so on... How automatically to do data splitting? Thanks

viollete · ‎11-20-2018

Hi , I have this information (this is just an example): Year Month Hospital Nr_beds 2016 12 RA 210 2017 1 RA 215 2017 2 RA . 2016 12 RB . 2017 1 RB 650 2017 2 RB 651 2016 12 RC 120 2017 1 RC 150 2017 2 RC 170 I want to extract only hospital who has no missing values in the variable Nr_beds. In new table I want to have just hospital RC, but not RA (cause it does not have information for time 2017/2) and hospital RB (cause it does not have information for time 2016/12)

viollete · ‎09-10-2018

I have at least 10 years period and over several millions observation. For each year, I want to find in which week the observation happened. So each year will have 1-52/53 weeks. if sas date is between 1st January 2018 and 4th January, week=1, if between 5th January 2018 and 11th then week=2 if sa date is between 1st January 2017 and 5th January, week=1, if between 6th January 2017 and 12th then week=2 and so on...

viollete · ‎09-07-2018

yes, for example in 2018 1 week would be from 1 January till 4 January, second from 5 to 8 and so on... I looked at INTCK function, however i need to give start and end dates, but I have a variable and i do not want to look what time period it consists every time i use it.

viollete · ‎09-07-2018

Hello, I have SAS date for various events and for each observation I want to determine which week of the year the event happen. However, i want that the week would start on Friday, not Sunday. How can i do this? Thank you

viollete · ‎09-06-2018

Hi, I want to use two-dimensional p-spline method to forecast death rates for next year. How can I do it using Proc Transreg procedure in SAS? Thank you.

viollete · ‎05-25-2018

Do I have to use STRATA option in proc surveyselect? there are more patients who had more than two admissions during time period and for each patients I want to select randomly one.

viollete · ‎05-25-2018

Hi all, I have hospital admission data for a two year period. Example of data is showed below (i just put the variables that is connected with my question): date id 04/05/2012 1 05/07/2012 1 16/07/2012 1 07/12/2013 1 05/08/2012 2 12/10/2012 2 01/05/2012 3 06/05/2012 3 08/06/2012 3 12/10/2012 3 16/11/2012 3 01/01/2013 3 For each patient (id) i need to select the first and the last admission during the time period, and i need randomly select another one from the rest. For example, for the ID=1, first admission would be with date 01/05/2012 and the last admission would be 01/01/2013; how can i randomly select one more admission from the rest? Thank you.

viollete · ‎05-02-2018

Thanks, There is no 0 or missing values; however, I found what was wrong with code (my values were letters not numbers) and I made it work

viollete · ‎05-02-2018

Hi, I have a variable that consists information about diagnosis (6496 different diagnosis). For each diagnosis i want to create a dummy variable and i used this code: DATA b2; set b; ARRAY dummys {*} 3. diag1_1 - diag1_6496; DO i=1 TO 6496; dummys(i) = 0; END; dummys( diag1 ) = 1; RUN; However, I get this error message: Array subscript out of range at line 2087 column 1. Can anyone tel me what is wrong with code? thank you

viollete · ‎08-14-2017

Thanks! Just one more question. I would like to make more like this (would like to ut labels into the graph): http://support.sas.com/kb/24/927.html

viollete · ‎08-08-2017

No. I would like something similar to the image from here: http://www.prescientdigital.com/articles/intranet-articles/the-big-deal-about-portals

Online Status	Offline
Date Last Visited	‎09-13-2022 07:31 AM

Bubble chart timeline (Marker Distribution chart)

how to plot observed and predicted values with confidence intervals ov...

Cluster analysis in SAS

leave one out cross validation

How to extract observations who have information for each month

Re: How to determine the week of the year and change the start of the ...

Re: How to determine the week of the year and change the start of the ...

How to determine the week of the year and change the start of the week...

How to do forecast using Proc Transreg (pspline option)?

Re: How to select randomly observation from each 'groups'

Re: Import text file into SAS

Bubble chart timeline (Marker Distribution chart)

how to plot observed and predicted values with confidence intervals ov...

Cluster analysis in SAS

leave one out cross validation

How to extract observations who have information for each month

Re: How to determine the week of the year and change the start of the ...

Re: How to determine the week of the year and change the start of the ...

How to determine the week of the year and change the start of the week...

How to do forecast using Proc Transreg (pspline option)?

Re: How to select randomly observation from each 'groups'

How to select randomly observation from each 'groups'

Re: how to create dummy variable from the variable that has a lot diff...

how to create dummy variable from the variable that has a lot differen...

Re: Quadrant graph

Re: Quadrant graph