topic Re: SET STATEMENT in SAS Procedures

SET STATEMENT

robertrao — Thu, 03 Oct 2013 17:11:35 GMT

Hi ,

How can i combine these two datasets into a single step but giving me the same OUTPUT as when i do them seperately

data want1(keep=flag ID PLACEMENT);
set have(keep=ID PLACEMENT);
if ("&start"D <=PLACEMENT <= "&end"D)
flag="IN";
run;

data want2(keep=flag ID REMOVAL);
set have(keep=ID REMOVAL);
if ("&start"D <=REMOVAL <= "&end"D)
flag="OUT";
run;

Finally i want to set the PLACEMENT and REMOVAL under ONE variable and flag will be the identifier

Thanks

Re: SET STATEMENT

esjackso — Thu, 03 Oct 2013 17:19:52 GMT

Does the method matter? Data step vs sql?

Re: SET STATEMENT

robertrao — Thu, 03 Oct 2013 17:26:25 GMT

Data step should be OK

Re: SET STATEMENT

esjackso — Thu, 03 Oct 2013 17:34:36 GMT

I guess I should have also asked whether you mean you want the data appended or merged ... I wasnt clear from your description.

Re: SET STATEMENT

robertrao — Thu, 03 Oct 2013 17:37:09 GMT

Yes. The Placement and REMOVAL data needs to be appended under a single variable

Thanks

Re: SET STATEMENT

esjackso — Thu, 03 Oct 2013 17:45:54 GMT

I dont have a easy way to test this but something like the following should work (may have to play with the variable name in the where statements and you might have to break the where into two separate statements ... ie .... and placement <= "&end"D 😞

data want (keep=flag id onevar);

length flag $3;

set have (in=a rename=(placement=onevar) where=("&start"D <=PLACEMENT <= "&end"D))

have (in=b rename=(removal=onevar) where=("&start"D <=removal <= "&end"D));

if a then flag = "IN";

if b then flag = "OUT";

run;

Hopefully this at least puts you on the right track.

Re: SET STATEMENT

robertrao — Thu, 03 Oct 2013 18:06:01 GMT

Hi,

I am doing like this and both my output datasets have zero records..

i am not able to figure out where i am going wrong?

data out(keep=flag id REMOVAL)

IN(keep=flag id PLACEMENT);

set have(keep=id PLACEMENT REMOVAL value);

IF ("&start"D <= REMOVAL <= "&end"D) and value in('270' '2701' '2703' '27033') THEN DO;
FLAG="OUT";

OUTPUT out;
END;

IF ("&start"D <= PLACEMENT<= "&end"D) and FLO_MEAS_ID in('270' '2701' '2703' '27033') THEN DO;
FLAG="IN";

OUTPUT IN;
END;
run;

Re: SET STATEMENT

Astounding — Thu, 03 Oct 2013 18:31:00 GMT

The smaller issue is the use of VALUE vs. FLO_MEAS_ID. That might just be a typo in posting your program.

The bigger issue is that no observations satisfy the IF conditions. You'll have to inspect your data to find out why. A likely possibility is that REMOVAL and PLACEMENT contain datetime values, rather than date values. If that's the case, you would have to apply the DATEPART function to them in order to compare them to dates.

Good luck.

Re: SET STATEMENT

robertrao — Thu, 03 Oct 2013 18:37:45 GMT

Thanks Astounding.

I forgot to put the datepart. and as u mentioned they are datetime values..

Thanks so very much