Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete the duplicate columns permanently in SQL
- 2 Answers
- 6320 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / naveen
data aaa;
input P_Id LastName $ FirstName $ City $;
cards;
1 Hansen Ola Sandnes
2 Svendson Tove Sandnes
3 Pettersen Kari Stavanger
;
run;
proc sql;
select distnict(city)
from aaa;
quit;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Give some examples where proc report’s defaults are different than proc print’s defaults?
how does sas handle missing values in formats? : Sas programming
Differentiate between format and informat? : sas-grid-administration
What is the order of application for output data set options, input data set options and SAS statements?
how to debug and test the sas program? : Sas-administrator
How to create list output for cross-tabulations in proc freq?
how can you put a "trace" in your program? : Sas programming
how would you create multiple observations from a single observation? : Sas programming
what is proc Index? and what is proc document?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Difference between informat and format?
what is sas and what are the functions? : Sas-administrator
what are _numeric_ and _character_ and what do they do? : Sas programming
Why and when do you use proc sql?
What are the table names in oracle database...?
