Help using Base SAS procedures

How do i merge 2 col

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 114
Accepted Solution

How do i merge 2 col

I have
Data table1;
Set table1;
Nane=cat (" ",of handler id);
Run;
Only handler is created

Accepted Solutions
Solution
‎10-19-2017 10:53 AM
Super User
Posts: 13,498

Re: How do i merge 2 col

example input data and expected output.

 

is ID a variable? Perhaps you wanted cat(" ",handler, id)

 

Otherwise you're going to have to provide some details of what your data is currently and what you expect the output to look like.

 

If you want a space between variables then you likely want the CATX function, not CAT.

 

View solution in original post


All Replies
Solution
‎10-19-2017 10:53 AM
Super User
Posts: 13,498

Re: How do i merge 2 col

example input data and expected output.

 

is ID a variable? Perhaps you wanted cat(" ",handler, id)

 

Otherwise you're going to have to provide some details of what your data is currently and what you expect the output to look like.

 

If you want a space between variables then you likely want the CATX function, not CAT.

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 112 views
  • 0 likes
  • 2 in conversation