Hi everybody. Where is the syntax error? PROC SQL; SELECT p.*,c.unicost,s.quantity FROM product,cost,sales WHERE product.item = cost.item AND product.item = sales.item; QUIT; Best regards, Cons.
... View more
Hi everybody, I try to combine two data sets. Data Set A and DATA SET B with the variables state and object_id. For example Set A state object_id 1 a 1 b 2 a SET B state object_od 1 a 1 b 2 a 2 b 3 a I want the new Data Set like SET state object_id 1 a 1 a 1 b 1 b 2 a 2 a 2 b Which statement would I need to get the new data set Regards, Cons.
... View more
Hi everybody, is there a function for following problem: I have a string like "abc,def." and I want replace "," and "." with numbers or characters. I just want use the function once. Regards, Cons.
... View more
Hi everybody, I have the system option COMPRESS=BINARY. In this case I use RDC, combines run-length encoding and sliding-window compression to compress the file. What is sliding-window compression? Best regards, Cons.
... View more
Hi. Thank you so much for all answers. But you didnt talk about my question. Why do I not need & in %last=first? first is a value and not reference. I dont understand it. Bye.
... View more
Hi its me again. I know the result its vodername. But I dont understand why I need no & in Line 2 (%Last=first) If i want reference to macro variable first then I need zo type $first, right? Thanks!
... View more
Hey guys, the answer is very simple. The array has 8 elements a4-a10 are 7 elements plus a25 I get 8 elements. Sorry but I was confused. Thanks for all advices.
... View more
