Hi Reeza,   You're probably right, I'm obviously doing something wrong. I am very new to this. I'm gutted as it's nearly there, but not quite, so my incompetence is clearly causing problems, even given your patience. The entirety of the code I'm using is below and it's generating the attached pdf without any errors, but the months are still appearing as row headers and not column headers, and I'm not sure where/how to insert the noprint to remove the extraneous columns. I've only amended the 'Have' reference to refer to the data source 'WORK.SASExample'.   proc means data= WORK.SASExample nway; class reference date; format date monyy7.; var lifetimecostScore; output out = totals sum=MonthlyScore; run; proc transpose data=totals out=want prefix=Date_; by reference; id date; idlabel date; var MonthlyScore; run;   I'm posting again the probably vain hope that you haven't totally lost patience with my incompetence and might still be willing to help, as I'm doing some analysis for work.   Thanks,   Barney ... View more

I wanted it to refer to the data that I've extracted as the source data may well change, and I would like the programme to run over the dynamic data ... View more

I've just been replacing want with the data reference. The full code I've been using is below.     proc means data=WORK.SASExample nway; class reference date; format date monyy7.; var lifetimecostScore; output out = totals sum=MonthlyScore; run; proc transpose data=totals out=want prefix=Date_; by reference; id date; idlabel date; var MonthlyScore; run; ... View more

Thanks so much for your help, I really appreciate it. There are no more errors and it runs. However the output hasn;t transposed correctly - ie the Dates are still coming p as row labels rather than column headers. Also, I only need the one result (ie not N Obs, N, Std Dev, Minimum, Maximum). See attached pdf for output ... View more

Thanks  - nearly there I think - there's another error message copied below. Do I need to sort it between steps?   ERROR: Data set WORK.TOTALS is not sorted in ascending sequence. The current BY group has Reference = CS-YES-ECO215-SWP and the next BY        group has Reference= CS-ACWhyte-ECO210-SWP. ... View more

Thanks Reeza. I'm getting a syntax error after the transpose step   proc transpose Completion_Date=totals out=want prefix=Date_;                           _______________                           22                           76 ERROR 22-322: Syntax error, expecting one of the following: ;, DATA, DELIM, DELIMITER, LABEL, LET, NAME, OUT, PREFIX, SUFFIX. ERROR 76-322: Syntax error, statement will be ignored. ... View more

I'm summing the data as well - there are more than one instances of scores for each reference. It's not just s straight transpose ... View more

Hi,   See attached. I've included an 'as is' and a 'to be' in separate tabs   Thanks,   Barney ... View more

Hi, Thanks for your help with my SAS query. I'm happy with using either point and click or programming, whatever works. Are you able to help with some code? Thanks, Barney ... View more

Great - thank you. Is this through SAS Enterprise Guide? I am very new to SAS EG and even the tutorial seems to assume knowledge/experience I don't have. Sorry ... View more