TriciaA Tracker

Re: Selection Group Prompt and Management Console

TriciaA — Fri, 13 Apr 2012 13:14:17 GMT

1 - Not that I am aware of. Sounds like a feature request.

2 - This very example is covered in the Building Business Intelligence with SAS book on pages 93 and 115. Based on the questions you have been asking - I think you would find the book a tremendous asset on your learning path.

Calculate a missing field

TriciaA — Wed, 29 Feb 2012 00:05:44 GMT

Art297 has a good suggestion.

I have also used this method with success - basically I test if Price is empty and only do the calculation if it's not. My else value can be 0 indicating no change or it could be amount if that makes more sense in your calculation.

,case

when price ge 0 then Amt - price

else 0 /*You may want this to be Amt*/

end as new_var

How can I convert a character value with leading zeros to numeric and maintain the leading zeros?

TriciaA — Fri, 24 Feb 2012 18:58:30 GMT

Blogged about this topic just last Friday ... check it out ... http://www.bi-notes.com/2012/02/sas-coding-adding-leading-zeros-z-format/

Advanced Prompts

TriciaA — Mon, 06 Feb 2012 21:06:11 GMT

Yes macro variables require double quotes to "decode" the value. So much fun!

Advanced Prompts

TriciaA — Mon, 06 Feb 2012 20:44:02 GMT

You can use the macro variable created by the prompt ... which I don't think that will mean much to you.

Can you give me an example of how you are using this ... for instance, the user picks a word (like Dog) or a value (like 4) and then your computed column would output something like this:

"You picked: Dog"

or this "100" (because 25*4 is 100)

cant seem to read .sas7bvew file created with SunOS using EG-v4.3

TriciaA — Fri, 03 Feb 2012 22:07:22 GMT

It's an Index not a data set. Probably why you cannot peak at it from EG.

This might shed some light:

http://www2.sas.com/proceedings/sugi27/p069-27.pdf

Prompts in Management Console

TriciaA — Fri, 03 Feb 2012 19:15:21 GMT

Ashley:

At my blog site I have a section on using prompts and buidling stored processes that you might find useful.

http://www.bi-notes.com/25_stp/

Also - just yesterday my book "Building Business Intelligence with SAS: Content Development Examples" was released. This book covers all the ins and outs of using prompts. You might be interested in it as well.

Tricia

EG Reporting Format

TriciaA — Wed, 01 Feb 2012 13:56:01 GMT

Not exactly what you asked but --

Hubert Lee has an awesome site Dashboard Spy that you can peruse for ideas or more dashboard ideas and info than you can shake a stick at!
Another way to get ideas is to go to Google homepage, click Images in the upper-left corner and then type SAS Dashboard Examples Click here to see my results
I've also been talking about the SAS BI Dashboard tool at the blog if you are interested: SAS BI Dashboard Articles

I love the dashboards! Hope this helps! Also - would love to see your results.

Tricia

Check out my BI Notes for SAS Users

Manually filling columns

TriciaA — Mon, 23 Jan 2012 14:42:23 GMT

I've been able to do that by pasting from MS Excel so SAS EG understands its columnlar data.

Here's a post where I talk about manually editing data in SAS EG: Tips and Tricks for Manually Editing Data

Proceed with caution - it cannot be undone.

Hope this helps!

Tricia Aanderud

Blogging about SAS BI tools, SAS EG

Help diagnosing strange behavior in SAS EG 4.2

TriciaA — Thu, 19 Jan 2012 20:49:34 GMT

I googled SAS "Object reference not set to an instance of an object"

It returned this for EG 4.3:

http://support.sas.com/kb/42/448.html

Hope it helps you. Let us know.

Syserror not resolving

TriciaA — Thu, 19 Jan 2012 15:07:19 GMT

Run this code and it will be more clear what is happening: The bold line is especially important.

%macro test;

title "This is my test";

proc print data=sashelp.clas;

run;

%put SYSERR is this value: &syserr.;

proc sql noprint;

select Count(*) into :CONT from sashelp.class;

quit;

%put SYSERR is this value: &syserr.;

%put CONT is this value: &cont.;

%if (&cont = 0 and &syserr=0)

or (&cont = 0 and &syserr > 0)

or (&cont > 0 and &syserr > 0)

%then %do ;

%let V_STATUS=0;

