Dear All,   I am creating 6 sgplots.png, which are all fdisplayedon one pdf file. the output pdf file is showing PAGE XX OF YY on each page in footnote. How can I remove this ?   Thankyou,   ... View more

Dear All,   I am creating 6 sgplots.png, which are all fdisplayedon one pdf file. the output pdf file is showing PAGE XX OF YY on each page in footnote. How can I remove this ?   Thankyou,   ... View more

I received this request from FDA , to generate a site level listing. For example, if its an  Adverse event listing, so they want all AEs to subjects from that site first and then page break by nest site and so on, whih is okay. I can use page break option by site. But the catch is, they want to reset the page no as well for the next site. I don't know how to do that. For example, they want page 1 of page 10 for next site in the same file. Is there a way we could do that? Also, is their any option which can create a table of content for all those sites in pdf, so that i can click on the link in TOC, and go to that site? I am using proc report to generate the listings. Your inputs are really appreciated. Thanks, Megha ... View more

Hi, I have to create a tab delimited txt file from excel using sas. Does anyone has any idea how can i do so, without creating any intermediate datasets? Some of the cells in excel has values like 1.00, which have a format in excel cell. When i import this excel in dataset, SAS changes 1.00 to 1. I am working on UNIX. I have tried 1) Putting character values in the first row. so that SAS reads it as character and doesnt convert it. But still it does . 2) I cant use SAS libname statement in my case (due to some other issues) Any idea! Thanks! ... View more

Hi, Proc export is truncating the length of columns for more then 256 characters.Now I found this note on SAS website: http://support.sas.com/kb/34/119.html Itsays:To circumvent the problem, export the file as a tab-delimited text file and import that text file into Excel. I understand exporting the file to tab delimited text file. But then how would I automatically convert this tab delimted file to excel? Any ideas?Mine is UNIX system, and I cannot use SAS libname statement. I can use ods html to create excel, but ui have values like 0.80,0.90 and ods is converting them to 0.8 and 0.9 respectively.... ... View more

Hi, I want to see the code generated by proc export while exporting my xls file. How can i get it?I dont see it in my log. The code is like: But what if I am using it an excel file instead of csv. What should be the delimiter value in that case?(This code is copied from somewhere else) data _null_; 9357 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 9358 %let _EFIREC_ = 0; /* clear export record count macro variable */ 9359 file 'c:\test.csv' delimiter=',' DSD DROPOVER lrecl=32767; 9360 if _n_ = 1 then /* write column names or labels */ 9361 do; 9362 put 9363 "x" 9364 ',' 9365 "y" 9366 ',' 9367 "z" 9368 ; 9369 end; 9370 set DS1(keep=x y) end=EFIEOD; 9371 format x best12. ; 9372 format y best12. ; 9373 format z best12. ; 9374 do; 9375 EFIOUT + 1; 9376 put x @; 9377 put y @; 9378 put z ; 9379 ; 9380 end; 9381 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 9382 if EFIEOD then call symputx('_EFIREC_',EFIOUT); 9383 run; ... View more