About ger15xxhcker

ger15xxhcker · ‎07-22-2019

Hello! I I'd like to join 2 table (have1 left join have2) if the table1.string contains table2.string2 and id1=id2; How can i detect that contain (or do not contain) character variables. I 'd like to apply in the "on" condition in proc sql statement. data infile cards truncover; input @; _infile_=tranwrd(_infile_,'NULL',.); input id string $200.; cards; 1 ('1B' '1C' '1D' '2L' '2K' '1G' '1H' '11' 'AA') 2 ('2B' '3C' '4D' '4L' '2K' '4G' '0H') 3 ('7B' '9C' '8D' '2L' '2K' '1G' '1H' '45') 4 ('1B' '1C' '1D' '3L' '2K' '0G' '0H') ; RUN; data have2; input id2 string2 $2.; datalines; 1 4F 2 2B 3 7D 4 1C ; run; data want; input id3 string3 $2.; datalines; 1 2 2B 3 4 1C ; run; Thanks!

ger15xxhcker · ‎07-18-2019

Thank, you are right full of name conventions next time i will do so! Your code is perfect for me. Only the first method need some changes. How can i do if I only look at the more then 20% increase, not the decrease. So i modify my question: If the first 2 record is the same and the third one is more then 20 increase. I really appreciate it!

ger15xxhcker · ‎07-18-2019

Sorry for the wrong wording. An example: 1. row id =1 amt = 10 2. row id =1 amt = 11 3. row id =1 amt = 13 (this one is 18,12% higher then the second one) 4. row id=2 amt = 10 5. row id=2 amt = 11 6. row id=2 amt = 14 this third one is 27,2% higher then the second one (which is for id = 2) i'd like to compare this values. If the third one is >= 20% then take a flag. Thanks for your help!

ger15xxhcker · ‎07-17-2019

Hello! I would like to produce 3 sets under the following conditions. How could this be done? Thanks! data test; input id amt; datalines; 1 5 1 5 1 106 2 90 2 100 3 111 3 111 3 111 3 111 4 837 4 838 4 839 ; run; data want01; /*01 after the first two occurrences, the difference is greater than 20% compared to the third one*/ input id flg$; datalines; 1 Y ; run; data want02; /*02 where the amt field is constant*/ input id flg$; datalines; 3 Y ; run; data want03; /*03 where the amt field always changeing*/ input id flg$; datalines; 2 Y 4 Y ; run;

ger15xxhcker · ‎07-17-2019

Thank you for your guidance! Unfortunately I don't know how to start with it 😕 data test; input id amt; datalines; 1 5 1 5 1 106 2 90 2 100 3 111 3 111 3 111 3 111 4 837 4 838 4 839 ; run; data want01; /*01 after the first two occurrences, the difference is greater than 20% compared to the third one*/ input id flg$; datalines; 1 Y ; run; data want02; /*02 where the amt field is constant*/ input id flg$; datalines; 3 Y ; run; data want03; /*03 where the amt field always changeing*/ input id flg$; datalines; 2 Y 4 Y ; run; Thanks for your reply!

ger15xxhcker · ‎07-17-2019

Hello! This is my test table. I would have 3 questions. ID amt 1 10 1 12 1 50 1 52 2 10 2 11 2 13 3 60 3 65 3 120 1. If, after the first two occurrences, the difference is greater than 20% compared to the third one, then do one flg how can i do it? 2. Same table but I'd like to mark only if the amount fields do not change and always the same how can i do it? 3. Same table but I'd like to mark only if the amount fields always changeing. How can i do it?.(each is different) ID amt 1 10 1 12 1 50 1 52 2 10 2 11 2 13 3 60 3 65 3 120 1. eg: new final table looks like: Id flg 1 y 2 n Thanks for your help!

ger15xxhcker · ‎07-12-2019

Thanks, but how can i define a column value to the new dataset based on these result? I shows the diff but how can i use it to in a data set to add the flg value to 'Y' e.g: data have190430; input ID (Startdate Enddate)(:date11.) Name $ Flg $; format Startdate Enddate date11.; datalines; 1 26-Sep-13 26-Sep-13 Erloti n 2 23-Oct-13 23-Oct-13 AAAAAA n 3 22-Nov-13 22-Nov-13 Erloti n 4 16-Dec-13 16-Dec-13 Erloti n ; run; data have190331; input ID (Startdate Enddate)(:date11.) Name $ Flg $; format Startdate Enddate date11.; datalines; 1 26-Sep-13 26-Sep-13 Erloti n 2 23-Oct-13 23-Oct-13 Erloti y 3 22-Nov-13 22-Nov-13 Erloti n 4 16-Dec-13 16-Dec-13 Erloti n ; run;

