About ErinRoberts

ErinRoberts · ‎04-04-2018

data work.trans2; set work.trans_co; array ssn{52}; do i=1 to 52; if ssn{i} ne "" and ssn{i} ne prov_ssn then del="Y"; end; run; Does exactly what I need it to thank you!! I've only done this with basic calculations so this was very helpful.

ErinRoberts · ‎04-04-2018

Right now the code as I have it written works fine, it's just not user friendly if I have to add or remove variables.

ErinRoberts · ‎04-04-2018

I have some code I think could be made simpler using a do-loop but I'm not sure quite how to make it work. DATA WORK.TRANS2; SET WORK.TRANS_co; IF PROV_SSN NE SSN1 THEN DEL='Y'; ELSE IF SSN2 NE '' AND PROV_SSN NE SSN2 THEN DEL='Y'; ELSE IF SSN3 NE '' AND PROV_SSN NE SSN3 THEN DEL='Y'; . . . ELSE IF SSN52 NE '' AND PROV_SSN NE SSN52 THEN DEL='Y'; RUN; Basically, I have 52 character variables I'm looking for differences between and if there are any differences, I want to assign DEL='Y'. Any suggestions?

ErinRoberts · ‎12-02-2015

I have two SAS data sets - one of them has about 600,000 more observations than the other. All of the observations from SAS data set A are also in SAS data Set B, B just has more observations in addition. How can I abstract only those ~600,000 observations that are different? I already tried PROC COMPARE with no luck, since the new data aren't in any particualr order. for example Set A X Y Apples 1 Oranges 3 Pears 3 Set B X Y Apples 1 Watermellon 1 Oranges 3 Pears 3 Banana 2 in this case I want my output to be X Y Watermellon 1 Banana 2 Thoughts?

Online Status	Offline
Date Last Visited	‎04-04-2018 09:34 AM

Re: Is there a Do-Loop solution for this?

Re: Is there a Do-Loop solution for this?

Is there a Do-Loop solution for this?

Subtracting two SAS data sets

Re: Is there a Do-Loop solution for this?

Re: Is there a Do-Loop solution for this?

Is there a Do-Loop solution for this?

Subtracting two SAS data sets