Have you tried using excelxp-tagset instead of html? [pre]ods tagstes.excelxp file="..."; proc report ... run; proc report ... run; ods tagsets.excelxp close;[/pre] Some examples are explained on http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#manual ... View more

proc copy can do this, just have a look at the online documentation. http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000085782.htm ... View more

The problem can be solved by using a do-loop containing an output-statement. [pre]data NewData; set OldData; length i 8; drop i; do i = 1 to 100; output; end; run;[/pre] ... View more

If SAS is installed on your pc go to the installation folder (c:\program files\sas\sas 9.1) and open the file "sasv9.cfg". Find the line starting with -WORK and edit it. ... View more

It seems that in 9.13 the dbms-type Excel does not support options for defining the first data row. If you know how many rows to read you can use the range options, or switch to dbms=xls and use startrow=. The online docs contain a full description of all available options for the various dbms-types: http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000312413.htm ... View more

Reading the online documentation for the transwrd function I found two import sentences: "If the TRANWRD function returns a value to a variable that has not yet been assigned a length, by default the variable is assigned a length of 200." and "The value that the TRANWRD function returns has a default length of 200. You can use the LENGTH statement, before calling TRANWRD, to change the length of the value." ... View more

Open the csv-file with a normal text editor, excel is converting the numbers, not sas. ... View more

You can use proc sql and sashelp.vcolumn to get the number of transposed columns, in fact you get the number of columns starting with 'Col'. The following code creates a global macro-variable maxColumns, afterwards the variable is used to create an array statement. The code is untested. [pre]proc sql noprint; select count(*) into :maxColumns from sashelp.vcolumn where lowcase(libname) = 'your_lib' and lowcase(memname) = 'your_dataset' and name like 'Col%' ; quit;[/pre] [pre]data _null_; set dataset; array cols{&maxColumns} col1-col&maxColumns; do i=1 to &maxColumns by 1; put cols{i}; end; run;[/pre] ... View more

Have a look at the options for the excelxp tagset. Setting SHEET_INTERVAL to PROC and executing the three proc-steps within one ods-statement should create the requested layout. ... View more

The users must have the SAS-ActiveX-Control installed on their computer. ... View more

Have a look at the online documentation, everything you need is there. Some ideas: use a data-step to read the raw-data. In that data-step use an additional length-statement to define the four variables base and wk1-wk4. Use the output statement to create multiple records for each line read from the raw-data-file. You can shorten your code by using an array, but the problem can be solved without it. ... View more

> Exactly right.....how to do that? Hardly possible as long as you do not have the text in the data table. You could create an association table in Access mapping B1 to the appropriate text, that table can be used to create label-statements in sas. ... View more

Right click on the dataset in the project explorer, and select Send to > Excel. ... View more

Can you share your proc transpose code and some rows of the original dataset. Under normal cirumstances proc transpose does not create duplicates. ... View more

Maybe the paper "Beyond the Basics: Advanced PROC REPORT Tips and Tricks" has the answer to your question. It can be found at http://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf ... View more