I have a dataset with the question, answer coded in numeric and its categorical value. I have a lot of questions and answer choices, so I prefer not copying and pasting everything.Is there an easier way to create formats based on existing dataset like below?     data have; input id question $ 5. ansN ansC $ 20.; cards; 1 Q1 1 Agree 2 Q1 1 Agree 3 Q1 2 Disagree 4 Q1 2 Disagree 5 Q1 3 Refuse to Answer 1 Q2 2 BBBBBBB 2 Q2 1 AAAAAAAA 3 Q2 1 AAAAAAAA 4 Q2 3 CCCCCCCCCCC 5 Q2 3 CCCCCCCCCCC ;   ... View more

This is my SAS code, basically I did some analysis and generated a final table.   proc format; value grouplabel 1="Overall" 2="Scrolling vs. Non-Scrolling" 3="BYOD vs Non-Scrolling" 4="Intelligent vs Non-intelligent"; run; data have; length score $ 50.; input score grouplabel1 estcirel ProbF; cards; score1 1 0.79 . score1 2 0.80 0.45 score1 3 0.75 0.98 score1 4 0.78 0.45 score2 1 0.79 . score2 2 0.80 0.45 score2 3 0.75 0.98 score2 4 0.78 0.45 ; run; data have; set have; format grouplabel1 grouplabel.; run; proc report data=have; column score grouplabel1,(estcirel ProbF); define score/group "Score"; define grouplabel1/across " " order=INTERNAL; run; This is the output   If you look at the table above, the overall has 2 colmns. I want it to only show the estcriel colmn and the the probf column is all missing (no p-value as there is no comparisons). So it is not useful to have that column in my final table.  I am fairly new to proc report, how do I structure the dataset and set up my proc report  for the overall group to just show the estcriel while the other groupings to show both columns (so other grouping is correct)?   Want:      ... View more

    I am having trouble to figure out how to compute these two Variables (Want: Recovered and starting recovery day)   HEre is a sample Data. (ID=3 Day 1 should be N and not M). Yes/No is coded as 1/0 with a format.                      So basically, a subject is considered recovered  if they it's a Y from one point to the end of the study (Day 45). So in the example above, ID=1 recovered started on the 3rd day and ID=2 on the 4th).  While ID=3 didn't recover as  they didn't recover day 5 and 6. THere are different patterns, basically, where subjects can recover and unrecover.   definition of recovery:  Yes at one timepoint and Yes at all future time points from that first time point examined (so up to Day 45).   I have been trying to think of an easy way to code this, however, the only way I can think about it check every time frame for Y (e.g. day 44-45, then day 43-45.. then 42-45 etc.)   I am sure there is an easier way to do this, but I can't figure it out. I am hoping someone here can help me.    The next part, What is the starting time point for recovery?          data have; input ID Day1 Day2 Day3 Day4 Day5 Day6; datalines; 1 0 0 1 1 1 1 2 0 1 0 1 1 1 3 0 1 1 1 0 0 ;     ... View more

  Here is the code data Roc_1_01a; set Roc_1_01; ROC_01=scan(_id,1," "); ROC_01a=ROC_01*1; format ROC_01a 8.2; ROC_00=input(ROC_01,8.2); run;     So when I just times the character variable by 1, it is correct. I was taught not to do it that way for some reason that I can't remember.   I was told to use the input statement, which I have done. However, the input statement didn't yield the correct results.   this is my dataset. If you look at the 3rd row, you see the character variable -15. When I use the input statement, it converts it to -0.15 instead of -15. How do I write the code using the input statement to make it appear correct?       ... View more

 So basically i have a value (0.126) that I outputted using the out statement from a procedure. It's outputted into a dataset and looks pretty much like this right now:   data have; infile datalines dsd; input value label ~ $ 200. ; datalines; 0.126,XXXX ; run;    Basically I want to use that 0.126 as a macro value, basically this is what I want:   %let value=0.126; title "Blah blah blah value=&value"; ods rtf prepage="Blah blah blah value=&value";   Wanted Output from ODS text: Blah blah blah value=0.126 The disconnect right now, I am unsure how to export the 0.126 into the macro variable value from a dataset, so I can use it in the ODS text above.   I have to do this multiple times for a lot of analyses, so I am trying to build this code somehow into my current macro.. I am unsure if it is possible? ... View more

This is my code. I am recoding a bunch of variables (200 to be exact). I am using this code, because I was hoping to use the vlabel function, but sadly vlabel doesn't support labels with spaces and "-" in them.. it only supports numbers,digits and underscores. I am trying to figure out the easiest way to add the labels to my recoded variables. Can someone suggest something?   So in the example below. the label for olditem6_3_5 is "In the last 4 weeks, I ate apples."   Thus I want the label for item6_3_5 to be ""In the last 4 weeks, I ate apples. (recoded).    My current code: %macro recode (indata=,var=); DATA _null_; SET &indata; array vars(*) &var; DO i=1 TO dim(vars); call symput("mvNAME"||strip(i),strip(vname(vars(i)))); END; call symput("mvNB",strip(dim(vars))); RUN; %DO b=1 %TO &mvNB; data &indata; set &indata; array oldtest(*) old&&mvNAME&b; array newtest(*) &&mvNAME&b; call symput("mvLAB"||strip(i),strip(vname(old&&mvNAME&b)); DO z=1 TO dim(oldtest); newtest(z)=6-oldtest(z); END; label &&mvNAME&b="&mvLAB (recoded)"; RUN; %end; %mend recode; %recode (indata=temp,var=item6_3_5);     ... View more

So this is my dataset from using the ODS output with proc ttest:   This is my code so far for proc report   options orientation=portrait; ods rtf file="H:\temp.rtf" startpage=no nokeepn style=&mvSTYLE %wordstyle ; proc report data=table3way headskip nowindows split='~' style(report)={font_size=9pt just=left cellpadding=2pt} style(header)={just=center font_weight=bold font_size=9pt background=CXE0E0E0} style(column)={cellheight=13pt font_size=9pt asis=on protectspecialchars=on} style(lines)={font_size=8pt asis=on}; column dmtype Durationbi Num cMean cSTD LowerCL UpperCL Probt; define dmtype/group style(column)=[vjust=middle just=left]; define Durationbi /display; define num/display; define cMean/display format=9.2; define cSTD/display format=9.2; define LowerCL/display format=9.2; define UpperCL/display format=9.2; define Probt/group style(column)=[vjust=middle just=left]; run; footnote;title2; ods rtf close;   And this is the RTF table I have based on the proc report above   So I want the Type of Diabetes cell and p-value cell merged and vertically centered, so there is no blank cell under it, basically to look like this:   How do I do this? I did add the Vjust=middle option for the two variables... But I guess I have to add in another line of code somewhere to merge the cells? Can someone please help me?   I did try looking at the solution outlined here, but I don't have missing data (Someone suggested doing "If not missing(pvalue) then _pvalue=pvalue; else pvalue=_pvalue; " I did try it with the retain function, but it didn't do anything since I didn't have missing data., so it pretty much copying the variable   Thanks!!     Edit: I also tried adding the SPANROW option on the Proc report statment and order=data option on the define statement as outlined here. And it didn't work either. I am on SAS 9.4 and the option wasn't blue so unsure if it was removed between 9.2 to 9.4. ... View more