About PierreYvesILY

PierreYvesILY · ‎09-27-2019

We are in Germany, so (same rules NACHNAME and VORNAME): - all names must be written with Latin letters, of any european language (not possible to select this I guess) - in a name, you can have as many words as you need: 'Du Taxi du Pouet de la Valse Folle' is correct - the sign - between 2 words is accepted, as well as a space, or both together (people also type errors), and also ' - accents on voyels are OK : ` ´ ^ ~ ö ä ü - the _ will be tolerated - the following signs determine in all cases a false name: ? , = ; ( ) / & % $ § ! " * + # @ < > > | € - such test cases names as : cccc, ccc, Test, test... will be eliminated (I noticed some) My purpose here is to be helped in the method to achieve this goal, I would like to progress and understand how I can do.

PierreYvesILY · ‎09-27-2019

Dear SAS experts, I have a set of variables and among them name and surname: NACHNAME and VORNAME. These are character variables length $35. Some of their values are not correct: for instance, you can find : cccc ccc ?0??? !-§4$ Test Is there a method to clean them (delete the lines, where NACHNAME or VORNAME have this kind of irrelevant value)? Thanx, regards PY

PierreYvesILY · ‎09-25-2019

thanks a lot!

PierreYvesILY · ‎09-24-2019

hello, I want to compare 2 datasets, and obtain a 3rd dataset where all observations different between both of them are listed. - ORB_TAB_NPKENN : first dataset; it contains the second one entirely - ORB_TAB_2: second dataset. - DIFF_NPKENN: dataset that has to be produced, containing all the lines that are present in ORB_TAB_NPKENN and absent in ORB_TAB_2. I tried the following first, but I get a very weird result (it seems all variables are resetted or so). Only the names of the variables are correct. I have no clue how I could perform the desired control. /* TEST - comparaison ORB_TAB_NPKENN et ORB_TAB_2 */ proc compare base=orb_tab_npkenn out=diff_npkenn compare=orb_tab_2; run; Result: How should I proceed? Thx in advance, PY

PierreYvesILY · ‎09-19-2019

It helps a lot! thank you for the explanations, I really appreciate. Regards

PierreYvesILY · ‎09-19-2019

Thank you for your answers! Regards, PY

PierreYvesILY · ‎09-19-2019

Hello, I think the answer is practicable but I need to test with the real data tomorrow. Anyway, this code simplifies the further treatment a lot, and then I will only have to focus on the exceptions like 'Von und Zu' where the Name in itself contains the ' und'. Nevertheless, I don't understand what each parameter of the function does and have to research this: name2=prxchange('s/und//i',-1,name); what is the meaning of the s, the /, the //, the i and the -1. Thanks a lot

PierreYvesILY · ‎09-18-2019

Hello, I think the answer is practicable but I need to test with the real data tomorrow. Anyway, this code simplifies the further treatment a lot, and then I will only have to focus on the exceptions like ‘Von und Zu’ where the Name in itself contains the ‘ und’. Nevertheless, I don’t understand what each parameter of the function does and have to research this: name2=prxchange('s/und//i',-1,name); what is the meaning of the s, the /, the //, the i and the -1. Thanks a lot

PierreYvesILY · ‎09-18-2019

hello, thanks, I tested the second solution first, and come to the problem that some of the NAME observations also contains blank spaces. For instance: Name1 = 'Von und Zu' and the original NAME content is 'Von und Zu und' Name2 = 'Tortilla' and the original NAME content is 'Tortilla und' Name3 = 'Bin dahoam' and the original NAME content is Bin dahoam und' Name4 = 'Curry Wurst' and the original NAME content is 'Curry Wurst und' Is there a way to get the list of Name1 to Name4 from the following: data Namen ; input Name &$35.; name2=scan(strip(name),1,' '); datalines;Von und Zu und Tortilla und Bin dahoam und Curry Wurst und; run;

PierreYvesILY · ‎09-18-2019

hello, I have to work on data that are not properly registered in the database. One of the variables is a Name (character, $35.) but in many cases it is completed by error : ' und' or ' oder' are added ton the names (empty space as first part of the character chain). data Namen ; format Name $35.; input Name &; datalines; Name1 und Name2 und Name3 und Name4 oder ; run; My goal is to clean the Variable Name from all ' und' and ' oder' and get a datastep where only the names are present: Name1 Name2 Name3 Name4 How should I proceed? Thanks in advance, PY

PierreYvesILY · ‎09-06-2019

Thanks a lot! I got the wished result, and can now use thi method with my actual real data. Have a nice WE Regards, PY

PierreYvesILY · ‎09-06-2019

thank you for your efforts. To understand the result Zins = 0.02 for the first example: 1) the first entry in the production datastep is: Date = 12JAN2009:18:00:00 Qualification = C Produkt = Auto Laufzeit = 13 2) look at the Konditionstabelau (1. Datastep), and now check if you find a line where, using the values above: Start_date < Date <= End_date Qualification = C Produkt = Auto Laufzeit_Start < Laufzeit <= Laufzeit_End The 1st line of the Konditionstabelau (1. Datastep) is compatible with the values, and in the Zins column is the value 0.02 stored. This value is the result to complete the Production dataset into Production_result dataset. I hope this is clear now. Regards, PY

PierreYvesILY · ‎09-06-2019

