About deega

deega · ‎03-21-2017

I have a dataset like below No Process 1 AB C 2 AB D 3 XYZ 4 YYY 5 AB C 6 XYZ 7 DE F 8 AB D 9 AB D 10 YYY I want to find the values that does not contain AB* as follows using arrays. No Process 3 XYZ 4 YYY 6 XYZ 7 DE F 10 YYY Please advise.

deega · ‎03-10-2017

I tried the same. Transposed and then merged. I was wondering if there is any other option.

deega · ‎03-10-2017

Hi All, I want to transpose the following dataset id d amt x001 12 1000 x002 10 1000 x002 11 2000 x002 12 3000 x003 13 1000 x003 15 3000 x004 23 1000 x005 13 4000 x005 14 2000 x005 16 3000 x005 17 4000 x005 18 1000 and I am trying to get following output 　 d1 d2 d3 d4 d5 a1 a2 a3 a4 a5 x001 12 　　　　 1000 　　　　 x002 10 11 12 　　 1000 2000 3000 　　 x003 13 15 　　　 1000 3000 　　　 x004 23 　　　　 1000 　　　　 x005 13 14 16 17 18 4000 2000 3000 4000 1000 However, if I write the following program I get values of different columns in different rows. proc transpose data=Y out=check ; id ID; var d amt; run;

deega · ‎03-02-2017

Hi All , I have following dummy dataset. Number Amount Sequence 1111 100 A 1111 200 A 1111 300 C 1111 100 B 1112 200 A 1112 100 C 1112 200 A 1113 300 C 1113 300 A 1114 100 A 1114 100 B 1114 200 B 1114 200 C 1115 300 C 1116 100 A 1116 200 B 1116 300 C I want to delete all the rows with sequence=C but I want to keep its amount, so I am adding that amount to next observation of same group. In the cases where the row with sequence=C is last in the group then I want to add its amount to the preceding row. Something like below: Number Amount Sequence 1111 100 A 1111 200 A 1111 400 B 1112 200 A 1112 300 A 1113 600 A 1114 100 A 1114 100 B 1114 400 B 1116 100 A 1116 500 B

deega · ‎02-16-2017

Thanks to @Shmuel This program is giving desired solution with just a minor syntax error. flag = 0 → (flag=0)

deega · ‎02-15-2017

Dear Consultants, For the first time I used data step for creating dummy dataset(as I always get data in CSV files and never got a chance to use input statements), I hope now nobody will get anxious. Here is the dataset. data dummy; infile datalines missover; input ID C1$ C2$ C3$ C4$ C5$ C6$ C7$ C8$ C9$ C10$ S1$ S2$ S3$ S4$ S5$; datalines; 1234 a b . . . . . . . . b b d . 2235 b d a . . . . . . . a d a s 2568 a s d f g h i . . . x y z 2698 x x x . . . . . . . x x y z 5545 a x d f f f f f f f f s d f 5625 f k l a f . . . . . y t . . . ; run; Now from this dataset I want only those records in which values in columns C (C1 to C10) are repeated in columns S (S1 to S5), something like below. 1234 a b . . . . . . . . b b d . 2235 b d a . . . . . . . a d a s 2698 x x x . . . . . . . x x y z 5545 a x d f f f f f f f f s d f Waiting for the expert advise.

deega · ‎02-10-2017

Dear Members, Once again, I need your expert advice. I have the following SAS Dataset (posting the dummy data reproduced in excel). ID A1 A2 A3 A4 A5 1234 abc def abc def 　 1235 abc abc abc abc 　 1236 abc 　　　　 1240 asf abc asf def asf 1245 abc def asf ghi jkl 1251 asf abc 　　　 1252 abc abc 　　　 I am looking for the following output where all the duplicate values across rows will be deleted. ID A1 A2 A3 A4 A5 1234 abc def 　　　 1235 abc 　　　　 1236 abc 　　　　 1240 asf abc def 　　 1245 abc def asf ghi jkl 1251 asf abc 　　　 1252 abc 　　　　 Thanks in advance !

deega · ‎02-08-2017

@Shmuel 1. Input data has 3 or more neighbors but in output I want only 3 neighbors 2. Yes, I dont want distance in output 3. ID exists only on first row, that is the main problem for me 4. data is in SAS dataset

deega · ‎02-08-2017

