BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SharonO
Calcite | Level 5

How can I display/output/view the temporary variables SAS creates?

 

 

Examples:

by city state zip

 

ouput

city  state zip  first.city last.city first.state last.state first.zip last.zip

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

There are a couple of possibilities, both subject to this "feature":  once the DATA step ends, those variables no longer exist.

 

One possibility:  add PUT statements in the DATA step that write the variables to the log.  Example:

 

if _n_ < 20 then put city  state zip  first.city last.city first.state last.state first.zip last.zip;

 

Another possibility:  copy the variables, and store the copies in the data set.  Example:

 

first_state = first.state;

last_state = last.state;

 

You can examine them after the DATA step is complete.

View solution in original post

2 REPLIES 2
Astounding
PROC Star

There are a couple of possibilities, both subject to this "feature":  once the DATA step ends, those variables no longer exist.

 

One possibility:  add PUT statements in the DATA step that write the variables to the log.  Example:

 

if _n_ < 20 then put city  state zip  first.city last.city first.state last.state first.zip last.zip;

 

Another possibility:  copy the variables, and store the copies in the data set.  Example:

 

first_state = first.state;

last_state = last.state;

 

You can examine them after the DATA step is complete.

data_null__
Jade | Level 19

As a learning exercise you can put the entire PDF and observations into an associative array.

 

http://www.lexjansen.com/pharmasug/2008/cc/CC08.pdf

 

 

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 6169 views
  • 1 like
  • 3 in conversation