DATA Step, Macro, Functions and more

How to save a value of a variable in an exeternal file

Reply
Contributor
Posts: 58

How to save a value of a variable in an exeternal file


Hi,

I have the following need.

I have a varible XXX and I would save the value of this variable in an external file. If I do something like this:

data _null_;

   file 'outup.txt';

   put XXX;

run;

The file is empty and if I do this

data _null_;

   file 'outup.txt';

   put &XXX;

run;

I get an error. Do there is a way to save the value of a variable in a file?

Many thanks

Respected Advisor
Posts: 4,930

Re: How to save a value of a variable in an exeternal file

If variable XXX comes from a dataset, you should refer to it (i.e. SET MYDATASET; ) . If it is a macro variable, you should assign it to a variable (i.e. XXX="&XXX"; put XXX; ) or use quotes in the put statement (i.e. put "&XXX"; )

PG

PG
SAS Super FREQ
Posts: 8,868

Re: How to save a value of a variable in an exeternal file

Hi: As PG has explained, you must point to a SAS dataset in order to use a variable name in a PUT statement (unless you are creating the variable in your program).

The program below writes the NAME variable from SASHELP.CLASS to a flat file for only the students with an AGE that is GE 15.

cynthia

data _null_;

  set sashelp.class;

  where age ge 15;

  file 'c:\temp\myflatfile.txt';

  put name;

run;

Then if you open MYFLATFILE.TXT with Notepad, you will see the 5 students with ages greater than or equal to 15 in SASHELP.CLASS:

Janet

Mary

Ronald

William

Philip

Ask a Question
Discussion stats
  • 2 replies
  • 191 views
  • 0 likes
  • 3 in conversation