how to output proc sql result to dataset or csv?

[magicdj]

SAS Help Center: Counting Duplicate Rows in a Table

in this link, it shows result for PROC SQL Output for Counting Duplicates. i want to save it to dataset or csv.

not sure how to do that. thanks.

[ballardw · Accepted solution]

To make a data set you preface the Select statement with:

Create table <datasetname> as

Then use Proc Export or data step code to write CSV.

---

@magicdj wrote:

SAS Help Center: Counting Duplicate Rows in a Table

in this link, it shows result for PROC SQL Output for Counting Duplicates. i want to save it to dataset or csv.

not sure how to do that. thanks.

---