10-22-2014 08:13 PM
I have a few data sets that I have merged together and manipulated with PROC REPORT. I am struggling with two things
Any help/hints would be great!
10-22-2014 10:16 PM
When you say that you "need to export this data into notepad as a txt file", do you mean you need to export ONLY the data or you need a PROC REPORT type report in a TEXT file. You can simply use ODS LISTING FILE= if you want the PROC REPORT output in Notepad/TXT file, however, this will send your SAS titles to the TXT file too. Something like the program below. Otherwise, you could do something with a DATA Step program.
ods _all_ close;
ods listing file='c:\temp\myreport.txt';
options nodate number pageno=1;
proc report data=sashelp.class ls=80 ps=60;
title 'This is the Title';
column name sex age height weight;
define name / order;
define sex / display f=$3.;
define age / display;
define height / display;
define weight / display;
ods listing close;
Need further help from the community? Please ask a new question.