how to delete the duplicates by using proc sql?
Answers were Sorted based on User's Feedback
Answer / shivakrishna.yenaganti
Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;
| Is This Answer Correct ? | 22 Yes | 2 No |
Answer / arpit
proc sql;
select distinct (*) from sasuser.xyz;
quit.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chowdary
In constraints time using unique
In datasets using distinct()
| Is This Answer Correct ? | 1 Yes | 0 No |
How are numeric and character missing values represented internally?
Which function is used to count the number of intervals between two sas dates?
Describe 5 ways to do a “table lookup” in SAS?
What are the different versions of sas that you have used until now? : sas-grid-administration
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Give an example where SAS fails to convert character value to numeric value automatically?
In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
how can u convert this 25-jul-2010 from numeric to charcter?
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.
tell me about intnx, intcx functions?