About KachiM

KachiM · ‎08-04-2015

If you consider that a unique ID is one that occurs once only, it is possible to find by using Hash objects. But how much time it will take compared to SQL can be found only by you, by running both ways. Xia has already given a hash solution. It can not tell which ID occurs once only. Here is another hash way with an example, the length of ID need not be 6 in your case. It It collects all records having one ID into one data set(Unique) and the rest to another data set(Duplicates). data have; input ID $6.; datalines; aaaaaa aaaaaa aaaaaa bbbbbb dddddd ; run; data _null_; if _n_ = 1 then do; declare hash h(); h.definekey('ID'); h.definedata('ID','freq'); h.definedone(); end; set have end = eof; if h.find() ne 0 then freq = 0; freq + 1; h.replace(); if eof; h.output(dataset:'Unique (where=(freq=1)'); h.output(dataset:'Duplicates (where=(freq > 1)'); run; proc print data = Unique; run; proc print data = Duplicates; run;

KachiM · ‎08-03-2015

Is your ID, a number or character? If number, do have any idea about it Range. If it is number, array will be fast.

KachiM · ‎08-02-2015

The number in SAS has always 8 bytes. The use of 5 is for writing out the output data set. So reading into SAS from TXT file needs no Informat for a number. Try without 5 in your Input Statement. Tom has explained the reading through datalines statement.

KachiM · ‎07-16-2015

It is simple. The Key variable will not appear in the output. Only variables that are placed in the data part of the hash will be output. If you want B_ID in the output, add this variable to the data part also like: h.defineData('B_ID', 'client_name', 'client_id');

KachiM · ‎07-08-2015

Try @'(' Then adjust variables.

KachiM · ‎07-02-2015

Ian, I don't know why? IAN has to come to your rescue!

KachiM · ‎07-02-2015

Ian, I suspect your reading the input data sets is not OK. Better use Proc Print to see the values. Proc SQL is OK.

KachiM · ‎07-02-2015

Ian, PGStats solution gives the following OUTPUT. Do you want a different output? Please tell what you now get and what you want. It will help others to help you. PATIENT_ Obs ID DRUG_ID 1 238761 1023 2 238761 1024 3 239978 1022 4 239978 1024

KachiM · ‎06-30-2015

Ian, You have ailment-words from a Patient and have symptom lists by drug_id. How would the OUTPUT look-like? Should there be the Drug_Id or Symptom_word for the matching Ailment_word? A simple OUTPUT data set with the related PHARMA and PATIENT data sets will easily explain what you want, instead of thousand words of explanation.

KachiM · ‎06-28-2015

Do you want the count of missing values of Ques1 - Ques10? If so, then try this: data psych; input ID $3. Ques1-Ques10 Score1-Score5; Tot_Miss = nmiss(of Ques:); datalines; 001 1 3 2 4 5 4 3 4 5 4 90 88 92 95 90 002 3 3 . . 3 4 5 5 1 . 64 64 77 72 71 003 . . . . 5 5 4 4 3 3 68 69 80 75 70 004 5 3 4 5 . 5 4 3 3 . 88 77 66 77 67 005 5 4 3 2 1 1 2 3 4 5 92 93 94 95 99 006 4 5 1 3 2 5 3 1 1 1 55 65 71 85 91 007 3 2 2 1 5 4 5 3 2 2 60 70 88 79 82 008 2 1 1 5 5 4 4 2 1 3 65 87 90 60 55 009 1 1 1 3 2 2 3 5 4 4 71 81 91 77 88 010 2 3 3 4 1 5 2 2 3 1 64 69 61 70 70 ; run;

KachiM · ‎06-27-2015

I missed to compute the column totals in my previous Post. I am posting the revised code. This requires RETAIN statement. data Need(drop = i); input ID $3. Ques1-Ques10 Score1-Score5; array S Score1 - Score5; array F[5] _temporary_ (65, 70, 60, 62, 68); array P Pass1 - Pass5; array T TotPass1 - TotPass5; retain TotP:; do i = 1 to dim(S); P = (S >= F); T + P; end; output; datalines; 001 1 3 2 4 5 4 3 4 5 4 90 88 92 95 90 002 3 3 . . 3 4 5 5 1 . 64 64 77 72 71 003 . . . . 5 5 4 4 3 3 68 69 80 75 70 004 5 3 4 5 . 5 4 3 3 . 88 77 66 77 67 005 5 4 3 2 1 1 2 3 4 5 92 93 94 95 99 006 4 5 1 3 2 5 3 1 1 1 55 65 71 85 91 007 3 2 2 1 5 4 5 3 2 2 60 70 88 79 82 008 2 1 1 5 5 4 4 2 1 3 65 87 90 60 55 009 1 1 1 3 2 2 3 5 4 4 71 81 91 77 88 010 2 3 3 4 1 5 2 2 3 1 64 69 61 70 70 ; run;

KachiM · ‎06-27-2015

