topic Re: Export to notepad in SAS Procedures

Export to notepad

Becca — Thu, 23 Oct 2014 00:13:13 GMT

I have a few data sets that I have merged together and manipulated with PROC REPORT. I am struggling with two things

I can't seem to figure out how to get a 0 input for missing/blank data
I need to export this data into notepad as a txt file

Any help/hints would be great!

Thanks

Re: Export to notepad

SASKiwi — Thu, 23 Oct 2014 01:03:23 GMT

options missing = '0'; ?

Re: Export to notepad

Becca — Thu, 23 Oct 2014 01:17:59 GMT

Thanks! That worked like a charm!

Re: Export to notepad

Cynthia_sas — Thu, 23 Oct 2014 02:16:13 GMT

Hi:

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.

Cynthia

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;

run;

ods listing close;