The date is not provided in the dataset above because this dataset is the 'reference' one. So does the Laufzeit, the Qualification, the Produkt. They all are in the production dataset that has to be matched with the reference one to determine the result. To simplify, I have a Production Dataset with the following columns (and lots of other parameters): data Production_result(label='Productiondata_with_Zins'); input Date:Datetime20. Qualification:$2. Produkt:$25. Laufzeit:4. Zins:3.4; datalines; 12JAN2009:18:00:00 C Auto 13 31JAN2009:09:00:00 D Immo 40 01JAN2009:08:45:00 A FreeUse 61 01JAN2010:16:58:00 E FreeUse 99 01JAN2012:12:00:58 D FreeUse 28 01JAN2015:09:15:00 C FreeUse 39 01JAN2017:08:20:00 B Auto 50 01JAN2017:08:30:00 B Immo 108 01JAN2019:08:10:00 B Immo 78 ; run; the awaited result is to add a column 'Zins' to the production dataset, and the results would be : data Production(label='Productiondata'); input Date:Datetime20. Qualification:$2. Produkt:$25. Laufzeit:4.; datalines; 12JAN2009:18:00:00 C Auto 13 0.02 31JAN2009:09:00:00 D Immo 40 0.05 01JAN2009:08:45:00 A FreeUse 61 0.04 01JAN2010:16:58:00 E FreeUse 99 0.055 01JAN2012:12:00:58 D FreeUse 28 0.06 01JAN2015:09:15:00 C FreeUse 39 0.07 01JAN2017:08:20:00 B Auto 50 0.035 01JAN2017:08:30:00 B Immo 108 0.08 01JAN2019:08:10:00 B Immo 78 0.07 ; run; I hope it is a lot clearer like this. I still don't find the correct input format for the dates.

PierreYvesILY · ‎09-06-2019

hello, I need a function which would use the following entry parameters: - Date (format: Datetime20.) - Qualification ($2.) - Produkt ($25.) - Laufzeit (4.) and return the following Value of the variable Zins (format 3.4), stored in the dataset 'reference matrix' underneath. Zins= Function (Date, Qualification, Produkt, Laufzeit) The result ist determined by: select the lines in the dataset 'reference matrix' where : Start_date < Date <= End_date select the lines in the dataset where : Laufzeit_Start < Laufzeit <= Laufzeit_End and the Qualification and Produkt Variables. I have an (example) reference matrix for the results: data Matrix_Ref(label='Konditionstableau'); input Start_date:Datetime20. End_date:Datetime20. Qualification:$2. Produkt:$25. Laufzeit_Start:4. Laufzeit_End:4. Zins:3.4; datalines; 01JAN2009:08:00:00 31JAN2009:08:00:00 C Auto 12 36 0.02 31JAN2009:08:00:00 01JAN2015:08:00:00 D Immo 36 60 0.05 01JAN2009:08:00:00 01JAN2015:08:00:00 A FreeUse 60 72 0.04 01JAN2010:08:00:00 01JAN2015:08:00:00 E FreeUse 96 120 0.055 01JAN2012:08:00:00 01JAN2015:08:00:00 D FreeUse 12 36 0.06 01JAN2015:08:00:00 01JAN2019:08:00:00 C FreeUse 36 60 0.07 01JAN2017:08:00:00 01JAN2019:08:00:00 B Auto 36 60 0.035 01JAN2017:08:00:00 01JAN2019:08:00:00 B Immo 96 120 0.08 01JAN2019:08:00:00 01APR2019:08:00:00 B Immo 72 84 0.07 ; run; Questions 1. The Input step doesn't work for the Date, what should I write? 2. How could I write the function? What is recommended here? Thanks in advance, Regards, PY

PierreYvesILY · ‎09-04-2019

Thanks a lot for your response. I got inspired by your script and finally wrote the following, because I need some particular results: - if n(i) = 0 and d(i) = 0, the results r(i) is 0 - if n(i) = 0 and d(i) <> 0, the result is -1 (say: -100%) - if n(i) <> 0 and d(i) = 0, the result is 1 (say: +100%) - if both n and d are <> 0, the result is (n(i)-d(i))/d(i) So, my final scrip - which works, is the following: do i=1 to dim(n) ; d[i]=coalesce(d[i],0); n[i]=coalesce(n[i],0); r[i] = (n[i]-d[i])/d[i]; if n[i] = 0 then r[i] = coalesce(r[i],0); else r[i] = coalesce(r[i],1); end; Thanks a lot, I didn't know the coalesce Function, and your suggestion helped a LOT. regards, PY

Online Status	Offline
Date Last Visited	‎07-02-2021 10:24 AM

Re: Is there a SAS function which returns the month based on the week ...

Is there a SAS function which returns the month based on the week iden...

Re: error in a dataset with dates

Re: error in a dataset with dates

error in a dataset with dates

Format for getting YYYYMM in numeric

Re: correction needed :

correction needed :

Re: Proc summary YTD mean problem

Re: Proc summary YTD mean problem

Re: Is there a SAS function which returns the month based on the week ...

Re: error in a dataset with dates

Re: error in a dataset with dates

Re: error in a dataset with dates

Re: Format for getting YYYYMM in numeric

Re: Is there a SAS function which returns the month based on the week ...

Re: optimize the name of export files

Re: difference between 2 dates in MONTHS

Re: how to programm this simple matrix properly in datascript or sql?

Re: How to clean false values of a variable?

How to clean false values of a variable?

Re: building the 'difference between 2 datasets'

building the 'difference between 2 datasets'

Re: How to clean a character variable from some standardised character...

Re: How to clean a character variable from some standardised character...

Re: How to clean a character variable from some standardised character...

Re: How to clean a character variable from some standardised character...

Re: How to clean a character variable from some standardised character...

How to clean a character variable from some standardised character cha...

Re: How to programm a function using character, numeric AND date varia...

Re: How to programm a function using character, numeric AND date varia...

Re: How to programm a function using character, numeric AND date varia...

How to programm a function using character, numeric AND date variables

Re: 0 divided by 0 in an array

SAS Analytics Explorers