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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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: