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

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