About carmendee

carmendee · ‎05-26-2016

In Information Map, I need to join the following in advanced edit: MM/DD/YYYY (char) to either YYYYMMDD (numeric) or DATETIME20 (DDMMYYYY:00:00:00) Help!

carmendee · ‎02-29-2016

Are you able to look at the two input tables and desired output and advised?

carmendee · ‎02-29-2016

Two input tables below as well as desired output.

carmendee · ‎02-29-2016

Output example: Student # # days 1 2 2 6 3 10 4 4 5 6

carmendee · ‎02-29-2016

CALENDAR TABLE DATE_VALUE INSESSION 24Aug2012 0:00:00 0 25Aug2012 0:00:00 0 26Aug2012 0:00:00 0 27Aug2012 0:00:00 1 28Aug2012 0:00:00 1 29Aug2012 0:00:00 1 30Aug2012 0:00:00 1 31Aug2012 0:00:00 1 01Sep2012 0:00:00 0 02Sep2012 0:00:00 0 03Sep2012 0:00:00 0 04Sep2012 0:00:00 1 05Sep2012 0:00:00 1 06Sep2012 0:00:00 1 07Sep2012 0:00:00 1 08Sep2012 0:00:00 0 STUDENT TABLE Student # Entry Date Exit Date 2343 08Apr2014 13Jun2014 5475 07May2014 13Jun2014 6789 25Feb2014 13Jun2014 6786 11Apr2014 13Jun2014 6034 22Jan2014 10Apr2014 3433 28Jan2014 13Jun2014 3457 10Dec2013 22Jan2014 3430 28Aug2013 11Sep2013 1235 05Feb2014 20Feb2014 2321 12May2014 13Jun2014 5694 20Mar2014 08Apr2014 4058 14May2014 02Jun2014 5053 05May2014 02Jun2014 5055 26Aug2013 13Jun2014 5101 06Nov2013 13Jun2014 5279 26Aug2013 24Oct2013

carmendee · ‎02-29-2016

By student, how many days are insession (=1).

carmendee · ‎02-29-2016

I'm using SAS tables. I'm using point and click, however, I can include a proc (program).

carmendee · ‎02-29-2016

I have a caledar table where column INSESSION = 1 or 0. I have another table that has a begin date and an end date. Using a case statement, is there a way in SAS Enterprise Guide to total the amount in a range? Example: calendar table Jun 1 = 0 Jun 2 = 1 Jun 3 = 1 other table begin date = Jun 2 end date = Jun 3 Output should = 2 Thanks.

carmendee · ‎01-29-2016

I am comparing files using the EXCEPT logic. It is returning all row rather than the differences. By process of elimination, it appears to be the date. The output in both files is displayed the same (MM/DD/YYYY). Input from first file is derived from existing sas tables and formatted NLDATMDT10. Input from other is from .csv import and is formatted MMDDYY10. proc sql; CREATE TABLE Attendance_Compare AS select * from WORK.ATTNYEST except select * from WORK.DAILYATTENDANCE; Help! I tried several date changes and am getting nowhere.

carmendee · ‎01-11-2016

Example data Supervisor Empl Eval_Date Score Johnson Smith 1/1/15 25 Johnson Miller 1/1/15 26 Hanson Poole 1/2/15 25 Desired Ouput: Name Eval_Date Score Johnson Smith 1/1/15 25 Miller 1/1/15 26 Hanson Poole 1/2/15 25 I'm trying to accomplish this without a proc but can if I need to.

carmendee · ‎12-16-2015

Thanks, everything looks good now.!

carmendee · ‎12-16-2015

Example Prefix First_Name Middle_Name Last Name Suffix Employee_ID Total_Pledge Ms. Jack K Abbott 11 50 Ms. Tome P Abernethy 23 45 Mr. Sue L Abeyta 23 20 Ms. Erica L Abondolo 45 250 Ms. Alana C Adam 45 15 :

carmendee · ‎12-16-2015

Did not return any rows.

carmendee · ‎12-16-2015

Help! I was getting the output I wanted after posting and now I am not (unsure what I changed). The following results are no rows: data Rounded_Chances; input Employee_ID Suffix:$10. Num_Chances_Rounded; data All_Rows; set Rounded_Chances; do _n_=1 to Num_Chances_Rounded; output; end; keep Employee_ID Suffix Num_Chances_Rounded;

carmendee · ‎12-16-2015

I was getting the output I wanted after posting and now I am not (unsure what I changed). The following results are no rows: data Rounded_Chances; input Employee_ID Suffix:$10. Num_Chances_Rounded; data All_Rows; set Rounded_Chances; do _n_=1 to Num_Chances_Rounded; output; end; keep Employee_ID Suffix Num_Chances_Rounded; run;

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

Date - Information Map join

Re: Counting - cumulative

Re: Counting - cumulative

Re: Counting - cumulative

Re: Counting - cumulative

Re: Counting - cumulative

Re: Counting - cumulative

Counting - cumulative

Dates when using EXCEPT comparison

Transpose Split Stack

Re: Generate rows per a column value

Re: Generate rows per a column value

Re: Generate rows per a column value

Re: Generate rows per a column value

Re: Generate rows per a column value