options validvarname=any; LIBNAME xl XLSX '/home/john/B.xlsx'; Hello, I'm using the above to read in an Excel file with 2 sheets. I want these two sheets of info to be combined based on an ID (both have ID columns). But pretty sure the ID's and maybe even Dates would have to first be sorted? So, first, how can that be done with multiple sheets using libname xlsx? The reason I ask is because unlike something like proc import where I would have a dataset to sort, here I don't.
... View more
Sorry, late question(s). To get the proper results, would you not need to sort before combing all the data-sets? Otherwise, is the BY statement really going to get the result you want? And also, how can just combine like that with set when it wasn't imported?
... View more
If I need to feed the data from a table that is on the server with the table that I do in SAP's excel after the analysis, can I join it automatically?
... View more
I would like to know if it is possible to extract simple information, for example, table size and the owner / creator of it, from tables that I do not have permission to read.
... View more
Hello, Anybody have any more clarification about this comment which I read in the documentation. This is in reference to Proc Logistic. https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=statug&docsetTarget=statug_logistic_syntax01.htm&locale=en#statug.logistic.logisticinmodel What kind of modifications is it referring to? What is ok and not ok?
... View more
data banktransactions; infile input run; can i just now refer to it again after the run statement like data banktransactions; ?? do i need a set statement?
... View more
Sorry for any confusion. I just mean that I tend to give a new name to a data set each time I start a new block (assuming there is significant additions in that new block). But I have had the habit of reading the old data set name with set and giving the new block a new name. I'm just asking if I can use the same name throughout even if i start new blocks?
... View more
Hello,
Can we use the same data name throughout code (different blocks) and will the program know we are referring to the same data set or do we need a new name for new block?
... View more
Ie I want to set values of Goals_Scored between 10 and 100, and then if someone falls into Group (A, B, C, D, E), i aant to apply certain amount of goals.
... View more
So, I'm trying to set a specific range of values for one variable (Goals_scored) and then be able to say..if someone falls into Group (A, B, C, D , E, etc) I want to set this many goals scored for them. How would I do that?
... View more
Using operator(arithmetic) propagates missing values while functions ignore missing values. What if you use a function with an operator? Ie sum(of var1-var9) ?
... View more
Thanks, Novinorsin. No doubt that missing values might be valuable and are not the same as 0's..but how we would go about setting numeric missing to zero? I was wondering if this was the default behavior?
... View more
