Hi. A quick view your code. I think ' proc append ' + 'force' will suit for your logic. And there is also short-way which use windows command ' dir c:\*.sas7bdat /s' which will list all the sas7bdat under c:\,then using filename + pipe and data-step to extract the path-name of these sas7dbat files. Ksharp ... View more

Yes. Arthur Carpenter is right. Be careful to use LAG(), It returns the current value when Lag() executes lastly. And there is short way to use function DIF() which stands for date - lag(date). Ksharp ... View more

Hi.polingjw The code can change somewhat. Sorry.I am wrong. Ksharp Message was edited by: Ksharp ... View more

Hi.Or maybe you need this.BTW 'bookmark=no' is worked for me ,It is weird. Cynthia is right. [pre] ODS PDF FILE="c:\report.pdf" nobookmarklist nobookmarkgen; [/pre] Ksharp Message was edited by: Ksharp ... View more

From your log ,there is some illegal character for your SAS. And I also meet this problem before. Can you extract some first several observations from this dataset successfully? Such as [pre] data temp; set tableA(obs=2); run; [/pre] If It can. Then use [pre] proc report data=tableA nowd out=New_TableA(drop=_break_); column coulmnA; define coulmnA/display; run; [/pre] to transfer to new SAS. This is just a.recommendation Ksharp ... View more

Hi. In SAS,there is SUM statement ( i.e variable+increase ) , And sum Function also can do it. Just need to continuely cumulate this variable. Ksharp ... View more

Hi.Cynthia. I guess view this PDF under SAS explorer. If you open this PDF from disk by pdf-reader,then bookmarks will disappear. ... View more

Yes. You are using the datasets created by different OS and SAS ,So Conflict will appear. There is two methods. 1)use 'proc migrate' to migrate the datasets from previous SAS datasets to current SAS datasets.(Under current SAS environment ) 2)At the OS and SAS which created datasets ,use 'proc cport' to make a transported file. then transfer this transported file to current SAS by FTP or TAPE ...... and Under current SAS environment ,use 'proc import' to change this transported file into datasets with current version of SAS. Ksharp ... View more

[pre] data temp; input Dates : date9. Item $; format dates date9.; cards; 01APR2010 A 01APR2010 B 01APR2010 C 05JUL2010 A 20JUL2010 E ; proc sql feedback; select distinct dates from temp; select distinct dates into : date1 - : date&sqlobs. from temp; quit; options mprint mlogic; %macro create_tables; data %do j=1 %to &sqlobs.; output_item_&&date&j %end; ; set temp; select ( dates ); %do i=1 %to &sqlobs.; when ("&&date&i"d) output output_item_&&date&i; %end; otherwise; end; run; %mend; %create_tables [/pre] Ksharp Message was edited by: Ksharp ... View more

Hi. There is a option ,But I am not sure whether it is what you need. [pre] ODS PDF FILE="c:\report.pdf" bookmark='no'; [/pre] Ksharp ... View more

Are you chinese guy? >either for the variable name or the cell inside You can import Chinese word just to initialize SAS with Locale encoding or use Chinese version of SAS. moreover,SAS also allow you to use Chinese Word to be variable name ,just to use system options [pre] options validvarname=any; [/pre] But it is only applicable for SAS/Base and SAS/Stat. For your append problem,I am afraid you need to change variable name in table2 ,and can use proc append + force to enhance efficient. Ksharp ... View more

%put &syssite; ... View more

Or another choice. [pre] options mprint mlogic symbolgen; %let start_date = %sysfunc(putn(%eval(%sysfunc(intnx(week, %sysfunc(today()), -1))-1),DATE9.)); %let end_date = %sysfunc(putn(%eval(%sysfunc(intnx(week, %sysfunc(today()), 0))-1),DATE9.)); %put _user_; [/pre] Ksharp ... View more

Hi. I have another way.Just to be a choice. [pre] data i; input Entered mmddyy10. Br $ Grp $ Name & $20. id srvc $ Agt; format Entered mmddyy10.; datalines; 11/03/2010 LA CP Lisa Eberman 12345 LA 6782 11/03/2010 LA CP Lisa Eberman 12345 LA 6166 11/03/2010 LA RP Lisa Eberman 12345 LA 6686 11/03/2010 LA RP Lisa Eberman 12345 LA 6633 11/03/2010 LA RP Lisa Eberman 12345 LA 73660 11/03/2010 LA RP Lisa Eberman 12345 LA 6231 11/03/2010 LA AP Lisa Eberman 12345 LA 1234 11/03/2010 NY RP Ella Temp 56789 LA 6231 11/03/2010 NY RP Ella Temp 56789 LA 6232 11/03/2010 NY MM Mark Wise 09876 NY 64621 11/03/2010 NY MM Mark Wise 09876 NY 64605 11/03/2010 NY MM Mark Wise 09876 NY 64589 11/03/2010 NY MM Mark Wise 09876 NY 64588 11/03/2010 NY MM Mark Wise 09876 NY 64586 11/03/2010 NY AB Liza White 19876 XY 64588 11/03/2010 NY AB Liza White 19876 XY 64586 ; run; proc sort data=i; by entered br grp ; data result; set i; by entered br grp; length whole $ 200; retain whole; if first.grp then call missing(whole); whole=catx(',',whole,agt); if last.grp then output; run; proc print noobs; run; [/pre] Ksharp ... View more