ger15xxhcker · ‎07-12-2019

There is a table with a uniqe ID. This is an external time stamp table (yymmdd).I'd like to check if a fields (in the previous month) A colums, B columns and C columns have changed on the same ID in this table then we will update field in the new table e.g: D:='Y'. If the table does not exist then do not nothing. Thanks!

ger15xxhcker · ‎07-11-2019

Datetime and i have to filter in the where statement where date_column < 2000-01-01-00.00.00.000000

ger15xxhcker · ‎07-11-2019

Hi! How can i trasform from this string-> '2019-06-13-15.55.04.392000' to a date? Thanks a lot!

ger15xxhcker · ‎07-10-2019

Thanks for your quick help!

ger15xxhcker · ‎07-10-2019

Hi! I have a test data set. If there is more than one identifier in the table and it is included 20900101 date then keep it that row. The rest are related to this ids delete it/drop it. data; input id date$ var1$ var2$; datalines; 1 20900101 abc abc2 2 20070102 cdf cdf2 2 20900101 jdk lao2 1 20110101 cds sxa 1 20150202 jui wsa 3 20900101 wer wes2 1 21000101 rte www 4 20190101 www rrr ; run; so i'd like to this: (1. id contains 20900101 2. id contains 20900101 3. id contains 20900101 4. id not contains so keep it) data; input id date$ var1$ var2$; datalines; 1 20900101 abc abc2 2 20900101 jdk lao2 3 20900101 wer wes2 4 20190101 www rrr ; run; Thanks!

ger15xxhcker · ‎07-10-2019

Hi! data test; input id date$ var1$ var2$; datalines; 1 20900101 abc abc2 2 20070102 cdf cdf2 2 20900101 jdk lao2 1 20110101 cds sxa 1 20150202 jui wsa 3 20900101 wer wes2 1 21000101 rte www 4 20190101 www rrr ; run; This is my test data set. I'm looking for a solution for keeping the specified rows. If there is a 20900101 date from a particular id, then keep it. The other rows which have the same ID just drop it or delete . so my final table I want it to look like that: data test; input id date$ var1$ var2$; datalines; 1 20900101 abc abc2 2 20900101 jdk lao2 3 20900101 wer wes2 4 20190101 www rrr ; run; Thanks for your help!

ger15xxhcker · ‎07-02-2019

Thank you!

ger15xxhcker · ‎07-02-2019

Exactly!

Online Status	Offline
Date Last Visited	‎12-16-2024 12:21 PM

Re: scaling of the x-axis for the survival curves

Re: proc sgplot, vbarbasic and uniform=yscalegroup (truncated y-axis)

Re: A space inside the concatenated variable

Re: ERROR: CLI open cursor error: [IBM][System i Access ODBC Driver][D...

Re: Re-coding/ matching multiple columns from an external table

Re: char missing value

Re: Does does SAS crash when I change the order of the Drop option?

Re: FAILED! => {"msg": "'dict object' has no attribute 'sas_all'"}

Re: Looking for advices about the certification tests, i would like ta...

Re: Exporting tables

Re: HASH update all records

Re: update large table based another table key

Re: update large table based another table key

Re: Update large tables based on a parameter table (hash join?)

Re: Update large tables based on a parameter table (hash join?)

Re: SAS Text Import Node - all supported file formats

Re: scaling of the x-axis for the survival curves

Re: PROC SURVEYFREQ - Tests for trend

Re: Looking for advices about the certification tests, i would like ta...

Re: Drop down list in sas VA

join on condition contain specific string

Re: how do i retaining values by id

Re: how do i retaining values by id

how do i retaining values by id

Re: conditional retain debends on amt values

conditional retain depends on amt values

Re: testing previous table (changeing values)

testing previous table (changeing values)

Re: character to strange date (yyyy-mm-dd-hh-mm-ss -ms ?)

character to strange date (yyyy-mm-dd-hh-mm-ss -ms ?)

Re: keep line specific lines which contains a specific value by id

keep line specific lines which contains a specific value by id

keeping specific rows

Re: Create a monotonic value from a given value

Re: Create a monotonic value from a given value