The format and informat is not a problem. What I would worry about given your statement is the length of the variable. Make sure you are not truncating the new data to fit it into 11. ... View more

Why not just proc sql; create table result as select a.*, b.* from file2 a LEFT JOIN file1 b on b.jobname like cats('%', a.name , '%'); quit; ... View more

We store dta in Oricle all the time. It is an Oricle table and not a SAS dataset so you lose formatting etc. ... View more

If this class has a final exam, Mark is in trouble. ... View more

Scott; Do you expect him to do his own home work. Come on! ... View more

This has always been one of my pet peaves about proc report. It cannot roll up values unless they are numeric and you use a sum etc. ... View more

Without some code logs and system info we are just stabbing in the dark beyond this. ... View more

The work library is erased at the end of each session. Look up LIBNAME statement for assigning a permanent library. ... View more

359! a.member_no,a.fee,a.surnames,a.title,a.pcode,a.expiry,a.joined,a.name,a.dob,a.email,a.cn 359! tr,a.postc, 360 b.member_no,b.fee,b.surnames,b.title,b.pcode,b.expiry,b.joined,b.name,b.dob,b.email,b.cn Which member_no do you want? Pick one or rename one like b.member_no as new_member. for each variable. Try select * from d1 intersect corr all select * from d2; ... View more

You need to code error handling routines to trap and reset error codes to let your process continue. I found several papers that my help you for instance http://www.nesug.org/proceedings/nesug05/ap/ap9.pdf Google "error handling sas" ... View more

Try: proc sql; create table chr1 as select a.*,b.* from mpark1 as a INNER JOIN janjoin as b on a.surnames=b.surnames and a.pcode=b.pcode; quit; Of course you are going to have some ambiguous columns so you may have to spell out all the columns you want to keep. Message was edited by: Flip ... View more

I think you answered my question. I will have to create the link for each group of the across variable. I was hoping there was some way within REPORT to grab this. I included the code below in case you see any further ways to handle this. Thanks. PROC REPORT DATA=WORK.dashrept LS=126 PS=35 SPLIT="/" NOCENTER nofs ; COLUMN ( campidc campidc = camp commcode commcode = comm fyear,( ( "Contract"(rowr_cnr rowr_cnn rowr_cnt rowr_pct rowr_pts rowr_val)) ( "Response"(rown_cnr rown_cnn rown_cnt rown_pct)))); DEFINE CAMPIDC / GROUP FORMAT= $12. WIDTH=9 SPACING=2 RIGHT "Campaign" order=internal descending noprint ; DEFINE CAMP / GROUP FORMAT= $6. WIDTH=6 SPACING=2 RIGHT "Campaign" order=internal; DEFINE COMMCODE / GROUP FORMAT= $zcommnm. WIDTH=20 SPACING=2 FLOW LEFT "Communication" order=internal ; DEFINE COMM / GROUP FORMAT= $14. WIDTH=14 SPACING=2 FLOW LEFT "CommCode" order=internal ; DEFINE FYEAR / ACROSS FORMAT= $6. WIDTH=9 SPACING=2 RIGHT "Fiscal Year" descending; DEFINE rowr_cnr / SUM FORMAT= comma12. WIDTH=8 SPACING=2 RIGHT "RESP" style(column)={borderleftcolor=#C5BE97 borderleftwidth=6 borderbottomcolor=#CCCCCC borderbottomwidth=1 bordertopcolor=#CCCCCC bordertopwidth=1 }; DEFINE rowr_cnn / SUM FORMAT= comma12. WIDTH=8 SPACING=2 RIGHT "NON-RESP" ; DEFINE rowr_cnt / SUM FORMAT= comma12. WIDTH=8 SPACING=2 RIGHT "TOTAL" ; DEFINE rowr_pct / SUM FORMAT= percent8.5 WIDTH=8 SPACING=2 RIGHT "RESP %" ; DEFINE rowr_pts / SUM FORMAT= comma12. WIDTH=8 SPACING=2 RIGHT "POINTS" ; DEFINE rowr_val / SUM FORMAT= dollar16.2 WIDTH=15 SPACING=2 RIGHT "REVENUE" ; DEFINE rown_cnr / SUM FORMAT= comma12. WIDTH=8 SPACING=2 RIGHT "RESP" style(column)={borderleftcolor=#B6DDE8 borderleftwidth=6 borderbottomcolor=#CCCCCC borderbottomwidth=1 bordertopcolor=#CCCCCC bordertopwidth=1 }; DEFINE rown_cnn / SUM FORMAT= comma12. WIDTH=8 SPACING=2 RIGHT "NON-RESP" ; DEFINE rown_cnt / SUM FORMAT= comma12. WIDTH=8 SPACING=2 RIGHT "TOTAL" ; DEFINE rown_pct / SUM FORMAT= percent8.5 WIDTH=8 SPACING=2 RIGHT "RESP %" ; compute before campidc / style={background=#C5BE97}; line campidc $zcampnm.; holdcamp = campidc; endcomp; compute after campidc ; line " "; endcomp; compute commcode; if commcode = 'z' then call define(_ROW_,'STYLE','style={background=#B6DDE8}'); endcomp; compute rowr_cnr; href=cats("www.testurl.com?camp=", holdcamp, "?fy=", fyear, "?comp=", commcode); call define(_col_, "URLBP", href); endcomp; RUN; ... View more

Look into SQL passthrough proq sql; connect to oracle ....; execute( drop table xxx) by oracle; ... View more

ERROR: BY variable period is not on input data set INTERIM.MEMBERSHIP_PRIOR. ERROR: BY variable period is not on input data set INTERIM.MEMBERSHIP_CURRENT PERIOD does not exist. Yes you must sort by PERIOD to use a BY statement in a merge. Also the log you posted states you have no data. Is this by design to check syntax, or are you ignoring the early warnings and looking at the later error message? Start at the top of your log, and resolve each warning or error in turn. Look at the two datasets you are refering to and see why PERIOD is not in them. ... View more