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
Are you involved in writing the inferential analysis plan? Tables specifications?
What is the difference between input and infile statement?
what are the categories that sas informats are used to the place the data? : Sas-administrator
Explain the main difference between the sas procedures and functions? : Sas-administrator
which date functions advances a date time or date/time value by a given interval? : Sas programming
What are SAS/ACCESS and SAS/CONNECT?
What are the limitations for memory allocation for SAS variables
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
How many data types are there in SAS?
how many types prompting framework can be broken down to? : Sas-bi
What is the maximum and minimum length of macro variable
describe how to adjust the performance of data integrator? : Sas-di
how the sas basic syntax style described? : Sas-administrator
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
how to change the execute of macro