Is there any example or reference to the documents to access SAS datasets in HTML and CSS coding to fetch and display the value from SAS dataset to the prompts in web page? ... View more

I've the following code to select distinct records from the database..  Unfortunately, I spot-checked some data in the resultant table and discovered that there were duplicates. But it would be ideal to have no duplicates. The duplicates that I spotted were where the one of the field (class) appears to be blank. I'm querying in Snowflake from SAS.   create table lib.&table.as select * from connection to database ( select distinct &variables from &source_table ) ; The total row count for the table using the `proc sql select distinct` method is 31091. I ran the `proc summary` code for that specific type, and it had a total row count of 31083. All 8 of those ‘extra’ rows in the `proc sql` table are the duplicate records where the class field appears to be blank. I suspect there are some embedded control characters or something that are making the `select distinct` query identify records as unique. Any help to resolve the issue to create the table without any duplicates? ... View more