About ghosh

ghosh · ‎10-24-2020

Hi Kavita, without any sample data, we can only suggest. Your can look at the explode option for pie charts. Also GTL gives you the tools for pretty sophisticated graphs. Please take a loot at this paper for ways to approach your problem https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/071-2008.pdf

ghosh · ‎10-24-2020

add another style STYLE(column)=[background=gray]

ghosh · ‎10-21-2020

It's the same as SAS accepting Title and Footnote without any digits.

ghosh · ‎10-01-2020

Before you use them in formula, you should define them with their max length, for example: Length test1 test2 test3 $10;

ghosh · ‎09-30-2020

n follows a non-standard file name or worksheet name, for example where there are embedded spaces. It should be inside the semi-colon not outside. Yours has none so it's not needed Try running my code with the same options. Then check the whether you other options are applicable in the xls engine (perhaps Excel has been deprecated, it does not work in SAS UE) Please post your code (not as a log) and a sample of your data (dummy it up if confidential).

ghosh · ‎09-30-2020

I have no issues importing excel97 file. Instead of libname, use filename to point to the file FILENAME dat '~/dat/class.xls'; PROC IMPORT DATAFILE=dat DBMS=XLS replace OUT=WORK.IMPORT; GETNAMES=YES; SHEET="All Students"n; RUN;

ghosh · ‎09-28-2020

Use proc format to create your age ranges

ghosh · ‎09-24-2020

Thank you for pointing that out, the values of the ods graph and region were getting swapped, I guess EG 7 is more forgiving. However, text spacing problem still exists, including the title and the value labels, guess I will make it a new post, after I try to figure it out.

ghosh · ‎09-24-2020

Good catch, let me try your suggestion when I get back on to my work computer. I think I have the ods region and ods graphics dimensions reversed when I typed them out in my post (they are read from a table into macro vars). Yes, I did try with scale off Still looking for code to save the template used by sgplot Thanks

ghosh · ‎09-24-2020

I have a dashboard that generates PDF out using ODS absolute. It was developed and runs fine in EG 7.15 (7.100.5.5850) (64-bit) (SAS version: 9.04.01M3P062415) However, in EG 8.1 (8.1.0.4552) (32-bit) (SAS version: 9.04.01M6P110718) the bar charts generated with SGplot are not scaling the same as in the former EG version. The text is getting squished and do not fit the same way in the ODS region that worked before. Is it possible to export the template that is used in EG 7.15 and apply it to the current version and how would I export it? ods graphics on / noborder height=7.0cm width=9.750cm antialiasmax=1400 scale=on ; The above is the ods graphics line. Each of the 4 graphs specify their respective ods region, eg the first one: ods region x=0.05cm width=9.50cm y=17.525cm height=6.5cm; Thanks for any leads you can provide.

ghosh · ‎09-17-2020

Perhaps you have tabs instead of spaces. The following code ran fine after using my editor feature to convert tabs to spaces data sexact; input male female year calyear ; datalines; 0.63 0.51 1 1991 0.62 0.52 3 1993 0.63 0.57 5 1995 0.58 0.51 7 1997 0.59 0.49 9 1999 0.53 0.46 11 2001 0.56 0.5 13 2003 0.55 0.5 15 2005 0.55 0.5 17 2007 0.53 0.48 19 2009 0.54 0.48 21 2011 0.52 0.47 23 2013 0.45 0.4 25 2015 0.41 0.37 27 2017 ; run;

ghosh · ‎09-15-2020

not sure why you want to do it, if it's for reporting purpose, you should look into proc report. But anyways, here is a quick solution data mrg; merge have (obs=1 firstobs=1 rename=(code=code1 date=date1)) have (obs=2 firstobs=2 rename=(code=code2 date=date2)); by id; run;

ghosh · ‎09-13-2020

proc transpose out=trans (rename=(COL1=Vent_status)); by uuid; run; data want (drop=_NAME_); set trans; length Day 4; Day=put(scan(_name_,-1,'_'),3.); ; run; proc print; run;

ghosh · ‎09-10-2020

Thanks for your response @ballardw I will look into the nlevels option for future use. I was already able to create the report with my attached, however, the issue was getting the worksheets named with the variable. So what I have done now and it's working the way I want it, is what I had described in my reply to Reeza: a data driven macro using call execute. I named the sheets using this line ods excel option(sheet_name="&var"); I am sure it's very inefficient since it took over an hour to run for about 22 variables (instead of <10 mins) each with a proc freq call. But, it's a one time job to share the data contents in terms of available groupings

ghosh · ‎09-09-2020

Thanks Reeza, I am just doing an exploratory review of a massive dataset with many classification variables. My other option is create a macro and call it for each variable in its own proc freq perhaps using loop or a dataset driven call execute. This way I can set the sheet name manually

Online Status	Offline
Date Last Visited	‎08-07-2025 04:33 PM

Re: Export to Excel Table

Re: IF THEN ELSE DELETE SYNTAX

Re: Changing Character-Type Column to Numeric-Type (Date-Group)

Re: Changing Character-Type Column to Numeric-Type (Date-Group)

Re: How to calculate moving average by taking current calculated movin...

Re: Counting one column according to a second column

Re: Importing unstructured data stored in varying number of lines

Re: Importing unstructured data stored in varying number of lines

Importing unstructured data stored in varying number of lines

Re: Is there a way to close all the tabs without being asked if I want...

Re: How to panel by multiple y-axis variables, sgpanel?

Re: How to change line color and style?

Re: Extracting specific words from the middle of a string variable.

Re: Let macro variable be max date in dataset

Re: Replace values in a column

Re: SAS 9.4 - ODS Header - Timestamp behaviour

Re: ODS Excel / PROC REPORT - How to remove extra row height when prev...

Re: Transforming single column into matrix

Re: How to add multiple tables next to each other in a single excel sh...

Re: Create a new dataset

Re: Extended Pie Chart: Donut of Pie

Re: Adding a background behind table

Re: TITLE0/FOOTNOTE0

Re: how to avoid unintialized values log message?

Re: error when reading excel97 files on win10 and sas 9.4

Re: error when reading excel97 files on win10 and sas 9.4

Re: how to group ages data into several interval

Re: Text and sgplot scaling issues

Re: Text and sgplot scaling issues

Text and sgplot scaling issues

Re: Why the data input/datalines not working? Help

Re: Transpose 2 records to one

Re: Proc Transpose and add days

Re: ODS Excel in proc freq assign sheet name to variable name or label

Re: ODS Excel in proc freq assign sheet name to variable name or label

SAS Inner Circle Panel

SAS Analytics Explorers

SAS Global Forum 2020