About Baraso

Baraso · ‎03-13-2024

Hi everyone, I explain what I want to do using the simplified table below. I would like to total the number of patients for each age group across all sites for each category of region. Taking table B from table A as an example. Any guidance on how to do it would be greatly appreciated. Thank you. A A: SiteID Age_group Region Num_Patients Site01 18_25 NA 500 Site01 18_25 MW 703 Site01 18_25 Miss 500 Site01 18_25 NE 507 Site01 18_25 Other 500 Site01 18_25 S 1239 Site01 18_25 W 541 Site01 26_44 NA 502 Site01 26_44 MW 1087 Site01 26_44 Miss 500 Site01 26_44 NE 604 Site01 26_44 Other 500 Site01 26_44 S 2763 Site01 26_44 W 685 Site02 18_25 NA 533 Site02 18_25 MW 4278 Site02 18_25 Miss 500 Site02 18_25 NE 1964 Site02 18_25 Other 500 Site02 18_25 S 7340 Site02 18_25 W 3242 Site02 26_44 NA 566 Site02 26_44 MW 5920 Site02 26_44 Miss 500 Site02 26_44 NE 2512 Site02 26_44 Other 501 Site02 26_44 S 11502 Site02 26_44 W 5065 B B: SiteID Age_group Region Num_Patients ALL 18_25 NA 1033 ALL 18_25 MW 4981 ALL 18_25 Miss 1000 ALL 18_25 NE 2471 ALL 18_25 Other 1000 ALL 18_25 S 8579 ALL 18_25 W 3783 ALL 26_44 NA 1068 ALL 26_44 MW 7007 ALL 26_44 Miss 1000 ALL 26_44 NE 3116 ALL 26_44 Other 1001 ALL 26_44 S 14265 ALL 26_44 W 5750

Baraso · ‎09-30-2021

Thank you Ballardw. I was able to import the text data to SAS.

Baraso · ‎09-24-2021

Hi, I've received a huge zip dataset (zip file .gz). I was able to unzip it somehow, and I am trying to import (read) it in SAS. The dataset is too big to open and read on Notepad. So, I have to make a guess about the number of variables and their delimiter. I have tried all possible delimiters for importing in SAS, but the imported data does not look fine. The first two lines of data look as below. Claim_ID_MS_MDC_Cd_MSDRG_Cd_Serv 1873420141|||PRP0|||||| I am wondering if there is any way to import data in SAS when you don't have any idea how data look like. Thanks.

Baraso · ‎10-30-2019

Thank you so much Jag. This answer is exactly what I was looking for. I appreciate your help. Best, Bahareh

Baraso · ‎10-30-2019

I have the data below. data have ; input id month enrol_period disenrollment reenrollment event case ; cards ; 1 0 1 0 0 0 1 1 1 1 0 0 0 1 1 2 1 0 0 0 1 1 3 1 0 0 0 1 1 4 -1 1 0 0 1 1 5 -1 0 0 0 1 1 6 -1 0 0 0 1 1 7 2 0 1 0 1 1 8 2 0 0 0 1 1 9 2 0 0 0 1 1 10 2 0 0 1 1 2 0 1 0 0 0 0 2 1 1 0 0 0 0 2 2 1 0 0 0 0 2 3 1 0 0 0 0 2 4 1 0 0 0 0 2 5 1 0 0 0 0 2 6 1 0 0 0 0 2 7 1 0 0 0 0 2 8 1 0 0 0 0 2 9 1 0 0 0 0 2 10 1 0 0 0 0 ; run; I want to have the data below. The case status has been reset to 0, during the months which period is -1 and before. Multiple disenrollment and reenrollment can happen during follow-up. Event is one of the end-points of the study. If event happens, I want to consider it only for the last period of enrollment, not entire follow-up. data want ; input id month enrol_period disenrollment reenrollment event case ; cards ; 1 0 1 0 0 0 0 1 1 1 0 0 0 0 1 2 1 0 0 0 0 1 3 1 0 0 0 0 1 4 -1 1 0 0 0 1 5 -1 0 0 0 0 1 6 -1 0 0 0 0 1 7 2 0 1 0 1 1 8 2 0 0 0 1 1 9 2 0 0 0 1 1 10 2 0 0 1 1 2 0 1 0 0 0 0 2 1 1 0 0 0 0 2 2 1 0 0 0 0 2 3 1 0 0 0 0 2 4 1 0 0 0 0 2 5 1 0 0 0 0 2 6 1 0 0 0 0 2 7 1 0 0 0 0 2 8 1 0 0 0 0 2 9 1 0 0 0 0 2 10 1 0 0 0 0 ; run; Any ideas to resolve this are appreciated. Thanks.

Baraso · ‎06-18-2019

Thank you. Actually, I've already modified my codes several times for different options, but nothing happens. The default colour pattern do not change at all.

Baraso · ‎06-17-2019

Hi, I use the code below to create a heatmap based on percentage of missing values for my variables in each year. it seems like there is a default range of colors (red and blue) which does not change at all. I changed the colors specified in rangecolormodel, but no change happens. Can you please help me to solve this. Thank you. proc template; define statgraph heatmap; begingraph / designheight=400 designwidth=1200 pad=1; entrytitle 'Percentage of missing values 3mo carry forward, full FU'; rangeattrmap name="rmap"; range min - max / rangecolormodel=(white yellow); endrangeattrmap; rangeattrvar attrmap="rmap" var=Percentages_missing attrvar=pColor; layout overlay / yaxisopts=(offsetmin=0.1 offsetmax=0.1 display=(ticks tickvalues line) tickvalueattrs=(size=6)) xaxisopts=(offsetmin=0.1 offsetmax=0.1 display=(ticks tickvalues line) tickvalueattrs=(size=6) discreteopts=(tickvaluefitpolicy=stagger)); heatmapparm x=year y=Variables colorresponse=Percentages_missing / name="heatmap"; scatterplot x=year y=Variables / markercharacter=Percentages_missing markercharacterattrs=(size=4); continuouslegend "heatmap" / valueattrs=(size=6) ; endlayout; endgraph; end; run; proc sgrender data=out_graph template=heatmap; run;

Online Status	Offline
Date Last Visited	‎03-13-2024 07:08 PM

Long format data- sum numbers across several variables

Re: importing text file with unknown delimiter

importing text file with unknown delimiter

Re: carrying backward values in longitudinal data

carrying backward values in longitudinal data

Re: The colors do not change in heatmap

The colors do not change in heatmap

Re: importing text file with unknown delimiter

Re: importing text file with unknown delimiter

Re: carrying backward values in longitudinal data

Long format data- sum numbers across several variables

Re: importing text file with unknown delimiter

importing text file with unknown delimiter

Re: carrying backward values in longitudinal data

carrying backward values in longitudinal data

Re: The colors do not change in heatmap

The colors do not change in heatmap