topic Base SAS in SAS Programming

Base SAS

Himanshu007 — Tue, 06 Jun 2017 10:15:44 GMT

I have two datasets

Dataset_1

PS Lat Long Slot Dist XYZ

abc	75.8233	26.2454	1	2
abc	75.4875	26.8997	2	2
xyz	75.4875	26.3842	1	2
xyz	75.7861	26.6884	2	2

and

Dataset_2

PS Lat Long Slot Dist XYZ

abc	75.4785	26.4589	1	0.00	-100
abc	75.5495	26.4679	1	7929.25	-100
abc	75.5649	26.7268	2	0.00	-100
abc	75.5666	26.8647	2	3843.27	-100
xyz	75.4937	26.5877	1	0.00	-100
xyz	75.8473	26.3971	1	39820.47	-100

Now I want to append only those data from the second dataset to the first dataset which have dist less than 5000,

so please suggest me a solution

Thnx in advance

@PeterClemmensen

Re: Base SAS

Reeza — Tue, 06 Jun 2017 13:30:49 GMT

You really shouldn't tag users in a question unless you only want that persons answer. They're also under no responsibility to answer your question. In fact, I usually don't when someone does that.

You can use WHERE to filter the results in a SET statement.

data want;
Set first second(where = (dist < 5000));

Run;

Re: Base SAS

ballardw — Tue, 06 Jun 2017 14:35:15 GMT

And did actually want the 0 distances or only the non-zero distances < 5000?

Re: Base SAS

s_lassen — Tue, 06 Jun 2017 18:21:38 GMT

@Himanshu007:

If I understand you correctly, the easiest and fastest is probably to use PROC APPEND:

proc append base=dataset_1 data=dataset_2(where=(dist<5000));
run;