The solution put together by @Astounding and @Kurt_Bremser ended up working nicely in my situation. I wanted to use proc means to count distinct values because I am utilizing the types statement to get a variety of summary rows, which wouldn't work as easily in other procedures. My implementation looked something like this: proc means data=input_data noprint;
class category subcategory subject;
types category*subcategory*subject category*subject subject;
output out=data1(rename=_type_=type) n=n;
run;
proc means data=data1 noprint nway missing;
class category subcategory type;
var n;
output out=data2(drop=_:) n=n sum=sum;
run; In fact, with that method, I was able to to get both a count of distinct subjects (the n column in data2) and a count of all rows (the sum column in data2).
... View more
Can anyone tell me how (monotonic() - min(monotonic())+1) this is working and assigning the rank as 1,2,..so on . Monotonic will give 1,2,3, and so on and min(monotonic) is 1 so i dont get how it is calculating the rank on which basis?? 1-1+1=1 2-1+1=2 is this the way it is working??
... View more
With proc sql like so:
Data A;
Do n = "ASFE", "ISFE", "SFXE";
Output;
End;
Run;
Proc SQL NoPrint;
Select n Into :n Separated By "," From A;
Quit;
%Put **&n.***;
* **ASFE,ISFE,SFXE***;
... View more
Two ways:
- Sum{<(t),j,(i)> in _Time_Arcs_} (If (t-DELTATIME[j,i]) in _Time_ Then Flow[t - DELTATIME[j,i],j,i])
- Sum{<(t),j,(i)> in _Time_Arcs_: t-DELTATIME[j,i] in _Time_} Flow[t - DELTATIME[j,i],j,i]
... View more
Do you have a specific question or need @ldeclou? If so, please start a new question so that our experts may best help you.
Thanks,
Shelley
... View more
Yes, then build your auto update process using Excel and VBA. With that you can create an OnOpen function (note this does not have to be part of the actual SAS file, the VAB can be in a separate file) which opens the CSV file you exported from SAS, reads that in and processes it into your Excel file, then refresh all the objects within the Excel file and save it. Its pretty simple, and you can kick it off from SAS just by asking the OS to open the working file - which would kick off its OneOpen function, load CSV, update other Excel file, refresh then save and shut down.
I would highly advise to avoid DDE.
... View more
When I combine execute (declare @MaxDate select @MaxDate = ..) it seems to work, at least I am not getting an error message. However, the local variable seems to be erased between the statements, so I cannot use it in the create-table-from-connection-statement. It seems it is something I just should not do.
... View more
how to get a datepart and timepart from anydtdtm. data without using character functions... data mh17; format edate datetime19.; input edate anydtdtm.; datalines; 12:01:2010:11:33:45 ; run;
... View more
This shows an example:
%let input_key=CUSTOMER_ID, BANK_ID;
%put %scan(%quote(&input_key.),1,%str(,));
%put %scan(%quote(&input_key.),2,%str(,));
... View more
%macro InsertSpace(location=,no_spaces=)
Data Want;
set Have;
/*Assuming the Variable opt for Transformation is string
and it have enough length to contain the spaces
*/
Substr(string, &location.) = Repeat(' ', &no_spaces.) || Substr(string, &location.);
Run;
%mend InsertSpace;
%InsertSpace(location=5,no_spaces=3); @user24feb This is little modification to your code.
... View more
