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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.