About carmendee

carmendee · ‎01-12-2017

Is your InfoMap based on tables or cubes? Tables From WRS, are you using a List or crosstabulation table? List Do you have the same behaviour with both? InfoMap test is correct, Web Report is not. Is this what you mean? Do you have an aggregation set to SUM for instance? Aggregation is set to COUNT

carmendee · ‎01-11-2017

I have data that is correct when I test in Information Map Studio. However, when I assign data to a table in Web Report Studio, the values are incorrectly doubled. Simply put, value 1 = 2, value 25 = 50, etc. The item in Information map is defined as count(item). Ideas?

carmendee · ‎01-04-2017

My field is numeric so my else cannot be "" for a blank. I do not want a zero. Ideas?

carmendee · ‎12-20-2016

How does this syntax work in Enterprise Guide in build and advanced expression if my field name is AF?

carmendee · ‎12-20-2016

I have data with an '.' in a numeric field. I want to move a space to this field. I would like to do this in Enterprise Guide. I have tried variations of this syntax: case when t1.AF > 0 then PUT(t1.AF) = '' end Input AF AM BF . . 9 . . . . . 2 Output AF AM BF 9 2

carmendee · ‎12-06-2016

Test_date = numeric 20160501 Desired Result = 01MAY2016:00:00:00 I tried the advanced expression in in Enterprise Guide: INPUT(PUT(t1.TEST_DATE,8.),YYMMDD10.) format= DATETIME20 Result = 01JAN1960:05:42:55

carmendee · ‎11-17-2016

Thanks Reeza! File_1 CALENDAR_DATE SCHOOL 04Mar2017 0:00:00 340326 04Mar2017 0:00:00 340330 04Mar2017 0:00:00 340504 11Feb2017 0:00:00 340326 11Feb2017 0:00:00 340330 11Feb2017 0:00:00 340504 10Jan2017 0:00:00 340326 10Jan2017 0:00:00 340330 10Jan2017 0:00:00 340504 01Jul2016 0:00:00 340326 01Jul2016 0:00:00 340330 01Jul2016 0:00:00 340504 File_2 Quarter DATE1 DATE2 SCHOOLID Q1 29Aug2016 0:00:00 08Nov2016 0:00:00 340326 Q1 29Aug2016 0:00:00 07Nov2016 0:00:00 340330 Q1 29Aug2016 0:00:00 08Nov2016 0:00:00 340504 Q2 09Nov2016 0:00:00 20Jan2017 0:00:00 340326 Q2 09Nov2016 0:00:00 21Jan2017 0:00:00 340330 Q2 09Nov2016 0:00:00 20Jan2017 0:00:00 340504 Q3 24Jan2017 0:00:00 02Apr2017 0:00:00 340326 Q3 24Jan2017 0:00:00 02Apr2017 0:00:00 340330 Q3 24Jan2017 0:00:00 02Apr2017 0:00:00 340504 Q4 03Apr2017 0:00:00 07Jun2017 0:00:00 340330 Q4 03Apr2017 0:00:00 08Jun2017 0:00:00 340326 Q4 03Apr2017 0:00:00 08Jun2017 0:00:00 340504 Results CALENDAR_DATE SCHOOL Quarter 04Mar2017 0:00:00 340326 Q3 04Mar2017 0:00:00 340330 Q3 04Mar2017 0:00:00 340504 Q3 11Feb2017 0:00:00 340326 Q3 11Feb2017 0:00:00 340330 Q3 11Feb2017 0:00:00 340504 Q3 10Jan2017 0:00:00 340326 Q2 10Jan2017 0:00:00 340330 Q2 10Jan2017 0:00:00 340504 Q2 01Jul2016 0:00:00 340326 NA 01Jul2016 0:00:00 340330 NA 01Jul2016 0:00:00 340504 NA

carmendee · ‎11-17-2016

Attached spreadsheet has two input files (File_1 & File_2) and a desired result. I need to create a table with the Quarter Per School to be added to File_1 for a date in the year according to date range (File_2) for that school. Cannot join on the schoolid so assuming I need to write a proc. Help!

carmendee · ‎11-15-2016

Please see where I attached error.

carmendee · ‎11-15-2016

Confirmed calendar date is a date variable.

carmendee · ‎11-15-2016

Attached is the error. Also, my limited experience with Information Map has required the << and >> as part of the code.

carmendee · ‎11-15-2016

I am trying to add "datepart" to my date field in Information Map Studio and am getting an error when validating. case when <<datepart(ZW_CURRENT_DATE_DIM.CALENDAR_DATE)>> > '08Nov2016'd then '2nd Quarter' end

carmendee · ‎07-06-2016

This worked. I had to add DATETIME20 to the format under "Modify additional options" in Enterprise Guide. Thanks all!

carmendee · ‎06-30-2016

Can this be done in the advanced expression calculation? Example data to convert from char to SAS date: 02/12/2016 to 12FEB2016:00:00:00

carmendee · ‎05-27-2016

Because these are two different data types, I need to find a way to join them in Information Map. I cannot "first" get the data types the same in that software.

Online Status	Offline
Date Last Visited	‎03-26-2018 11:17 AM

Re: Information Map testing and Web Report Studio - data value differe...

Information Map testing and Web Report Studio - data value differences

Re: How to move a SPACE to a numeric field

Re: How to move a SPACE to a numeric field

How to move a SPACE to a numeric field

Numeric date to date and time

Re: Assign Quarter Per School Date Range

Assign Quarter Per School Date Range

Re: Using DATEPART in Information Map Studio

Re: Using DATEPART in Information Map Studio

Re: Using DATEPART in Information Map Studio

Re: Generate rows per a column value

Numeric date to date and time

Re: Information Map testing and Web Report Studio - data value differe...

Information Map testing and Web Report Studio - data value differences

Re: How to move a SPACE to a numeric field

Re: How to move a SPACE to a numeric field

How to move a SPACE to a numeric field

Numeric date to date and time

Re: Assign Quarter Per School Date Range

Assign Quarter Per School Date Range

Re: Using DATEPART in Information Map Studio

Re: Using DATEPART in Information Map Studio

Re: Using DATEPART in Information Map Studio

Using DATEPART in Information Map Studio

Re: Need to convert character mm/dd/yyyy to SAS date and time in Query...

Need to convert character mm/dd/yyyy to SAS date and time in Query Bui...

Re: Date - Information Map join