how to output proc sql result to dataset or csv?

magicdj — Mon, 18 Apr 2022 16:57:13 GMT

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.

Re: how to output proc sql result to dataset or csv?

ballardw — Mon, 18 Apr 2022 17:02:13 GMT

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.

topic Re: how to output proc sql result to dataset or csv? in ODS and Base Reporting

how to output proc sql result to dataset or csv?

Re: how to output proc sql result to dataset or csv?