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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: