About Sudhakar_A

suraj · ‎05-30-2017

Hello @Sudhakar_A, I am also getting the same error while submiting a code in rsubmit, Can you help me with this. Thanks! Regards, Suraj

Norman21 · ‎06-09-2016

Although this is an old thread, I can confirm that Cynthia's solution works with SAS 9.4 64 bit and Microsoft Office 32 bit. Specifically, use LIBNAME XLSLIB pcfiles path="C:\My SAS\myfile.XLS" instead of LIBNAME XLSLIB "C:\My SAS\myfile.XLS"

TriciaAanderud · ‎10-14-2015

I kept getting an error that Word could not understand my formatting. I realized that it is "\TCL" and not "TC1" after nearly pulling my hair out.

Linlin · ‎05-24-2013

Too bad I have to learn Hash now:smileysilly:. Thank you again! - Linlin

Astounding · ‎04-20-2013

Are we making a simple problem difficult? Does this do what you want: data want; set have; by child date; if first.date then same='N'; else same='Y'; run; If this isn't what you want, you might have to give an example or two of what you are looking to get. Good luck.

Ksharp · ‎04-20-2013

It is easy : data want; if _n_ eq 1 then set mean_data; set have ; score=coalesce( score ,mean_score) ; forum=coalesce( forum,mean_forum); ........... run; Ksharp

Sudhakar_A · ‎04-09-2013

another simple method. data fin; merge one two(rename=(income=income1)); by name; avgincome=mean(income, income1); run;

JohnT · ‎02-15-2012

Thanks Tom, I think I had a brain snap yesterday. Worked perfectly as described.

RickM · ‎05-25-2011

It is possible to use UTF-16 encoding and the hexadecimal code ( var='03b1'x; ) but there is no way to ensure that it will appear correctly for someone else. I would suggest contacting tech support to see if they have a solution.

sbb · ‎09-18-2009

Suggest reviewing the SAS Companion for Windows - it mentions the ability to drag selected file(s) into an active SAS session's LOG window and SAS will then prompt you to "Submit". Unfortunately, you will not get your individual program's SAS log created in a separate file for each program, as it occurs when executing SAS batch requests. Regarding your "log check" macro - you can explore using PROC PRINTTO and also the ALTLOG= OPTIONS parameter to re-direct your SAS log output to a file for whatever parsing and validating you want. Scott Barry SBBWorks, Inc.

Sudhakar_A · ‎07-06-2009

Thank you for the effort, But i dont want to put the title and foot note in the Header section of the RTf file because i need to append all the table outputs and i have to create a TOC for that.

Ksharp · ‎10-14-2014

Check @Arthur.T and @data _null_ 's paper : http://support.sas.com/resources/papers/proceedings12/238-2012.pdf

Sudhakar_A · ‎11-14-2008

I have already posted the problem to SAS. I found the cause for that and i made one work around. Cause : I am doing the initializing of the ods path and macro path once in the setup file. and calling this setup program in all the program because of that it is giving error. Work around: In Setup file i have checked the existence of library before libname statement. Now it is working fine .. Thanks for the effort and suggestions Sudhakar

jschaffn · ‎11-03-2009

Great - thank you!

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Emailing the contents of the program editor window

Re: How to add non-macros to macros?

Re: How can I get what I want?

Re: Array subscript out of range

Re: How to create a TransactionId field, Please Help. Many thanks

Re: How to create a TransactionId field, Please Help. Many thanks

Re: How to create a TransactionId field, Please Help. Many thanks

Re: How to delete one line from multiple SAS programs?

Re: Macro statement %put and log

Re: Create a macro variable based on another dataset

Re: How can I get what I want?

Re: datastep - ERROR: An exception has been encountered

Re: Libname error with excel engine

Re: TOC creation in ODS RTF

Re: How can I get what I want?

Re: Comparing a variable from one record to the previous record

Re: I have 2 data sets one with mean value for each variable(proc mean...

Re: Calculate the average value from two data sets when occurs duplica...

Re: Saving formatted numbers at text

Re: How to present Alpha character in dataset?

Re: Batch execution from context menu

Re: Page number in Body part of RTF file

Re: How to read rtf files to sas dataset

Re: Unable to clear the library because it is still in use

Re: Version Controlling of SAS Program