Hello,   Does anyone know exactly where to drop data mart tables for autoloading in SAS VA? I dropped the ones I have in the AutoLoader folder and ran the script in the Windows task scheduler. However, the last time they autoloaded in VA was 2 days ago even though there is new data i those tables. Am I suppose to drop them in the EVDMLA folder?   Sincerely, Betty ... View more

Hello everyone,   I hope ya'll having a good day today? I was hoping someone could spare me a minute and help me figure this out. As I am trying to import a file into DI Studio I get this error message and I have never seen it before. What does it mean?   "ERROR: Invalid string. FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase."   Sincerely, Betty ... View more

Hello everyone,   I'm doing an excerise where I'm trying to create a list with names that "sounds alike" och with a different spellibg ("Smith" and "Smythe" or "AAron" and "Aron"). I only have 1 table to look through and tried a very simple excerise where I hard-coded a name on which the program will look at to find names that sounds like it (see below):   proc sql; create table soundex as SELECT EfterNamn FROM Person WHERE SOUNDEX('Munson') = SOUNDEX(EfterNamn); quit;   There are two names in that table that sounds like Munson (Munksson and Munkson) and therefor a list is created with only those names. However, I want a code that is applied on all the names in that table for a list to be created with those names, whether it's Munson and Munksson or Anderson and Andersson. I've tried to find an example online, but only seem to find examples where they use a soundex on two tables... Has anyone done this before? If so, can anyone help me out a little? 😃   Sincerely, Betty ... View more