Hi all, Im using the EG over a Citrix Client from my windows pc. I would like to open a folder located on windows within the EG. (I would like to open this folder and read all items (csv-files) in it for further processings) Am I unable to access the windows folder from two different environments? Here are essential lines of code: %macro read_directory(); %let path = I:\xxx\xxx\xxx\xxx\xxxxx; %global lstname; %let member = 1; filename dir "&path\*"; %let filrf = mydir; %let rc=%sysfunc(filename(filrf,&path)); %let did=%sysfunc(dopen(&filrf)); %let memcount=%sysfunc(dnum(&did)); %if &memcount > 0 %then %do;     %do %while(&member le &memcount);          %let lstname=%sysfunc(dread(&did, &member));     %end; %end; %let rc=%sysfunc(dclose(&did)); %mend; %read_directory; But the path resolves to: ERROR: Physical file does not exist, /opt/sas/config/Lev1/SASApp/I:\xxx\xxx\xxx\xxx\xxxxx; Im pretty new in accessing data from different machines- i hope some of you can help me how to tell the EG that its has to refer to windows only ... View more

Hi all, during my work i came to a question that bothers me a lot. Assuming that i have a table with dupllicate values like: Table: Col1       Col2 123          456 123          456 456          789 456          888 Now i would like to delete all values from Table that are completely identical considering all columns. (vIts very important that all columns are viewd of duplictes and not only col1) How do i do this in an efficient way? I got an solution that consist of miles of code....its not efficient, simple and good in any way. I mean if i use a proc sort with no duprecs, sas deletes only 1 to n duplicate values and not all. Considering the table above wirh no duprecs or a control break (first. last. operator) there still will be one of those n duplicate values. Is there any efficient solution to my qustion or do i have to any poor solution by myself? Hope someone can help. Thanks and regards s ... View more

Hello all, i have a question about proc compare. i know the eg section isnt the right one but i would like to put it here because i dont know if there are any differences between z/os /windows/unix in sas.... well it doesnt matter for my question. if i'm absolutely wrong here please move this entry. now to my question: i would like to know how many rows are equal and unequal... well thats not the problem. the problem is how proc compare visualizes the results. i used a simple proc compare: proc compare base=work.old compare=work.new outall out=work.equal; run; and i get something like this Type                  OBS        Timestamp BASE                  1    12/19/2013 06:00:04.010 COMPARE           1    12/19/2013 06:00:04.010 DIF                      1    .............................................. PERCENT            1    .............................................. i dont like the way proc compare visualizes the results. i think the ".................." for equal datasets are uncomely to handle and very error-prone. is there a way to get the results shown more comfortably? Any other possibility to visualize that there are differences or no differences? Something like this: Type                  OBS        Timestamp BASE                  1    12/19/2013 06:00:04.010 COMPARE           1    12/19/2013 06:00:04.010 DIF                      1    none / 0 / equal PERCENT            1    100% Evenn if there are differences the visualization is horrible: BASE               1    12/19/2013 06:00:04.010 COMPARE        1    12/19/2013 06:00:03.947 DIF                   1    ..................X.XXX....................... PERCENT         1    ..................X.XXX....................... I checked the proc compare options offered by sas: Base SAS(R) 9.2 Procedures Guide but i cant find any useful.... thanks for the help and kind regards, s ... View more

Hello Community, Environment: Enterprise Guide on UNIX via CITRIX over a Windows XP PC. Situation: I have serveral .CSV files located in /aaa/bbb/ccc/ddd Now i would like to read all CSV files from this folder into a SAS table. I only want to read the FILENAMES not the content. I cant use "call system" or "filename x pile ..:" Statements. (Permissions) I found another option by using the dopen() function. When i try to open my file the dopenfunction returns a zero (file not found) In the LOG  all files are accessed (see LOG) Question: I dont know what am I doing wrong? (im not having so much experience) but why cant dopen open the directory and output my files. Sourcecode %let path = /aaa/bbb/ccc/ddd; filename dir "&path/*"; data content;     did=dopen("dir");    if did eq 0 then do;     infile dir length=linelen;         input dir $Varying200. linelen;    end;    else do;      msg=sysmsg();       put msg;    end; run; filename dir clear; LOG: NOTE: The infile DIR is:       Filename=/aaa/bbb/ccc/ddd/2013-12-06-A.CSV,       File List=/aaa/bbb/ccc/ddd/*,      NOTE: The infile DIR is:       Filename=/aaa/bbb/ccc/ddd/2013-12-06-B.CSV,       File List=/aaa/bbb/ccc/ddd/*,   NOTE: The infile DIR is:       Filename=/aaa/bbb/ccc/ddd/2014-03-18-B.CSV,       File List=/aaa/bbb/ccc/ddd/*,   NOTE: The infile DIR is:       Filename=/aaa/bbb/ccc/ddd/2014-03-19-A.CSV,       File List=/aaa/bbb/ccc/ddd/*,      WANT: I want exactly this: 2013-12-06-A.CSV or the whole path /aaa/bbb/ccc/ddd/2014-03-19-A.CSV in my table can someone help me? I'm desperate... Thanks ... View more

Hi all, i would like to know which advantages a surrogate key provides in comparison to a normal functional key which depends on attributes in the data. Therefore i like to know how to use a surrogate key in a professional way. Do a surrogate key provides advantages in all database schemas or in some special ones like the star or snowflake schema? Anyone knows what SAS thinks where and when to use a surrogate key? All information i found on the interweb approaches a surrogate key with a negative attitude of their missing reference to attributes. Hope someone can explain the use of such keys to me and the way SAS would use them. Personally i'm torn between technical keys and functional keys.... Greetings, S ... View more