BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Dear all,

My colleague asks me to translate proc sort nodupkey to ANSI SQL (not proc SQL that can arrange some special PDVs).

Suppose that the source table has 10 variables and we would like to deduplicate 2 vars.

proc sort data=source out=dest nodupkey;
by var1 var2;
run;

Would you please translate this statement to ANSI SQL?
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
This is not really an ODS question. However, these papers may help in explaining more about PROC SORT and NODUPKEY: [pre]
http://www2.sas.com/proceedings/sugi30/037-30.pdf

http://www.lexjansen.com/pharmasug/2000/techtech/tt12.pdf [/pre]

If the papers do not help you resolve your requirement, then Tech Support is probably your best bet. To find out how to contact Tech Support, go to [pre]
http://support.sas.com/techsup/contact/index.html [/pre]

Good luck!
cynthia
deleted_user
Not applicable
Thank you Cynthia,

I will follow up with technical support team.
But, is it possible to open discussion forum about Base or STAT ?

Other vendors have extensive of discussion websites but SAS doesn't have. Can you recommend me the external website ?

Best regards,
CJr


Message was edited by: CJr at Jan 16, 2007 3:05 AM


Message was edited by: CJr at Jan 16, 2007 3:06 AM
Message was edited by: CJr at Jan 16, 2007 3:07 AM
Cynthia_sas
SAS Super FREQ
In my mind, SQL along with PROC SORT, falls into the category of "SAS programming" more than reporting. Even though I know some folks use SQL for reporting -- I'm more a practitioner of PROC REPORT, PROC TABULATE and DATA step for reporting.

For general SAS programming questions, the SAS on-line documentation is a great place to start. The SAS sample programs are really very good. If you are using SAS Display Manager for your programming, there is a Quick Start Guide that you can access (on Windows, at least), that I have been told is quite handy and informative. In addition, there are Self-paced e-learning modules on programming available through SAS publications.

And of course, there are all our training classes. I think the issue of NODUPKEY and PROC SORT is covered in chapter 6 of our Advanced Programming class. (But we do not show an SQL alternative to PROC SORT in that class because of the "apples" and "oranges" aspect of the comparison. Proc SORT does one thing --sort data; while PROC SQL muddies the waters with the ability to select columns, create columns, order columns, group columns, etc all in one fell swoop.) The use of the DISTINCT keyword with PROC SQL to eliminate duplicates is covered in the SQL class that we offer.

But, I digress, you wanted to know about setting up a basic discussion forum. If you go here, you can enter a suggestion on how to improve the SAS Customer Support Web site:
http://support.sas.com/contact/intro.html .

Then, if you go to
http://support.sas.com/rnd/app/
you will find a LOT of information for the Statistics and Operations Research community. And this site shows all the SAS communities
http://support.sas.com/rnd/intro.html which have some form of FAQ or example section.

There is also a Listserv that is not hosted by SAS called SAS-L. Information about joining the SAS-L listserv can be found here:
http://www.listserv.uga.edu/archives/sas-l.html and for more info on SAS-L, you can refer to this SUGI paper:
http://www2.sas.com/proceedings/sugi29/138-29.pdf

But I still think that Tech Support is your best resource for this specific question.
cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 771 views
  • 0 likes
  • 2 in conversation