About Inp

Inp · ‎10-16-2012

Hi Dear, I want to read this below two dates and have to find the total time difference between these below dates.( I mean how long it took from date1 to date2: want to know hour, min, and sec); What is the informat that I have to use and what the SAS function will return the difference.between date1 and date2 in Hour , Min and Sec. Date1 Date2 2012-04-18 18:21:48.463 2012-04-20 22:06:46.753 Thanks for your help in advance. Dony.

Inp · ‎04-19-2012

Dear Sir / Madom, Yes please provide more details. Thanks Inpan

Inp · ‎04-19-2012

Thanks very much Cynthia. This solution is great to me. Thanks again. Regards, Inpan

Inp · ‎04-18-2012

Thanks very much Cynthia, So there is no way to do left and right align for two titles to be appeared in the same line. Because I have to create a program which can create an excel spread sheet with such display not as dispaly as in the Print . In such case, all I have to create title only one line of long length title. Thanks Inpan

Inp · ‎04-18-2012

Hi Dear, Here is my simple coding which create xml sheet. ods tagsets.excelxp file="c:\temp.xls" options(print_header='&L' embedded_titles='yes'); proc print data=sashelp.class noobs; title 'Header1 left' ' Header2 right'; run; ods tagsets.excelxp close; I am currently using SAS 9.3 on Windows.XP I want the header1 to be appeared on the left and Header2 to be appeared on the right but in the same line. I am so tired of it make this successfull. when I put j=l 'Header 1 left' j=r ' Header2 right'; It brings the header1 on the left and the header2 to the right but header 2 appeared on the next line. How can I make them header1 to left and header2 to right on the same line. Thanks very much for your help in advance. Regards. Inpan

Inp · ‎10-27-2011

Hi Cynthia, Thanks very much. It resolved my problem. Accourding to my design, the logo is pretty much small and the data on all proc /output will be same number all the time. But you solution is amazing. I have the book that you wrote ' Output Delivery system , The basics and Beyond' . It is amaizing book. It does have the solution that you mention but I never thought of using ods text to bring the second logo in the report. you are so amazing. Thanks very much Cynthia and Scott. Regards Inp

Inp · ‎10-26-2011

Hi Yes your right which I need but it doesn't print title2 when I put right above the proc print. Can you please check if some thing wrong with my coding. It doesn't print any title3 or title4 at the proc print. I am using latest SAS 9.2. Thanks Attached my output.

Inp · ‎10-26-2011

Hi Milton, Thanks for your reply. but what I need is , want the print second logo right above the second report and below the first report. If I put exactily the way you told me, it print both logo at the very top of the report. Thanks Inp

Inp · ‎10-26-2011

Hi Dear, Here is my coding. I want the both output from Data _null_ and proc print to be print on the same output page and want to print the company logo on the both title. My below coding print only one title. Can any body help me to print the second logo as well. Thanks very much in advance for your help. Thanks Inp data temp1; input @1 x $30.; cards; mytestdata ; run; data temp2; input @1 x $1.; cards; a c d c d ; run; ods pdf file="c:\mytest.pdf" startpage=no; ods escapechar='^'; title '^S={just=l preimage="c:\My_company_logo.gif"}'; OPTIONS FORMCHAR="|----|+|---+=|-/\<>*"; data _null_; set temp1; file print ods; put _ods_; run; title '^S={just=l preimage="c:\my_company_logo.gif"}'; proc print data=temp2; run; ods pdf close;

Inp · ‎09-22-2011

Thanks very much Arthur. It resolved my problem. Antony

Inp · ‎09-21-2011

Thanks Arthur. It is my typo. I tried with 4255 with the record lenght as well and put the recfm=f. but the problem is it is writting the second record very far. It is not write 2nd record at the 4256 column. or row after 4256 column. thanks Anton

Inp · ‎09-21-2011

