comp.soft-sys.sas - The SAS statistics package.
Hi All, I have two data sets, each one has more than 200 variables (some of them are same, some are not). I wanna keep all variables of the first data set. How do I set two data sets but only keep those variables in the first data set? I cannot use keep= or drop= option since there are too many variables. Thanks a lot, Pooh
Hi all, I have been requested to create and present a short presentation on creating output data set from a proc tabulate. This would ideally entail the how to, the why you would need to and the benefits that can be gained by doing this. The problem is that at the moment, I have drawn a complete blank as to all of these questions with the exception of the how using the out = option, or the ods output options, but that option is all that I can find and it only creates a standard data set output. I have no idea as to whether it can be refined or manipulated in any way using other options. Is there anything more that can be done other than just simply outputting a standard data set, or am I flogging a dead horse? Any help would be gratefully appreciated. Many thanks for your time, Rob Walls. _______________________________________________________ This e-mail transmission and any documents, files or previous email messages attached to it may contain information that is confidential or legally privileged. If you are not the intended recipient or a person responsible for delivering this transmission to the intended recipient, you are hereby notified that you must not read this transmission and that any disclosure, copying, printing, distribution or use of this transmission is strictly prohibited. If you have received this transmission in error, please immediately notify the sender by telephone or return email and delete the original transmission and its attachments without reading or saving in any manner.
Hi, I need some assistance in creating tabulate reports. Even a sample pseudo code will help me get started.........thanks in advance...... hari >>>>>>>>>>>>>>>>>>>>>>>>> Data Have ; input etype $ NoOfEvents NetLoss GrossLoss Recoveries; cards ; EL1 2 31.375 31.375 . EL2 356 691.088 1268.643 346.173 EL3 1 5.602 5.602 . EL4 9 201.765 201.765 . EL5 13 35.376 35.376 . EL7 110 584.156 769.556 121.045 ; run ; >>>>>>>>>>>final report>>>>>>>>>>>>>> operational losses and recoveries > $1000 EventType 1Q06 GrossLoss Recoveries NetLoss # of events EL1 $31,375 $0 $31,375 2 EL2 $1,268,643 $346,173 $691,088 356 EL3 $5,602 $0 $5,602 1 EL4 $201,765 $0 $201,765 9 EL5 $35,376 $0 $35,376 13 EL6 $0 $0 $0 0 EL7 $769,556 $121,045 $584,156 110
Hi I have a problem as follows : I want to create a dataset C that copies all of data set A as well as adds an additional variable (varx) as 0/1 based on whether an observation id in dataset A occurs in dataset B (on the same date). I have tried a PROC SQL as follows but with no success: proc sql ; create table c as select a.*, case when a.id=b.id and a.date=b.date then 0 else 1 end as varx from datasetA as a, datasetB as b; quit; I get a timeout (OUT OF RESOURCES error). Any idea on what I am doing wrong here?