Hello! I want to transpose a table that looks like this (some cells are empty but not all) AFTER proc transpose data=WORK.to_enter out=WORK.to_enter_transposed; id counterparty_rk; run;   I GET THIS   I get a table without rows 😞 do not understand why. could you help me solve the problem? ... View more

Please, help me to solve the problem. I have a "time" column in a table. I need to fill in the Marker column in the table. The first line - "Marker" is equal to one. Then, if more than ONE HOUR has passed since the last moment, the marker should increase by one. And so on until the end of the table. I will be extremely grateful to see the code with the solution! time marker   14:01 1   14:02 1   14:03 1   14:04 1   14:05 1   14:06 1   17:33 2 here I need to increase "marker" (because more them 1 hour pass) 17:34 2   17:35 2   19:38 3 here I need to increase "marker" (because more them 1 hour pass) 19:39 3   19:40 3   19:41 3   ... View more

Hello everyone! I will be very grateful if you help solve the problem. I have two macro variables. They look like this: I want to create two new macro variables that should look exactly like this: '29JAN16:11:07:33'dt and '29JAN16:14:21:01'dt  Is it possible? and if yes, please give the code ... View more

Hello everyone! I use SAS Studio. I start the process through the "Background Submittion" button. And then a very large log is created, which I absolutely do not need 🙂 Tell me, is there a command that prohibits creating a log at all? So I inserted this command at the beginning of the process and started it again 🙂 ... View more