Unix tools like SED and AWK, Perl, too, I think, have provisions for remembering the "found" string and then altering it, like changing lower case to upper case, leaving all numerics alone and deleting the characters, etc. Probably a little to specialized for an IDE editor. ... View more

Batch job? At our site, the JOBNAME and JOBID are used to name temporary SYSOUT datasets, so the following code works nicely without all of the peeking around. //JOBNAME JOB (ACCTINFO),'DUMMYJOB ' //STEP1OF1 EXEC SASMVS,SASLOG='*',SASLIST='*' //JOBINFO DD SYSOUT=* /* DO NOT CHANGE...USED TO GET JOBID */ //SYSIN DD * PROC SQL NOPRINT; SELECT SCAN(XPATH,2,'.'),SCAN(XPATH,3,'.') INTO :JOBNAME SEPARATED BY ' ', :JOBID SEPARATED BY ' ' FROM DICTIONARY.EXTFILES WHERE FILEREF = 'JOBINFO'; QUIT; %PUT !&JOBNAME!&JOBID!; Just checked...works for interactive SAS on TSO, too. ... View more

Need more information...code would be nice...what platform (windows, mainframe, unix). Is xxxxx a SAS catalog, SAS library, ...? ... View more

I like Flip's straightforward nonmacro approach, partly because I often use similar code. Yes, it can be done with a macro, but why make it so difficult? ... View more

Another simple solution is this case is to use 200905 and 200906. ... View more

Try using the LIBNAME EXCEL engine (this might be a more convenient option than IMPORT, anyway) like: 52 libname excel excel "&my_docs\excel\111temp.xls"; NOTE: Libref EXCEL was successfully assigned as follows: Engine: EXCEL Physical Name: \\company.com\users\bldg\userid\My_Documents\excel\111temp.xls 53 proc sql noprint; 54 create table excel1 as 55 select libname,memname 56 from dictionary.tables 57 where libname = 'EXCEL'; NOTE: Table WORK.EXCEL1 created, with 2 rows and 2 columns. 58 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.04 seconds cpu time 0.03 seconds 59 data _null_; 60 set excel1; 61 put _all_; 62 run; libname=EXCEL memname=Sheet1$ _ERROR_=0 _N_=1 libname=EXCEL memname=Sheet2$ _ERROR_=0 _N_=2 NOTE: There were 2 observations read from the data set WORK.EXCEL1. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 63 libname excel clear; NOTE: Libref EXCEL has been deassigned. ... View more

Or, data temp (keep = customer_skey customer_id) ; set fdw.customer; if missing(input(customer_id, ??8.)) then delete; run; ... View more

if you are generating this table in a data step, you could create a retained variable to count the number of time that x is missing and then on the last observation, compare that variable with _n_ and if they are equal conditionally execute a data step to drop that variable...like: data xyz; set abc(keep=x y z) end=lastone; retain x_missing 0; x_missing = x_missing + missing(x); if lastone then do; if x_missing = _n_ then call execute('data def;set xyz(keep=y z);run;'); end; run; ... View more

Okay, I get it... Very useful, but I might have called it "Remove trailing blanks". Oh well, that's just me. Thank you. Al ... View more

You do know that, by default, Ctrl + / and Ctrl + Shift + / comment and uncomment a line, right? ... View more

Do you want to create the datetime value to a new variable with just the date portion, or are you only interested in displaying the year/month portion of the datetime? If the latter, then you'll need to do the picture format as suggested by Christopher. If the former, then you can do something like: justdate = datepart(dtvar); format justdate yymmn6.; ... View more

Have you tried using ODBC to read the spreadsheet? ... View more