Hi,
I have two SAS table one and two.both the table having some same column and some different col.I need to append the data and create a single dataset. on top of that I need to create view on the combine table.
I am using below code but not able to do it.
data join / view=one.join_vw;
set one two;
run;
its throwing an error
ERROR: The requested type of view (Input or Output) cannot be determined.
let me know anyone have any solution for this.
further I need to access the view for different process. can I would be able to access the view as it is created on two different table.
Thanks;
I have used below code and it's working fine.
data join_one/view=join_one;
set oil.oil;
run;
data join_two/view=join_two;
set ocb.ocb;
run;
data out.join_vw/ view=out.join_vw;
set join_one join_two;
run;
data join_out;
set out.join_vw;
run;
I think you syntax is a bit off, you can only have ONE name for ONE view, here you are offering two: 'join' and 'one.join_vw'. Try to make them the same:
data one.join_vw / view=one.join_vw;
set one two;
run;
Good luck,
Haikuo
BTW, just to be clear, SAS View is a piece of SAS code, so it doesn't care how many tables involved, when you used it, it also doesn't care if it is sourced from multiple tables.
I have used below code and it's working fine.
data join_one/view=join_one;
set oil.oil;
run;
data join_two/view=join_two;
set ocb.ocb;
run;
data out.join_vw/ view=out.join_vw;
set join_one join_two;
run;
data join_out;
set out.join_vw;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.