I suppose this is what you want. I don't any need to use RETAIN as array p[ ] holds the values for the previous row. Only check is it should be done from the second row. data psych; input ID $3. Ques1-Ques10 Score1-Score5; array S Score1 - Score5; array F[5] _temporary_ (65, 70, 60, 62, 68); array P Pass1 - Pass5; array T TotPass1 - TotPass5; do i = 1 to dim(S); P = (S >= F); if i > 1 then T + P; end; output; datalines; 001 1 3 2 4 5 4 3 4 5 4 90 88 92 95 90 002 3 3 . . 3 4 5 5 1 . 64 64 77 72 71 003 . . . . 5 5 4 4 3 3 68 69 80 75 70 004 5 3 4 5 . 5 4 3 3 . 88 77 66 77 67 005 5 4 3 2 1 1 2 3 4 5 92 93 94 95 99 006 4 5 1 3 2 5 3 1 1 1 55 65 71 85 91 007 3 2 2 1 5 4 5 3 2 2 60 70 88 79 82 008 2 1 1 5 5 4 4 2 1 3 65 87 90 60 55 009 1 1 1 3 2 2 3 5 4 4 71 81 91 77 88 010 2 3 3 4 1 5 2 2 3 1 64 69 61 70 70 ; run; proc print; run;

KachiM · ‎06-27-2015

Again, the question is not understood. I guess you want the (0,1) are to be added in each ROW. If so, it is simple. If you want both Pass1 - Pass5 along with TotPass1 - TotPass5 then use the following: data psych; input ID $3. Ques1-Ques10 Score1-Score5; array S Score1 - Score5; array F[5] _temporary_ (65, 70, 60, 62, 68); array P Pass1 - Pass5; array T TotPass1 - TotPass5; do i = 1 to dim(S); P = (S >= F); T + (S >= F); end; output; datalines; 001 1 3 2 4 5 4 3 4 5 4 90 88 92 95 90 002 3 3 . . 3 4 5 5 1 . 64 64 77 72 71 003 . . . . 5 5 4 4 3 3 68 69 80 75 70 004 5 3 4 5 . 5 4 3 3 . 88 77 66 77 67 005 5 4 3 2 1 1 2 3 4 5 92 93 94 95 99 006 4 5 1 3 2 5 3 1 1 1 55 65 71 85 91 007 3 2 2 1 5 4 5 3 2 2 60 70 88 79 82 008 2 1 1 5 5 4 4 2 1 3 65 87 90 60 55 009 1 1 1 3 2 2 3 5 4 4 71 81 91 77 88 010 2 3 3 4 1 5 2 2 3 1 64 69 61 70 70 ; run; if you want only, TotPass1 - TotPass5, you may delete the statement, P = (S >= F);

KachiM · ‎06-11-2015

Try this too. data have; input trandate ddmmyy10. amount dailybal accruingbal aggregatebal; datalines; 28/01/2015 . . . 3451.76 3451.76 29/01/2015 . . . 3451.76 6903.52 30/01/2015 -50.00 -50.00 3401.76 10305.28 . 31/01/2015 . . . 3401.76 13707.04 01/02/2015 56.60 223.59 3625.35 117332.39 . 01/02/2015 166.99 223.59 3625.35 117332.39 . 02/02/2015 . . . 3625.35 20957.74 ; run; data want; set have; set have(firstobs = 2 keep = trandate rename = (trandate = tran)); if trandate = tran then call missing(dailybal,accruingbal, aggregatebal); drop tran; run; proc print data = want; format trandate ddmmyy10.; run;

KachiM · ‎06-09-2015

Additional 4-th digit is not an issue. At present the use of $ sign is by default takes 8 characters. Even if it is longer than 8, use the appropriate width to $. No need to substring it.

Online Status	Offline
Date Last Visited	4 weeks ago

Re: Differentiate between potential errors versus good values in a lon...

Re: Join vs Merge 1.2 TB with 110 GB Datasets

Re: Sort only part of a _temporary_ Array

Re: Sort only part of a _temporary_ Array

Re: Sort only part of a _temporary_ Array

Re: Sum Certain values across rows.

Re: i want to sort the data in array and removing duplicate without us...

Re: Hash object memory getting full

Re: Hash Objects Find Greater than

Re: Hash Objects Find Greater than

Re: Creatine a new column if Values in one column are less than value ...

Re: Extracting desired values in a dataset

Re: How to workout keep track the variable

Re: do - end structure and if structure interaction

Re: how to keep multiple variables?

Re: Sort only part of a _temporary_ Array

Re: Sort only part of a _temporary_ Array

Re: Sort only part of a _temporary_ Array

Re: i want to sort the data in array and removing duplicate without us...

Re: Matching clients with SAS

Re: effective way to count the number of uniqueness

Re: effective way to count the number of uniqueness

Re: Reading raw data from external files or from datalines written in ...

Re: Hash object find method issue?

Re: Extract specific word from a string/variable

Re: Conditionally match merging records from two datasets without a co...

Re: Conditionally match merging records from two datasets without a co...

Re: Conditionally match merging records from two datasets without a co...

Re: Conditionally match merging records from two datasets without a co...

Re: Summing only missing values of a certain variable

Re: RETAIN ARRAY statements

Re: RETAIN ARRAY statements

Re: RETAIN ARRAY statements

Re: How do I remove values in current ob based on value in next ob?

Re: Categorising a table based on contents of columns in a second tabl...

SAS Global Forum 2018