%end;

%else;

%IF &cont > 0 and &syserr=0 %THEN %do ;

%let V_STATUS=1;

%end;

%put V_STATUS is this value: &V_STATUS.;

%mend;

%test;

Can I create a date filter on an Information Map?

TriciaA — Wed, 18 Jan 2012 15:20:57 GMT

I'm not sure if the logic you are using is going to work in the way you are expecting.

Anyway - if the experession is a cut and paste - then here's what's wrong:

The operator and DATE() are in the wrong place.

<<Demographics.Begin_Dt>> <= DATE() and << Demographics.End_date >= DATE()>>

The ">>" needs to be behind the data item.

<<Demographics.Begin_Dt>> <= DATE() and << Demographics.End_date>> >= DATE()

Tricia

Subscribed to my BI Notes for SAS Users Blog for tips and tricks using the SAS BI toolset

Reporting by category using local SAS EG setup

TriciaA — Thu, 15 Dec 2011 11:21:31 GMT

Nico:

If you are just wanting to control the layout for the graphs - use the GOPTIONS. They can be tricky but will allow the several graphs to fit a page at once. Also I think if you want to try the PDF route - then you'll want to use the ODS PDF so it can control the layout.

Here are some papers that discuss using the GOPTIONS and PDF tagset. If memory serves - it works just for graphs and not for supporting PROC FREQs.

Good luck:

Tricia

Using EG 4.2 - how to extract 1st 3 digits from numeric column?

TriciaA — Wed, 14 Dec 2011 21:38:28 GMT

Sorry ... I meant force it for the output on the screen where it asked if you want Character or Numeric.

Select Character and set the format to $8. Setting the format should be enough.

You don't have to set the length -leave it blank.

Change your original calculation back to this:SUBSTR(PUT(t1.ACCOUNT_ID, 8.),1,3)

Using EG 4.2 - how to extract 1st 3 digits from numeric column?

TriciaA — Wed, 14 Dec 2011 20:53:22 GMT

Try setting the format to $8. to force the character. Mine would only do it when I added the format.

Reporting by category using local SAS EG setup

TriciaA — Wed, 14 Dec 2011 20:36:26 GMT

Have you considered outputting to an Excel file using the Tagset? The entire spreadsheet would contain the report; however each sheet or tab could contain the different reports. The tagset gives you a lot of control over the output.

Here's some helpful links:

http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

http://www2.sas.com/proceedings/sugi31/115-31.pdf

I'm curious to know what you work out - even if it's not this solution.

Tricia

SAS BI Blog

How do I create a simple text file?

TriciaA — Wed, 14 Dec 2011 20:26:42 GMT

I'm not sure what the end goal is.

However PROC PRINTO is generally used for the log and lst output.

----------------------------------------------------------

DATA SAMPLE;

INPUT DAT :$10. NUM;

CARDS;

1/10/2006 123

2/11/2007 456

;

run;

/*If you want to print to report window*/

PROC PRINT data=sample;

RUN;

filename outfile "/m/thisfile.txt";

data _null_;

set sample;

file outfile;

put dat num;

run;

/*output to excel format*/

ods html file="/m/thisfile.xls";

proc print data=sample;

run;

ods html close;

Tricia

SAS BI Note Blog

Using EG 4.2 - how to extract 1st 3 digits from numeric column?

TriciaA — Wed, 14 Dec 2011 19:52:30 GMT

Try this instead:

(SUBSTR(PUT(t1.ACCTID, 8.),1,3))

and set the format to $8. or make it a character. A character value will not insert the decimal point.

Tricia

SAS BI Notes

Need help with a calculated measure

TriciaA — Tue, 06 Dec 2011 15:27:08 GMT

Hey Ulf:

One of the bloggers on my site published this information recently:

Percent of Total MDX Calculation

Hope this helps!

Tricia

SAS BI Notes Blog

Export data from SAS EG to Excel

TriciaA — Mon, 05 Dec 2011 21:57:32 GMT

Since it says you cannot authorize that directory - it means you are probably not allowed to write to your desktop.

You system admin needs to provide a place/permission to write the Excel file.

Did you try the File > Export method? Probably a long shot - but you might be able to see where you are allowed to write files to.

Also do you have the MS Excel Add-IN? You can access the SAS Folders from Excel.