Hi!   I need some help trouble shooting a little piece of my code.  I'm getting error, but not sure why...   I need the output to look like mean(std)  or  x.x(x.xx)  --   sord=2; _1=cat(strip(put(mean, 8.1)), ' (' strip(put(std, 10.2))')'); output;     and second, the next output to look like Min,Max  x,x     sord = 4; _1=cat(strip(put(MIN,8.)),", "(put(MAX,8.))); output;   I'm getting syntax errors an probably missing a parenthesis somewhere...but please help!  thx!     ... View more

Hi,   I am doing a char to numeric conversion, but I am getting one note in my log that says:   NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 6232:23   I don't have this many lines or columns in my data set.  I also don't see any character values that would generate this note.  I did a proc freq on all the variables I am converting.  Is there any way to specifically identify which value this is pointing to?  I have no idea what the 6232:23 is (i have 3504 rows and 14 columns).  I know it's not a big deal, but I can't have any conversion notes in my log.   Here is some of code:   length results $100.; format range $4.; siresult1=input(siresult,best.); SINORMLO1=input(SINORMLO,best.); SINORMHI1=input(SINORMHI,best.); if siresult1^=. then do; if siresult1< SINORMLO1 then Range='L'; if siresult1>SINORMHI1 then Range='H'; if SINORMLO1<SIRESULT1<SINORMHI1 then Range=''; results=catx(", ",put(siresult1,8.1), range); end; else if siresult1='' then do; results='';   Thank you! ... View more

Hi!  With the help of @PGStats I have this code - which works great.  I need to now add in one more dimension.  I need to calculate the difference between Q1- Visit1 and Q2_Visit2, and THEN get the descriptive statistics of the change.   something like  sum(Q1)[visit2]  -sum(Q1)[visit 1] as change....then all the descriptives would use 'change' (instead of totalscore).   I'm just not sure where to indicate the visit value.  Help is appreciated!!   proc sql; create table sep_004 as select visit, mean (totalscore) as mean, max(totalscore) as max, min(totalscore) as min, std(totalscore) as std, nmiss(totalscore) as nmiss, n(totalscore) as n, ('004') as Study from (select PID, visit, sum(Q1) as totalscore from sep004 group by PID, visit) group by visit; select * from sep_004; quit; ... View more

Hi Everyone,   I fell like I losing sleep on how to get this output set up!  I have a dataset that has possible values of 0/1.  I have multiple possible encounters with the same ID over a single visit (e.g. multiple attempts on a questionnaire during a single visit).  So I need to sum the values by ID and VIsit#  (new variable sum_visits) and then get the means from those sum_visits BY visit#.  I think this can be done with proc tabulate but I can't set it up right.  I keep getting Mean=1 so it isn't summing by ID/VIsit first.  Any help is greatly appreciated!!!   I have data that looks like this   ID Score Visit A 1 1 A 0 1 A 1 1 A 1 1 A 1 2 A 0 2 A 1 2 A 1 2 B 0 1 B 1 1 B 1 1 B 0 1 B 1 2 B 1 2 B 1 2 B 1 2   Would like results that give something like this (but doesn't have to be  set up the way (just an example of my calculations). ID Score Visit Sum_Visits     A 1 1       A 0 1       A 1 1       A 1 1 3     A 1 2       A 0 2       A 1 2       A 1 2 3     B 0 1       B 1 1       B 1 1       B 0 1 2     B 1 2       B 1 2       B 1 2       B 1 2 4                                     Sum Vist 1* ID 5         Sum Visit2 *ID 7         Mean Visit 1 5/2= 2.5         Mean Visit 2 7/2=3.5 ... View more

I'm trying to calculate the change in mean from baseline to each visit (vist1 to vist2; vist1 to visti3; visit1 to visit4...)     I tried this using lag, but results don't seem correct.  It is just using the lag between observations rather than holding visit 1 as the LAG.  Help is appreciated   Starting:   visit mean 1 2.41 2 2.47 3 2.53 4 2.54   want something like this:   visit mean change 1 2.41 . 2 2.47 2.44 3 2.53 2.47 4 2.54 2.48     I started with this code:   data want; set have; lag_mean=lag(mean); change=mean-lag_mean; run; ... View more

Hi all!   If I write this to calculate a percentage in a data step,  where do I write the maxdec=2  so that percent_miss is only 2 decimals?   data gaq_4 (drop=_TYPE_ _FREQ_); set gaq_1 (rename=(_FREQ_=Study_Population)); Percent_Miss=nmiss/Study_Population; run;   Thank you!! ... View more