I am running the following code: proc export data=work.data      outfile='C:\test.csv'      dbms=csv replace;      delimiter=';'; run; The column names are pretty long and so it is wrapping the first row.  I do not want it to wrap. Example of what is happening: column1;column2;column3;column4;column5; column6;column7 What I want: column1;column2;column3;column4;column5;column6;column7 After the 99th character it begins to wrap. Any help with this would be appreciated. ... View more

Is it possible to raise a dbevent in SAS? Normally the code would be something like this in Ingres: raise dbevent test and it would trigger the processing of data within Ingres. Any help with this would be appreciated. ... View more

I have the following code to create an ods listing with a semi-colon delimiter.  When I do this, it does not include the column names from my table "test" How do I include the column names? options nodate nonumber; ods _all_ close; ods listing; data _null_; file print dsd dlm=';' ; set library.test; put (_all_) (:); run; ... View more

I want to write code similar to what the "export as a step in project" wizard does in Enterprise Guide. I have the code to create the csv file with the delimiter ';' proc export data=home.data outfile='D:/testing/test.csv' dmbs=csv replace; delimiter=';' ; run; What I would like is to print the csv file within Enterprise Guide not just save it on the D:\ drive.  Similar to what the wizard does in "export as a step in project".  I would use the wizard, but I do not have the option to select a semi-colon. Could I use proc import at this point?  Thanks for your help in advance. ... View more

I am using the datastep to read in a text file.  Each text file has a distinct filename.  I'm unsure how to bring the distinct filename for each record into the table? Here is my code: libname YOKOGAWA "D:\***\*****\****\YOKOGAWA"; FILENAME NORM 1 \\**\***\SAS DATA NORMALIZER 1\NORMALIZER 1*.txt ; data YOKOGAWA.NORM_1_YOKOGAWA %let _EFIERR_ = 0; /*set the ERROR detection macro variable/* infile NORM1 delimiter = ',' MISSOVER DSD lcrecl=32767 firstobs=20 EOV=SKIP; informat yok_dttm ANYDTDTM23.; informat fpm best32.; input @; /*if skip then skip=0; else do; */ if skip then do; skip=0; input #19; end; else do;      input           yok_dttm           fpm ; output; end; if _ERROR_ then call symputx('_EFIERR_',1); RUN; ... View more