Or go down the correct route, build a data transfer agreement which both the sender and you agree to which details what data should be sent, what the strcuture of the data should be, also wether is will be cumulative or incremental, and fix the data transfer type using a proper data transfer file format - CSV, XML dataset etc. That way you can write a simple datastep import to properly process the data into a useable format according to a documented process, and it is reproduceable. Using Excel and proc import is the bigget method to failure and the reason why we see so many questions on here about messy data - it hasn't been processed correctly in the first place.
... View more
Yes, you did not fully inspect my code. You need to put quotes around the call in the call execute. Call execute accepts a string and passes it out as text. So yes, it would change color.
... View more
Yep, under Format action menu item there is an option for Word Wrap. If you do get this and its not just the text editor, you can always check with a hex editor (plenty of free ones out there), and what you would see is 2 codes, 0a and 0d which are tab and line feed.
... View more
Using the documentation provided by FriedEgg, the following works proc sql; connect to odbc (dsn=*****82); execute (raise dbevent test) by odbc; disconnect from odbc; quit;
... View more
Adding notitles will work to suppress the title as well. But, it still does not circumvent starting to print data on the second line of the text file.
... View more
If you wish to use the data step, you need to use the MODIFY statement, see on-line doc and samples on support.sas.com. You could also use SQL (which your syntax looks like), but then you need to do a correlated sub query. Again, search support.sas.com.
... View more
Why not do it in data step ? data have;
input num date : mmddyy10. hrs ;
format date mmddyy10.;
cards;
1 3/3/14 .
1 3/3/14 9.5
1 3/3/14 .
1 3/3/14 .
2 3/4/14 7.9
2 3/4/14 .
2 3/5/14 .
2 3/5/14 .
;
run;
data have;
set have;
by num date;
s+hrs;
if last.date then do;daily=s; s=.;end;
drop s;
run;
Xia Keshan
... View more
Perhaps you could try specifying a cursor type like KEYSET_DRIVEN: http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#p1pdx0nznnifhhn1rwx52vo3o3ov.htm Might also be worth raising a Tech Support track.
... View more
Hiya, Create the following macros using your &date one to subset: data _null_ ; call symput('fstart',intnx('year.4',&date,0,'b')) ; call symput('fend',intnx('year.4',&date,1,'b')-1) ; run ; cheers Steve
... View more
