About Jedrzej

Jedrzej · ‎01-12-2023

Hi, i would like to change the default folder directory while invoking a new sas session. Now i have to change it everytime in tools->options-> change current foder... Should I change something in sas confg file ? Thank you for your help.

Jedrzej · ‎10-28-2022

one, sorry mistype

Jedrzej · ‎10-28-2022

Hi, I would like to split my variable in a way that if there are more words then 10 it would extract all words>10 into a new variable and the old one will have only ten words. example data have; infile cards truncover; input str $char150.; cards; New Year Copenhagen is the Capital of Denmark Jensen is a´defunct British manufacturer of sports cars Another line Paris is a capital of France ; run; and the output should be str(New Year Copenhagen is the Capital of Denmark Jensen is) str1(is a´defunct British manufacturer of sports cars Another line) str2(Paris is a capital of France)

Jedrzej · ‎10-12-2022

Hi, im trying to create proc report (RTF) and text of one variable is so long that it's overlaping my footnotes. do you have and idea how to control the size of the column that will fit in one page or continues text on another.? I cant make this variable wider define var1 display style(header)={just=center} center flow style(column)=[just=l width = 16% asis = on] style(header)=[just=l asis=on]; regards, jedrzej

Jedrzej · ‎02-15-2022

Hi I have to do a boxplot with category "Visits". I want to connect boxes of those visits by mean except one visit "End Of Treatment". So it should be like all visits=boxes are connected by line (mean) and there is one box=EOT that is not. Is it possible ? proc sgplot data=lb3 dattrmap=attrmap ; vbox result/category=visit connect=mean FILLATTRS=red attrid=hybrid meanattrs=(symbol=circle ) whiskerattrs=(pattern=mediumdash); xaxis label="Timepoint" ; Yaxis values=(0 to 30 by 2) ; run;

Jedrzej · ‎01-19-2022

Hi, to the existing table like this: Grade Arm A Arm B System organ class Overall 10 (100%) 20 (100%) Grade 2 7 (70%) 10 (50%) Grade 4 3 (30%) 10 (50%) i would like to add more subcategories for grade (Grade 1, Grade 3) and show for Arm A, Arm B 0 (0) as their values. The table should look like this Grade Arm A Arm B System organ class Overall 10 (100%) 20 (100%) Grade 1 0 (0) 0 (0) Grade 2 7 (70%) 10 (50%) Grade 3 0 (0) 0 (0) Grade 4 3 (30%) 10 (50%) is there an easy way how to do it ? Thank you in advance.

Jedrzej · ‎10-05-2021

scatter is good but the dot is connected to the graph line (probably because I use the same variable for x=vis). when I create two separate variables for EOT (x and y) it is good but the dot appears at the begging of the graph and i want it at the end.

Jedrzej · ‎10-05-2021

Hi, I'm a begginer at sas graph programming and I need to create a line graph with xaxis that shows patient visits and yaxis that show lab test results. Visit consits of 1st,8th and 15th visit and for one patient visit=end of treatment (EOT). I need to present this EOT at the end of xaxis as a dot and not connected to line graph. my code proc sgplot data=lb; series x=vis y=result / group=usubjid grouplc=armcd break transparency=0.7 lineattrs=(pattern=solid); xaxis label="Timepoint" ; Yaxis values=(0 to 30 by 2) label="arm"; keylegend / type=linecolor title=""; run;

Jedrzej · ‎04-16-2021

hmm that doesn;t solve this problem

Jedrzej · ‎04-16-2021

you mean this ? data test2; length total2 $7; set test; total=numb/&calc*100; total2=PUT (total,4.2); run; doesn't work, still w.d is too small in log...

Jedrzej · ‎04-16-2021

hi, i want to eliminate w.d note from these calculations data test1; calc=77; call symputx('calc',calc); run; data test; input numb; datalines; 77 58 ; data test2; set test; total=numb/&calc*100; total2=PUT (total,4.1); run; i've tried to round total data test2; set test; total=round(numb/&calc*100,4.1); total2=PUT (total,4.1); run; and it doesnt print me w.d but... i have wrong results, sas shows me that (77/77*100,4.1)=98.4 instead of 100. I don't understand this. thank you for your help

Jedrzej · ‎03-16-2021

hi, i want to change this table that will make one variable with aebodsys as main category and aedecod as subcategories. like that VAR Cardiac disorder atrial flutter palpitations Tachycardia Cardiac failrue Psychiatric disorders Delirium Gastrointestinal disorders Constipation data AE; input USUBJID $ 1-3 AEBODSYS $ 5-30 AEDECOD $ 32-49 ; datalines; 101 Cardiac disorders Atrial flutter 101 Gastrointestinal disorders Constipation 102 Cardiac disorders Cardiac failure 102 Psychiatric disorders Delirium 103 Cardiac disorders Palpitations 103 Cardiac disorders Palpitations 103 Cardiac disorders Tachycardia run; thank you for your help

Jedrzej · ‎03-12-2021

yes, it's a concatenated char variable, so maybe I should fixed it in a dataset before ? i'm not good with proc report

Jedrzej · ‎03-12-2021

hi, i want allign my data to get proper proc report output data have so every row in this case shoud be alligned to 217/336 (64.6%) thank you for your help

Jedrzej · ‎03-11-2021

Hi I have two variables with descriptive statistics and I need to calculate the difference between them _name_ var1 var2 var_want mean(sd) 76.4(11.39) 77.2(8.63) min,max 40.0,113.0 50.0,106.0 i've tried this,example if _name_="min,max" then var_want=substr(var,1,2)-substr(var2,1,2)||","||substr(var,6,3)-substr(var2,6,3) but it doesn't work cause 40-50=-10 and sas cannot convert it to char (invalid numeric data) is there a simple way to calculate the difference between var1 and var2 ?

Online Status	Offline
Date Last Visited	‎01-26-2023 09:16 AM

changing default folder directory

Re: How to extract string of words into a new variable

How to extract string of words into a new variable

column in proc report overlaps the footnote

Connect boxes in proc sgplot except one

Adding subcategories to the table

Re: Add a dot to a line graph xaxis value

Add a dot to a line graph xaxis value

Re: w.d format was too small

Re: w.d format was too small

Re: allign parentheses, decimal points in proc report

Re: mark flag based on date difference

Re: Outputing log into file and log window

Re: output from iteration

Re: output from iteration

assign the same value by group

changing default folder directory

Re: How to extract string of words into a new variable

How to extract string of words into a new variable

column in proc report overlaps the footnote

Connect boxes in proc sgplot except one

Adding subcategories to the table

Re: Add a dot to a line graph xaxis value

Add a dot to a line graph xaxis value

Re: w.d format was too small

Re: w.d format was too small

w.d format was too small

summarize table

Re: allign parentheses, decimal points in proc report

allign parentheses, decimal points in proc report

calculate difference between character numbers