Warm tip: This article is reproduced from stackoverflow.com, please click
sas sql

put result in 1 cell, not in many

发布于 2020-04-16 12:05:11

I am using a basic select statement to pull some accounts. I need to output those accounts in a single cell, and not rows of accounts.

Questioner
Eyal Marom
Viewed
31
分享
Niqua 2020-02-05 20:18 
PROC SQL;
   CREATE TABLE WORK.WANT AS 
   SELECT /* Concatenated */
                     (cats(t1.COLUMN_1, ', ', t1.COLUMN_2)) AS ConcatenatedColumns
      FROM WORK.HAVE t1;
QUIT;

I guess you need to have concatenated results from some table?

cats() function can be used to concat values of different columns, with removed leading and trailing blanks.

Niqua 2020-02-05 20:21:09

please note output columns will be in a string format

Related issues

1
Query is possibly slow?
2
Simple Sql Role query issue
3
Group by query with rollup
4
How to include a PHP variable inside a MySQL statement
5
Getting empty rows from "SELECT ALL" query in PostgreSQL
6
MySQL pivot table using java
7
Implement smart search by text field in database
8
How to speed up count(distinct) with Between clause in MySQL
9
how to perform sql query MIN/MAX FILTER
10
Dynamic pivot in oracle sql