The SAS Output Delivery System and reporting techniques

Row data to column data in table.editor

Reply
Super Contributor
Posts: 343

Row data to column data in table.editor

If I have a code like below, what is the option to show the data next to each other instead to below each other?

 

%Let MYNAME = _MY_NAME_;

Data Example;
  Do N = "A", "B", "C";
     Val1 = Rannor(1);
	 Val2 = Rannor(1);
	 Output;
  End;
Run;

Proc Export Data=Example Outfile="C:\users\&MYNAME.\desktop\ptex." DBMS=XLSX Replace;
  Sheet="Data";
Run;

ODS Tagsets.TableEditor File="C:\\users\\&MYNAME.\\desktop\\maker.js"
Options 
(
Output_Type="script"
Update_Target="C:\\users\\&MYNAME.\\desktop\\ptex.xlsx"
Sheet_Name="Data"
Pivotrow="N"
Pivotdata="Val1, Val2"
Quit = "NO"
);

Data _NULL_;
  File Print;
  Put "Test";
Run;

ODS Tagsets.TableEditor Close;
x "C:\\users\\&MYNAME.\\desktop\\maker.js";

 

 

Thx&kind regards

Ask a Question
Discussion stats
  • 0 replies
  • 251 views
  • 0 likes
  • 1 in conversation