Hi Dear, I am writting a SAS dataset to a file. Accourding to my coding , it doesn't write the 2nd and continues records properly in the output file. when I put recfm=v, it does write properly on file. Can any one tell the reason for this. or Am I doing right if put recfm=v? LIBNAME SWXTEST 'C:\mylib\MAY2011'; FILENAME SWXTEST1 'C:\v_sas_mytest.txt' ; DATA _NULL_; file swxtest1 LRECL=4046 RECFM=F ; set swxtest.v_sas_temp(obs=100); PUT @ 1 APPID 8. @ 9 APPTITLE $100. @ 109 ORIGINBRANCHID $6. @ 115 ORIGINOFFICERID $1. @ 116 PRIBORTYPE $1. @ 117 PRIBORID 8. @ 125 INSTANTRESP $1. @ 126 DATEAPPENTRYSTART datetime20. @ 146 PERSONNELID 8. @ 154 APPLICATIONSOURCE $20. @ 174 FRSTNAM $15. @ 189 LSTNAME $25. @ 214 EMPLOYNUM 8. @ 222 ATTACHREQ $3. @ 225 APPLICATIONTYPE $4000. @ 4225 SWXVAILABLEREVOLVINGCREDIT 10.2 @ 4235 SWXRETURNEDTOBRANCH $1. @ 4236 SWXTOTALCREDITSTOCONNECTIONS 10.2 @ 4246 SWXCONNECTEDBUSINESSCREDIT 10.2 ; run; Thanks very much in advance Antony

Inp · ‎06-10-2011

Hi Dear I am using (SAS Release Software 9.2 (TS2M3) believing latest version. When I use the below stamtent/s libname flexlib 'C:\PROJECTS\flex'; proc copy in=flexlib out=work; run; It copied all the datasets except format. Do I have to installed any patch to fix this issue. I tried may ways : proc datasets as well. but it copied everything except formats.. When I check the folder C:\PROJECTS\flex, I see the format : formats.sas7bcat When I use the previous verion SAS : Software 9.2 (TS2M0) , I didn't have any problem like this. Thanks so much for your help in advance. Tony

Inp · ‎01-20-2011

Hi Dear below is my test coding. I am trying to put pagebreak on every 50 rows. of my excel spread sheet . how do I do it? thanks for your help in advance regards Inp ods tagsets.excelxp path='C:\PROJECTS' file='mytest.xls' style=statistical options( DOC='HELP' ); proc sort data=sashelp.class out=class; by age; run; proc print data=class; run;

Inp · ‎10-27-2010

Hi Tim When I put compute x, it put color(background blue) for all rows. But my interest in only the row when x='b'. Thanks a lot for your help. Thanks Inp

Online Status	Offline
Date Last Visited	‎03-06-2025 12:26 PM

Re: INFORMAT TO READ COBOL field of a FILE for S9(11)V99

INFORMAT TO READ COBOL field of a FILE for S9(11)V99

Re: How to handle the missing value in the Scan function ?

Re: How to handle the missing value in the Scan function ?

How to handle the missing value in the Scan function ?

Re: ODS TAGSETS.EXCELXP Loading 17 digits length number , truncating o...

Re: ODS TAGSETS.EXCELXP Loading 17 digits length number , truncating o...

ODS TAGSETS.EXCELXP Loading 17 digits length number , truncating or ch...

Want to mask the character '&' in the Marco.

Re: How do find the very last page in proc report in ODS Pdf and wirte...

Re: ODS TAGSETS.EXCELXP Loading 17 digits length number , truncating o...

Re: What is the informat for date and time field

Re: What is the informat for date and time field

Re: What is the informat for date and time field

Re: ods excelxp : Left align , Right align two titles on the same line

Re: How to handle the missing value in the Scan function ?

What is the informat for date and time field

Re: ods excelxp : Left align , Right align two titles on the same line

Re: ods excelxp : Left align , Right align two titles on the same line

Re: ods excelxp : Left align , Right align two titles on the same line

ods excelxp : Left align , Right align two titles on the same line

Re: How do I create 2nd logo in my title

Re: How do I create 2nd logo in my title

How do I create 2nd logo in my title

How do I create 2nd logo in my title

Writing to a file from sas dataset .. Problem with lrecl= and recfm=?

Writing to a file from sas dataset .. Problem with lrecl= and recfm=?

Writing to a file from sas dataset .. Problem with lrecl= and recfm=?

copying formats

cutomize pagebreak in excelxp tagset?

Re: How to customize the background color for a row using Excelxp in a...

SAS Analytics Explorers