On the left side of SAS STUDIO I see only Solaris Files, not C drive.
Q: Would it be best for me to use ODS to create excel file and then use EMAIL to have SAS send it to me?
I need a reality check here, something simple I can achieve today.
Thanks!
... View more
Mistake me thinks.
Quick commenting Wrap selection (or current line) in a comment: Ctrl + / Unwrap selection (or current line) from a comment: Ctrl + /
(it worked as a toggle for me)....
... View more
i was hoping for a solution of this variety (which doesn't work...)
After 5 years of sas work, I am still clueless on dates.....
data _null_;
format dt mmddyy10.;
dt= date();
call symput('dt',trim(left(input(dt,mmddyy10.)));
run;
%put &dt;
run;
... View more
MPRINT(GET_CURRENT_DATA): proc sql;
MPRINT(GET_CURRENT_DATA): create table prim_raw.seg_info(index=(seg_id)) as select a.* from prmviews.seg_info a, tmp b where
a.seg_id = b.seg_id ;
INFO: Index seg_id of SQL table ISHDATA1.SEG_INFO selected for SQL WHERE clause (join) optimization.
ERROR: File PRIM_RAW.SEG_INFO.DATA is not a SAS data set.
MPRINT(DRIVER): libname prim_raw "/mktg/prcxx/app_scratch/xxx_audit/xxxxxxx/prim/raw";
NOTE: Libref PRIM_RAW was successfully assigned as follows:
Engine: V9
Physical Name: /xxxx/xxxxxx/app_scratch/xxx_audit/xxxxx/prim/raw
... View more
In reading a dataset using sas9 or EG7.12 , I get the error. (attached, but seg_info.sas7bndx didn't copy correctly....)
It is very infrequent. I would like to understand what I might do to prevent it in the future?
Any insight appreciated.
Thanks!
Jim
... View more
it is 31 million rows. If I put in "top 1", it works, so it is mad about the size. Also, If I do it in Teradata SQL Assistant, it loads all 31 million rows with no problem. Thanks for helping. I am stumped! Jim
... View more
proc sql;
connect to teradata (MODE=TERADATA user=xxxxx password="xxxxx" tdpid='xxxxxxxxxxx' connection=global);
execute(
insert into BLAH_DB.table
select
*
from blahdb.othertable cst inner join otherdb.tablec ch on cst.cust_acct_nbr = ch.cust_acct_nbr
) by teradata;
ERROR: Teradata execute: No more room in database BLAH_DB.
... View more
how? I have tried... Send me a screenshot picture perhaps of where the SOLVED button is located... My old eyes can't seem to find it!
Thanks!
... View more
