how to delete the duplicate columns permanently in SQL
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
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
What are the statements in proc sql?
What is your favorite all time computer book? Why?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
Intern stastical programmer written test
How do you control the number of observations and/or variables read or written?
For clinical entire study how many tables will create approx?
In SAS explain which statement does not perform automatic conversions in comparisons?
If you could design your ideal job, what would it look like?
What are the difference between ceil and floor functions in sas?
what is enterprise guide? What is the use of it? : Sas programming
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What is the difference between proportion and average?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
What does PROC print, and PROC contents do?