I want to transpose my data in the following way Input: ID Neighbor Distance X1 X45 0.1 　 X44 0.2 　 X20 0.2 X5 X32 0.3 　 X59 0.4 　 X20 0.4 　 X12 0.4 X3 X56 0.1 　 X43 0.2 　 X32 0.2 X2 X5 0.2 　 X21 0.3 　 X13 0.3 X7 X4 0.2 　 X13 0.3 　 X21 0.3 　 X32 0.4 Output ID neighbor1 neighbor2 neighbor3 X1 X45 X44 X20 X5 X32 X59 X20 X3 X56 X43 X32 X2 X5 X21 X13 X7 X4 X13 X21 Since transpose requires sorting, if I do that I lose the order of neighbors. Yes, If the whole set of ID alongwith neighbors then it does not affect the process. The order that I need to maintain in neighbor from top to bottom for each ID. Thanks in advance !

deega · ‎02-06-2017

Actually as per my business problem Jaccard Distance suits the best. How practical is it to use the method of bubble sort while calculating Jaccard Distance, something like below: Suppose there are 1M observations and I need three NN from these 1 M observations. If I calculate JD for obs1 & 2, then compare them, take the shortest and discard the other one. Then again compare the shortest of (1,2) with JD of 3, then again take the shortest.. and so on...

deega · ‎01-31-2017

Thanks... Any idea how to filter the records that do not have 'ian' and group abc ??

deega · ‎01-31-2017

Hello Everybody, I want to create a new variable (Count) based on multiple queries in a group: Observations are grouped by ID. Condition 1 is : Desired variable 'count' increases by 1 if variable 'Country' is US. Condition2 is if variable 'Group' is 'ABC' and variable 'Name' contains 'ian' then also count increases by 1. Something like below : Input Output ID Date Name Group Country Count 1 1月2日 Jian ABC AU 1 1 1月3日 Bian DEF RU 1 1 1月4日 Lasie ABC UK 1 1 1月5日 Brat JKL US 2 I wrote the following program but dont know why its not giving the desired result. data Out; set Input ; by ID Date ; if first.ID then count=0; if (find(Name,' ianﾞ','i') and Group = 'ABC') then count + 1 ; else if Country="US" then count + 1; run;

deega · ‎01-25-2017

@mkeintz No, the variables are not integers they are real numbers like 1.23, 0.28.....etc. but actually they were integers in different ranges like some variables were binary, some were in the range of 1 to 10, some were in the range of 30 to 70 etc and for creating clusters and finding distances I standardized the data and as a result data turned into decimal points.

deega · ‎01-25-2017

@Rick_SAS The shape of my dataset is as follows: S. No. Var1 Var2 Var3 Var4 Var5:: Var30 A1 1 2 1 3 1 5 A2 2 1 1 3 1 2 A3 1 1 2 1 2 1 A4 2 3 3 1 2 1 A5 1 2 1 2 1 2 A6 3 1 3 3 1 1 A7 2 1 2 1 2 1 A8 1 2 1 2 2 1 A9 1 1 3 5 2 2 A10:: 2 2 1 0 0 0 A1000000 1 5 2 0 3 4 I want KNN (K=3) for each observation from A1 to A1000000. Actually I had 200M observations, first I made clusters using fastclus and thought of using distance procedure for calculating distance and sort and take the top 3 records. Some clusters have less records but some still have high number of records. I was able to use distance procedure till 100,000 records but it is not responding above this limit. When I tried KNN Node in SPSS it responded to higher number of records too, so I thought of customising program for distance instead of using Distance proc. Please advise me something for this situation.

deega · ‎01-25-2017

@Rick_SAS If I have around 1000000 records and for each record I need at least three nearest records,( means KNN with K=3) will this work? The Distance proc is not working because the output is 1000000 * 1000000 matrix.

Online Status	Offline
Date Last Visited	‎03-27-2017 01:15 AM

String query in Arrays

Re: transpose multiple columns and getting output in columns

transpose multiple columns and getting output in columns

delete row and sum the value of one of its column

Re: checking values within row

checking values within row

Removing duplicate values

Re: transpose in particular format

transpose in particular format

Re: shortest distance

Re: transpose multiple columns and getting output in columns

Re: transpose in particular format

Re: Multiple Queries

Re: shortest distance

Re: format in proc frequency

Re: format in proc frequency

Re: Import dates variable from CSV

String query in Arrays

Re: transpose multiple columns and getting output in columns

transpose multiple columns and getting output in columns

delete row and sum the value of one of its column

Re: checking values within row

checking values within row

Removing duplicate values

Re: transpose in particular format

transpose in particular format

Re: shortest distance

Re: Multiple Queries

Multiple Queries

Re: shortest distance

Re: shortest distance

Re: shortest distance