About suraestar

Tom · ‎08-01-2020

Not sure why this 6 year old thread has been re-activated, but there is now the %SYSMACDELETE macro statement for deleting compiled macros. Here is a link to a macro that will make it easier to use that statement to delete multiple macros, including preventing you from trying to delete a macro you are currently running. https://github.com/sasutils/macros/blob/master/macdelete.sas

suraestar · ‎09-07-2016

Thank you... That was a nice trick to use...

Jay54 · ‎04-22-2014

Just an FYI... Dan just reminded me that G100 feature has been added to SGPLOT procedure with SAS 9.4. User PCTLEVEL=GROUP; sgplot data=sashelp.cars pctlevel=group; vbar origin / group=type stat=pct; run;

suraestar · ‎02-27-2014

I need HTML output(i have already generated RTF and PDF for this output) Thats fine. Thanks for your help..

Jay54 · ‎03-03-2014

You have provided 3 row weights (0.8 0.01 0.19), but only two Layout Overlay blocks. If you want a label between the Box Plot and the Table of values, add another LAYOUT OVERLAY - ENDLAYOUT block in the middle with an ENTRY statement of the label you want. You may need to provide a row weight > 0.01.

Quentin · ‎02-14-2014

Is ssomething like this what you are trying to do? THe images aren't actually in the file, but it's one html file and when you view it you will see both images. ods html file="d:\junk\mygraphs.html" gpath="d:\junk"; proc sgplot data=sashelp.class; hbox age/group=sex; run; proc sgplot data=sashelp.class; hbox height/group=sex; run; ods html close;

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 · ‎06-14-2013

Thanks Keith...

Astounding · ‎06-06-2013

There's another way that might be appropriate: %let mycompany = 'M&G CORPORATION'; Then later: MYCOMPANY = &MYCOMPANY; As long as all uses of the macro variable require quotes around the company name, this would work. Good luck.

fred_major · ‎06-05-2013

HI Ahmed, Ok I overcame the probem by just changing Best. to $Char. Thanks Ahmed, everyone. Fred

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;

TimArm · ‎05-02-2013

Nice one Ksharp. I will use that in future. Thanks, Tim

Liej · ‎05-17-2013

I used this to add the '-signs %let Excel= %str(%'&path/Excel/&&E&i._Excel%'); but then I get this error when using it in ODS listing close; ODS html3 body=&Excel; ERROR 22-322: Syntax error, expecting one of the following: a name, a suoted string Thanks Patrick. %let Excel=&path/Excel/&&E&i._Excel; ods html3 body="&Excel"; These two little changes made it work. Thanks a lot.

Patrick · ‎04-24-2013

You are NOT removing duplicate records using Proc Sort / Nodupkey unless you add all variables to the 'by' statement - and then it does the same like a SQL Distinct. You are removing duplicate 'keys' using Nodupkey - all the other variables not in the by group are then just coming from one of the multiple records with the same key values. You have zero control which row will be selected so what's the value of having these additional variables? There have already been many discussions in this forum around de-duplicating records.

suraestar · ‎04-26-2013

Hi, Thanks,but this seems to be little pre-processing may require. If my varlist exceeds more than 5 words, then I should rebuild the prxchange parse code.

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: How to delete a Macro in a session? ( not macro variable)

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

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

Re: Multiple Graph into a Single HTML using GTL.

Re: How to insert a Title or a Header for the second graph?

Re: Multiple Graph into a Single HTML using GTL.

Re: PROC COMPARE Warning.

Re: How to Obtain OTHER Format values ???

Re: Data step: value with ampersand inside

Re: Replace letter with number

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

Re: Removing space while resolving macros

Re: Create Exel file from dataset

Re: NODUPKEY feature in PROC SQL?

Re: Function to Fetch n words from a variable separated by a Delimiter...