I have a request to create a report based on daily files . I need to import last 7 files all formatted the same and same number of columns.. the name of file Comments 2018-10-19.csv. Comments 2018-10-18.csv Comments 2018-10-17.csv Comments 2018-10-16.csv How do i import files an merge it to one ? Thanks for help ... View more

I have a table Pro sql; Create table settle4 as Id, Datetime, Substr(put(datetime,16.),12,21) as timestamp From table1); Run; The output is 15544 15595 The data looks 13oct18:02:05:44 13oct18:02:06:35 I would want to extract the hour only ... View more

I have a dataset that if it. Matchs i would need another col to be null The data looks Id. Type. Sch A1. Cd. Mon tue Ab. Store. Tue wed S1. Cd. Wed A5. Store. Mon When type eq Cd i would w want sch to be null .id Type. Sch A1. Cd. Ab. Store. Tue wed S1. Cd. A5. Store. Mon ... View more

I have a table lokks like this Id. Datetime A2 0NOV05:03:49:19 A2. 0NOV05:02:49:19 A3. 0NOV05:06:49:19 A3. 0NOV05:08:49:19 What i need is to pull the last entry obo Like this Id. Datetime A2 0NOV05:03:49:19 A3. 0NOV05:08:49:19 ... View more

I have a table where the datetime firld is formats 23Sep18:11:32:00. Which is datetime 16 I need that field to be formatted as a character. Like this 23Sep18:11:32:00 ... View more

I have a table with a datetime field i need to get to pull whst the entry was 6 hrs ago Id. Datetime. Balance . 21sep2018:12:22:30. 100 B2. 21sep2018:10:22:30. 189 A6. 21sep2018:12:09:30. 65 Whst i want is to pull report showing what they did 6 hrs ago Id. Datetime. Balance . 21sep2018:06:22:30. 233 B2. 21sep2018:04:22:30. 35 A6. 21sep2018:03:09:30. 64 ... View more

I have a tsble thst looks like this Cp_ID, ID, CONTENT, ITEMCOUNT LAST MODIFY I DO A SORT content Data looks like Cpid. Id. Content. Count. Last modify Cpid123. A2. One. 1864 20sep2018 17:54:02 Cpid123. A2. Two 20 20sep2018 17:36:09 Cpid123. A2. Five. 543 20sep2018 17 59:04 Cpid123. A2. Ten. 67 20sep2018 17:38:16 Cpid123. A2. One. 500 19sep2018 16:33:08 Cpid123. A2. Two 200 19sep2018 17:49:12 I need the proc transposed to look Cpid. Id. Date. . One. Two five ten ... View more