About suraestar

suraestar · ‎02-14-2014

Hi, Thanks, but I have only 9.3 version of SAS. So how could I do?

suraestar · ‎02-13-2014

Hi there, I want to insert multiple graph file into a single HTML file. I am using GTL(proc template and SGRENDER procedure) to generate graphs. How can I do this with PROC GREPLAY or Is there any other way? Thanks in Advance. Surendar.

suraestar · ‎01-27-2014

Hi there, Thanks, but i would like to compare the data with formats applied. Is there anyother options (in PROC COMPARE) or method to compare the formatted datasets. Thanks

suraestar · ‎01-22-2014

Hi I am getting the below error message when i compare two dataset using proc compare. WARNING: The requested format could not be applied successfully because the Value Comparison Results report restricts the variable's column width to 9 and this format requires a larger minimum width. please help me to solve this. CODE: data a; b=4244; format a b is8601da.; run; data b; b=3213; format a b is8601da.; run; proc compare base=a comp=b maxprint=(30,20); run; PLs find the attached output.

suraestar · ‎06-14-2013

Thanks Keith...

suraestar · ‎06-14-2013

Yes, my output is correct. but i need the expected output.. Since i will be using some process based on that dataset..

suraestar · ‎06-14-2013

How to Obtain **OTHER** Format values ??? Consider the below code proc format; value first 2='Two' 3='Three'; value final 1='One' other=[first.]; run; proc format library=work cntlout=formats; run; Dataset content from format dataset. Expected Output: FMTNAME START LABEL FINAL 1 One FINAL 2 Two FINAL 3 Three Actual Output FMTNAME START LABEL FINAL 1 One FINAL **OTHER** FIRST40. Many Thanks...

suraestar · ‎06-06-2013

Hi there.. If you could know the macro variable name which holds the value in the macro(a separate file). You can do in these 3 ways 1. Define the Macro variable as GLOBAL which holds the results and if done this value can be used in the calling program. 2. If you are aware of the name of macro variable then you can get the value by fetching the value from sashelp.vtable 3. This one is weird. Create a additional parameter in the Macro which holds the results and use it in the calling. Ex: %local input result; %mymacro(inp=&input, res=result); %put Result = &result; Let me know if this answers your question.....

suraestar · ‎06-06-2013

Hi Garag, Yes, this would lead to apparent symbolc warning since SAS consider G (ie.,M&G Company) as macro variable in the session. So in order to avoid this, You should use Macro Masking function such as %str(), %nrstr(),%quote()........etc. Try the below code. %let mycompany=%nrstr(M&G CORPORATION); data Portfolio_holding_lt_30; length MYCOMPANY $ 100 ; MYCOMPANY = "&mycompany."; run; Thanks.

suraestar · ‎06-05-2013

Its me Surendar.... not ahmed

suraestar · ‎06-05-2013

Hi.. Here is the answer for your requirement, data _null_; empid='A566545'; if anyalpha(substr(empid,1,1)) NE 0 then substr(empid,1,1)='1'; put empid=; run; Let me know if this is what you expect?

suraestar · ‎05-23-2013

Hi, I used the below code to check whether any dataset is exist in a location.. Is there any simpler way to do this??? libname target 'c:\temp\'; %let lib = target; proc sql noprint; select count(*) into:lcount from sashelp.vtable where upcase(libname)="%upcase(&lib)" and MEMTYPE='DATA'; quit; %put lcount=&lcount;

suraestar · ‎05-21-2013

Is there any SAS Function to check atleast a dataset present in a location/library?

suraestar · ‎05-16-2013

I thin you can find the solution here..Just try with the options in excelxp Check the below links for samples and training, http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#toc http://support.sas.com/resources/papers/proceedings12/276-2012.pdf Thanks...

suraestar · ‎05-02-2013

Hi Santhosh, To trim macro variables %trim and %left function can be used to remove trailing and leading space. But In general, while the macro variable is created it does'nt store leading or trailing space in it . %let test = hi ; %put &test; output: hi But in your case, you are assigning macro variable 'CPRNO' via datastep and the dataset variable CPRNO may contain leading or trailing space. So try the below code. call symput('CPRNO'!!left(put(_n_,10.)),strip(CPRNO));

Online Status	Offline
Date Last Visited	‎09-07-2016 03:02 AM

Re: How to provide more than 10 Footnotes for Graphs.

Re: How to provide more than 10 Footnotes for Graphs.

How to provide more than 10 Footnotes for Graphs.

How to delete a Macro in a session? ( not macro variable)

Re: How to create 100 percent stacked Bar chart using GTL?

Re: How to create 100 percent stacked Bar chart using GTL?

Re: How to create 100 percent stacked Bar chart using GTL?

How to create 100 percent stacked Bar chart using GTL?

Re: Multiple Graph into a Single HTML using GTL.

Re: Multiple Graph into a Single HTML using GTL.

Re: How to create 100 percent stacked Bar chart using GTL?

Re: Create Exel file from dataset

Re: Create Exel file from dataset

Re: How to create 100 percent stacked Bar chart using GTL?

Re: Multiple Graph into a Single HTML using GTL.

Multiple Graph into a Single HTML using GTL.

Re: PROC COMPARE Warning.

PROC COMPARE Warning.

Re: How to Obtain OTHER Format values ???

Re: How to Obtain OTHER Format values ???

How to Obtain OTHER Format values ???

Re: SAS macro help to pass variable back to the calling program

Re: Data step: value with ampersand inside

Re: Replace letter with number

Re: Replace letter with number

Re: Is there any SAS Function to check atleast a dataset present in a ...

Is there any SAS Function to check atleast a dataset present in a loca...

Re: Create Exel file from dataset

Re: Removing space while resolving macros