Hi,
I have multiple character values in a variable and want to compare each single row with other.
Can anyone please help me?
Thanks
USP
If you are only concerned with consecutive records this will work:
Data have;
input y $ @@;
datalines ;
mostthat morethis morethis morelike mostlike morelike morelike morelike mostlike
;
run;
data want;
set have;
l_y = lag(y);
if l_y = y then flag = 'Same';
else flag = 'Diff';
drop l_y;
run;
Post some test data in the form of a datastep, with required output. At a guess, merging, hash, retain/lag, transposing, are all options you could use.
I have this sample data:
Data new ;
input y $ @@;
datalines ;
mostthat morethis morethis morelike mostlike morelike morelike morelike mostlike
;
run;
I want to create a new column which will identify difference of each row.
for e.g. 2nd row is not simillar to 1st but 3rd is simillar to 2nd.
same way 7th is simillar to 6th and 8th is to 7th.but 9th is not simillar to 8th row.
If you are only concerned with consecutive records this will work:
Data have;
input y $ @@;
datalines ;
mostthat morethis morethis morelike mostlike morelike morelike morelike mostlike
;
run;
data want;
set have;
l_y = lag(y);
if l_y = y then flag = 'Same';
else flag = 'Diff';
drop l_y;
run;
Thank you Mark.
Yes, its still not clear your logic. If you want to know which ones appear in more than one row, then thats simple aggregate:
proc sql;
create table WANT as
select A.*,
B.CNT
from WORK.NEW A
left join (select Y,count(Y) as CNT from WORK.NEW group by Y) B
on A.Y=B.Y;
quit;
However, what do you mean by similar? Do you need soundex() function or something. What about identifiers, is there grouping involved. If you need to find out if one element appears and what specific row it appears on then use monotonic() or assign a variable for _n_, then use this to merge, ie.
from HAVE A
left join (select * from HAVE where Y=A.Y and ID > A.ID) B
...
Hello,
I assume you mean you want to compare a variable in each row with the same variable in every other row. Assuming you don't have an enormous number of rows in your input set, you could perform an Cartesian product (cross join). Keep in mind this will create a table with count of rows = original count of rows ^ 2, which can quickly become unwieldy.
proc sql;
create table analysis as
select a.*, <compare code>
from have a cross join have b;
Regards.
Thank you
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: