topic Re: re: Selecting Records in SAS Programming

re: Selecting Records

twildone — Fri, 22 May 2015 14:26:32 GMT

Hi....I have a large dataset and would like to select the records (rows) that have a claim date that is greater than the 'Date As Of' for only the product number in the specified group. Any suggestions?...Thanks in Advance

Group	Product_Number	Date As Of
FS	00000086	19970818
PA	00000086	19970818
FS	00000302	20060612
PA	00000302	20060612
PA	00000655	20120814
FS	00000655	20120814
MB	00000655	20120814
MB	00000663	20130228
FS	00000663	20130228
PA	00000663	20130228
MB	00001082	20110804
FS	00001082	20110804
PA	00001082	20110804
FS	00001120	20110804
MB	00001120	20110804
PA	00001120	20110804
FS	00001287	20110804
MB	00001287	20110804
PA	00001287	20110804
MB	00001317	20110804
FS	00001317	20110804
PA	00001317	20110804
NH	00001341	20110804
MB	00001341	20110804
FS	00001341	20110804

Re: re: Selecting Records

RW9 — Fri, 22 May 2015 14:35:39 GMT

Something like (and not tested):

proc sql;

create table WANT as

select A.*

from CLAIM_DATASET A

left join (select distinct GROUP,DATE_AS_OF from HAVE) B

on A.GROUP=B.GROUP

and A.CLAIM_DATE > B.DATE_AS_OF;

quit;

Assumes both dates are actually date values.

Re: re: Selecting Records

ballardw — Fri, 22 May 2015 14:36:47 GMT

More details. You don't show a claim date. Where is that value going to come from for comparison?

Re: re: Selecting Records

twildone — Sat, 23 May 2015 00:33:35 GMT

The claim date, along with the variables Group and Product Number as well other variables are on another dataset named ClaimData. The ClaimData is the large dataset that I want to select a subset from based on only if the Group, Product Number match from the list above and the Claim Date Must be greater than 'Date As Of' variable.