Dear SASeers I am trying to generate a table using Proc Report and it has to look this: Using the code below I am getting No/Yes below each other and not across. I could get the exact thing using Proc Tabulate but not with Report. My code is: proc report data=clin1.history nowd  headline ; column smoking N alcohol N; define smoking / n 'Smoking' group width=5; define smoking / across group width=3; /*define n / width=5 ;*/ define alcohol / n 'Alcohol'group width=5; define alcohol / group width=3; /*define n / width=5 ;*/ format smoking alcohol $ynfmt.; run;   Smoking Alcohol No Yes No Yes 4 16 17 3 Thanks in advance hnam ... View more

I am wanting to extract information from a list of about 5000 observations. They are all in text and currently downloaded into excel sheets. Here are few examples of them: 1. 20% PEG4000, 200mM Sodiumchloride, 50mM MES, 0.3% dioxane, pH 6.0, VAPOR DIFFUSION, HANGING DROP, temperature 310K 2. PEG3350, LiCl, Tris, pH 9.0, VAPOR DIFFUSION, HANGING DROP, temperature 295.0K 3. PEG3350, MgOAc, Na Cacodylate, TCEP, pH 6.9, VAPOR DIFFUSION, SITTING DROP, temperature 280K 4. CRYSTALLISED FROM HANGING DROP WHICH ALSO CONTAINED 50MM Potassiumphosphate, 5MM DTT AND 30% SATURATED AMMONIUMSULFATE, PH 7.0. THE WELL SOLUTION WAS 45% SATURATED AMMONIUMSULFATE., vapor diffusion - hanging drop I wanted to extract the concentrations of individual chemcals from the lists like 20%PEG4000, 200 mM Sodiumchloride, 50 mM MES as different variables(firt three examples) and 45% saturated ammoniumsulfate and 50MM Potassiumphosphate (I find this more challenging). Could anyone provide some inights. Thanks in advance Hari ... View more

Hi All I am trying to plot the mean of ser creatinine levels (64 obs) against different time points. I calculated the mean and then plotted it (the code may be lenghty). But on the x-axis the graph is generating in the order day15 day180 day3  day30 day360 day7 day720 day90 instead of day 3 through day720.  Could someone please take a look and help me resolve this: Thanks in advance. Hari proc means data=tab4b mean; var day3 day7 day15 day30 day90 day180 day360 day720; output out=tab4c; run; data tab4c; set c(firstobs=4 obs=4); drop _type_ _freq_ _stat_; /*avg=mean(day3, day7, day15);*/ run; proc transpose data=c out= tab4d; run; data tab4e; set tab4d(firstobs=3 obs=10); keep day col4; label col4=mean; day=put(_name_, 8.); run; proc gplot data=tab4e; plot col4*day; symbol value=circle color=red interpol=spline; run; quit; ... View more

Hello, I have two questions about Proc Tabulate: 1. I wanted to remove a field from the list since that is not needed in the output. Is it possible? 2.Also how do I align the listings under a specific variable in the middle of the table? Could someone please send the keyword/code to do so. Thanks in advance. Hari ... View more

This may be easy, but I could not find a solution for this.  This may be very easy, but I am trying to find a solution to generate a table like Label N Mean Std Dev No of Cigars Smoked No of Years Smoked No of Drinks per week I used a code as below: title 'Table 3. Analysis of Smoking History and Alcohol Consumption'; proc tabulate data=tab3v1; var smkyncig smkyyears alcyndpw; table smkyncig='No of Cigars Smoked'*(n mean stddev) smkyyears='No of Years Smoked'*(n mean stddev) alcyndpw='No of Drinks Per Week'*(n mean stddev) ; run; But I am getting a horizontal output. I wanted to get a vertical one. Thanks in advance Hari ... View more