Interested to Buy Any Domain ? << Click Here >> for more details...
how can u join the two tables without using proc sql Joins
and nested queries ?
- 6 Answers
- 13092 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumarravi111
we can use Merge and set statements to join the tables in
Data step
| Is This Answer Correct ? | 19 Yes | 1 No |
Answer / sai
we can join two tables by using merge statement and also by
using two SET statements .
data one;
set two;
set three;
run;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vimal
actually i think UNION and UNION ALL is the correct answer.. since they ask related to that.
| Is This Answer Correct ? | 1 Yes | 2 No |
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
what is the diff b/w verification validation in sas
how to delete the duplicate columns permanently in SQL
Explain substr function?
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
is data integration and etl programming is same? : Sas-di
Have you ever used the SAS Debugger?
At compile time when a SAS data set is read, what items are created?
what is data access? : Sas-di
name the scheduler for scheduling job and explain the scheduler? : Sas-di
what is slowly changing dimension? : Sas-di
Teradata 
