Thanks for your quick reply. As I said I am still a beginner so it will be hard enough for me. But I have already learned something from you so thanks again.
... View more
Thank you for your answer. I like it and it all works. When i apply your answer to the original file it does not work and I do not know why. If you succeed I would like to hear from you. Thanks again for the effort.
... View more
Thans for your answer. I like it and it all works. But I am still a beginner and the original file(Eems_Dollard.csv) had a starting column called "Zoekopdracht". When i apply your answer to the original file it does not work and I do not know why. If you succeed I would like to hear from you. Thanks again for the effort.
... View more
Thank you for your answer. I like it and it all works. But I am still a beginner and the original file(Eems_Dollard.csv) had a starting column called "Zoekopdracht". When i apply your answer to the original file it does not work and I do not know why. If you succeed I would like to hear from you. Thanks again for the effort.
... View more
I tried to import a file in csv format in sas but not without problem. First I did it normally like: proc import datafile=reffile out=test_Eems dbms=csv replace; getnames=yes; run; without success and I saw in the log that there could be talk of delimiter ';'. So I added delimiter ';'. proc import datafile=reffile out=test_Eems dbms=csv replace; delimiter=";" ; getnames=yes; run; I get a better result but not always correct because a column (called Bericht) contains all kinds of characters also the semicolon. Of course I get an error in the log. What surprises me is that I could open the same file without problem in Excel or a google sheet but not in Sas. I have converted the same file to an excel file using excel and I could easily read and open it in sas. My question to you is if I could open the file in Excel and google sheet then it should also work in Sas. I would like your help with that. Below are the file that I could not import in csv format but in excel and the log that I got when I tried with csv format
... View more
how can you use regular expression in sas to select the name of the website from a data and display it. Examples: A1 = google.com the result should be equal to: google A2 = http://twitter.com/Marko_met_een_K/status/1725797169897021653 the result should be equal to: twitter A3 = https://regioonline.nl/regio-den-bosch/schade-aan-stuw-lith/ then the result should be equal to: regioonline A4 = https://www.aa.com/en/how-to-regex?id=123 the result should be equal to: aa
... View more
you have column A with multiple values separated by comas and some values appear more than once in a cell. How can you copy column A into column B without duplicate values . For example. in column A: A1 = a, b A2 = A3 = c, b, c A4 = a, b, b,c,a A5 = d Column B would be: B1 = a, b B2 = B3 = c, b B4 = a, b, c B5 = d Please provide examples.
... View more
Please help with this how can you transfer data from situation 1 to situation 2? data situation 1: column A : A1 = 1 ; A2 = 2 ; A3=3 column B : B1 = 11 ; B2 = 12 ; B3 = 13 column C : C1 = allo , okay ; C2 = ; C3 = z , d , h data situation 2: column A : A1 = 1; A2 = 1; A3 = 2; A4 = 3; A5 = 3; A6 = 3 column B : B1 = 11; B2 = 11; B3 = 12; B4 = 13; B5 = 13; B6 = 13 column C : C1 = allo; C2 = okay; C3 = ; C4 = z ; C5 = d; B6 = h note that C2 is when situation 1 is empty and C3 is when situation 2 is empty so data input is situation 1 and data output is situation 2
... View more