topic Re: How to add tables till / from specific data? in SAS Programming

How to add tables till / from specific data?

aminkarimid — Thu, 22 Jun 2017 19:07:27 GMT

Hello everybody,

I have three tables and want to add table01 to table02 and table02 to table03. In first file, I want table01 as a whole and add table02 to it till specific time (November 19, 2013) in table02. In second file, I want table03 as a whole and add table02 to it from specific time (from November 19, 2013) in table02. Let me give you an example:

table01			table02			table03
date	var01	var02	date	var01	var02	date	var01	var02
1	123	asd	4	456	asd	7	789	asd
2	234	sdf	5	567	sdf	8	890	sdf
3	345	dfg	6	678	dfg	9	321	dfg

And I want to create below tables:

file01			file02
date	var01	var02	date	var01	var02
1	123	asd	6	678	dfg
2	234	sdf	7	789	asd
3	345	dfg	8	890	sdf
4	456	asd	9	321	dfg
5	567	sdf

I have variables which their attributs are showed below:

Alphabetic List of Variables and Attributes

# Variable Type Len Format Informat Label

TRD_EVENT_DT	Num	8	DATE9.	DATE9.	TRD_EVENT_DT
TRD_EVENT_TM	Char	8	$8.	$8.	TRD_EVENT_TM
TRD_PR	Char	5	$5.	$5.	TRD_PR
TRD_STCK_CD	Char	5	$5.	$5.	TRD_STCK_CD
TRD_TUROVR	Char	9	$9.	$9.	TRD_TUROVR

Explanation of variables of some columns:

[TRD_EVENT_DT]: Month / Day / Year
,[TRD_EVENT_TM]: Time: hh:mm:ss
,[TRD_PR]: Stock Price
,[TRD_TUROVR]: Turnover

,[TRD_STCK_CD]: Name.

How can I do that?

Thanks in advance.

Re: How to add tables till / from specific data?

kiranv_ — Thu, 22 Jun 2017 19:07:48 GMT

may be something like this

proc sql;
create table file01 as 
select date, var1, var2
from table1
union all
select date, var1, var2
from table2 
where date le '19NOV2013'd;

create table file02 as 
select date, var1, var2
from table3
union all
select date, var1, var2
from table2 
where date gt '19NOV2013'd;
quit;

Re: How to add tables till / from specific data?

Reeza — Thu, 22 Jun 2017 19:10:24 GMT

data want;

set 
    /*whole data set*/
    data1 
    /*partial data sets*/
    data2 (where=( datepart(date_Variable <= "01Jan2017"d))
    data3 (where=( datepart(date_Variable <= "01Jan2017"d))
    / *whole datasets*/
    data4 ;

run;