About dassuz

dassuz · ‎11-01-2019

Sample Data same as attachment Src_Sys_Metering_Point_Num MPXN1 SAP_Installation_Num Meter_Reading_Doc_Id ReadDate Meter_Read Meter_Reading_Type_Cd Meter_Read_Rsn CreatedDate COR_flag Date_Diff 14262 14262 6000373 39855 14/10/2019 54910 CO 1 14/10/2019 1 0 14262 14262 6000373 75953 15/09/2019 54910 CO 1 15/09/2019 1 0 14262 14262 6000373 7427 15/08/2019 54910 CO 1 15/08/2019 1 0 14262 14262 6000373 78100 15/07/2019 54910 CO 1 15/07/2019 1 0 12433 12433 6002031 40733 01/10/2019 746229 I 6 18/10/2019 0 17 12433 12433 6002031 30504 30/09/2019 0 1 21 30/09/2019 0 0 877578 877578 6002017 76059 30/09/2019 39330 1 1 17/10/2019 0 17 877578 877578 6002017 58531 30/09/2019 84386 1 1 17/10/2019 0 17 877578 877578 6002017 84569 30/09/2019 26480 3 1 04/10/2019 0 4 562763 562763 623333 46061 16/10/2019 0 R 9 17/10/2019 0 1 562763 562763 623333 74389 15/10/2019 769603 R 9 16/10/2019 0 1 562763 562763 623333 33734 15/10/2019 0 R 9 16/10/2019 0 1 562763 562763 623333 33452 15/10/2019 95563 R 9 16/10/2019 0 1 562763 562763 623333 38650 14/10/2019 749403 R 9 15/10/2019 0 1 562763 562763 623333 70710 14/10/2019 70934 R 9 15/10/2019 0 1

dassuz · ‎11-01-2019

that is what I used but instead of putting the dates I entered the column dates

dassuz · ‎11-01-2019

The Data Set comprises of 550000 rows, I have attached a small sample but I have amended the sensitive data

dassuz · ‎11-01-2019

Hi I am trying to bring back working days from two columns in SAS I used the following code data Want; WorkDays_Diff = intck ('Weekday',ReadDate, CreatedDate); set have; run; How ever when i got the results Workdays_Diff comes one row below and theres a dot' .' in the first row. So the results for row 1 is in row 2 and result for row 2 is in row 3 etc If you want to manipulate values after they are read from the data set on the Set statement the calculation should come AFTER the SET statement.

dassuz · ‎12-12-2018

Thanks

dassuz · ‎12-12-2018

Hi I was hoping someone can help me, I have a table with many columns, One of the columns is called Read_Type, This column has millions of lines of data which consists of either a 01, 02, 03 or a zero 4. I would like to transfer all the data with a read type of 01 and 02 into Table_A and the remainder into Table_B, what is the best way to do this

dassuz · ‎12-12-2018

Hi I was hoping someone can help me, I have 1 table with multiple columns, one of the columns is called read_type which is either a 1,2,3 or a 4. I would like to put all the 1 and 2 in one table and the 3 and 4 in another table. What is the best way to do this?

dassuz · ‎07-04-2017

I have millions of rows of data in a table, how do I delete the data without deleting the tables

dassuz · ‎07-04-2017

Hi i have a table with about 20 columns and millions of lines of data, I want to make a copy of the structure of the table without copying any data. What would be the best way to do this?

Online Status	Offline
Date Last Visited	‎11-07-2019 06:54 AM

Re: Bring Back working days from 2 dates in 2 two columns

Re: Bring Back working days from 2 dates in 2 two columns

Re: Bring Back working days from 2 dates in 2 two columns

Bring Back working days from 2 dates in 2 two columns

Re: Split 1 table to 2 Outputs

Split 1 table to 2 Outputs

Split data from one table to two tables

How to delete data in table

Copy Structure of Table without copying Data

Re: Bring Back working days from 2 dates in 2 two columns

Re: Bring Back working days from 2 dates in 2 two columns

Re: Bring Back working days from 2 dates in 2 two columns

Bring Back working days from 2 dates in 2 two columns

Re: Split 1 table to 2 Outputs

Split 1 table to 2 Outputs

Split data from one table to two tables

How to delete data in table

Copy Structure of Table without copying Data