About user24feb

user24feb · ‎10-19-2015

Hello, this is a somewhat embarrassing question, but I can't change column width in EG 7.1 (this wasn't the case in EG 6) for several columns. What works is: 1. select a single column (in the process flow window) > a double headed arrow appears > change the column with of a single column 2. mark several columns > right-click > use "width .. " in the menu-window > change the width of several columns What doesn't work is: 3. select a couple of columns > the double-headed arrow appears > change the column width of the selected columns (pressing shift or control doesn't change anything) > only the column widht of 1 column changes Please help 🙂 & Thanks

user24feb · ‎10-15-2015

Proc compare has an automatically generated macro-variable which tells you this: &sysinfo. (zero means equal). (use noprint to suppress the output of proc compare). The return codes in detail are here: http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146743.htm .. or you could use proc sql or merge or something like this

user24feb · ‎10-15-2015

Use Proc Compare: Data A B; Do i=1 To 10; Output; End; Run; Data C; Do i=2 To 12; Output; End; Run; Proc Compare Base=A Comp=B; Run; Proc Compare Base=A Comp=C; Run;

user24feb · ‎10-15-2015

However, this would give the same result: %Let Span=5; *!; Data A; Do Firm=1 To 3; Do i=0 To 20; Date=IntNX('month',"01JAN2000"d,i,'same'); Rtn=RanNor(1)/10; Output; End; End; Drop i; Format Date Date9.; Run; Data B (Keep=Firm Date Rtn Total_Rtn_&Span.); Retain dummy ; Set A; By Firm; If First.Firm Then Do; count=0; dummy=1; End; count+1; Drop_Value=Lag&Span.(Rtn); If count gt &Span. Then Do; dummy=dummy*(1+Rtn)/(1+Drop_Value); End; Else Do; dummy=dummy*(1+Rtn); End; Total_Rtn_&Span.=dummy-1; Run;

user24feb · ‎10-15-2015

A brute force approach would be (maybe proc timedata is worth looking): %Let Span=5; *!; Data A; Do Firm=1 To 3; Do i=0 To 20; Date=IntNX('month',"01JAN2000"d,i,'same'); Rtn=RanNor(1)/10; Output; End; End; Drop i; Format Date Date9.; Run; %Macro L; %Do i=1 %To &Span.; %If &i.=1 %Then %Do; Data B; Set A; A_Rtn1=(1+Rtn); Run; %End; %Else %Do; Data B; Set B; By Firm; A_Rtn&i.=Lag(A_Rtn%Eval(&i.-1)); If First.Firm Then Call Missing (A_Rtn&i.); Run; %End; %End; %Mend; %L; Data B (Drop=A_:); Set B; Array A A_:; Total_Rtn_&Span.=1; Do over A; Total_Rtn_&Span.=Total_Rtn_&Span.*A; End; Total_Rtn_&Span.=Total_Rtn_&Span.-1; Run;

user24feb · ‎10-13-2015

Try: Data A; Do SampSize= 5 To 50 By 5, 60 To 100 By 10; Output; End; Run;

user24feb · ‎09-30-2015

Try: Data A; Number=123; Output; Run; ODS Tagsets.ExcelXP File="D:\Test.xml" Style=HTMLBlue; Proc Report Data=A; Column Number; Define Number/Display Style(Column)={TagAttr='Format:0.00000'}; Run; ODS Tagsets.ExcelXP Close;

user24feb · ‎09-29-2015

You could try: Data A; Input y $20.; Datalines; SDFED GDDE CDEX DFDXCE DD ; Run; %Let x=40; Data B; Set A; z=Repeat('@',&x.); Substr(z,1,Length(y))=y; Run;

user24feb · ‎09-24-2015

Hello, I would like to create a world map showing various locations and a custom legend witch consecutive numbers representing the locations. The first problem is that the caption is too "high", this is, number 3 should be on the coast, not in the Atlantic. Second, I would like to get a legend, which shows which location is represented by which number, this is, 1 .. New York, 2.. Ann Arbor, etc. * Sites; Data Position; Input @1 City $ @30 y @42 x; x=atan(1)/45 * x; y=atan(1)/45 * y; Nr=_N_; Datalines; New York 40.714352 74.0059731 Ann Arbor 42.2808256 83.7430378 Santiago de Compostela 42.8782132 8.5448445 Dalian 38.914003 -121.614682 ; Run; * World Map; Data World (Rename=(long=x lat=y)); Set maps.world (Drop=x y); Run; * Sites+Map; Data Combo; Set Position World; Run; Proc GProject Data=Combo Out=Proj Project=Gall; ID Cont ID; Run; Quit; Data Map Anno; Set Proj; If City='' Then Output Map; Else Output Anno; Run; Quit; Data Anno; Length Color $8. Text $20. Style $25.; Set Anno; Retain xsys ysys '2' function 'label' when 'a'; text=Compress(Put(Nr,Best2.)); color='steel'; position='2'; size=0.8; Output; run; Pattern1 v=ms r=77 c=PALG; Title1 'Title'; Proc GMap Data=Map Map=Map; ID Cont ID; Choro ID / Anno=Anno COutLine=white; Run; Quit; Thanks&kind regards

user24feb · ‎09-23-2015

Hello, I get persisting page not found errors when klicking around in the new SAS communities webpage. Eventually it goes away, but what am I doing wrong?

user24feb · ‎09-23-2015

I think slchen's code is a good option. With a Perl-Expression you can kick out all the leading and trailing 0's while keeping the ones in the middle. Data Have; Input business_code $50.; Datalines; 0001254872154000000 0095874502460000 02154986532 5498876521000 ; Run; Proc SQL; Create Table Want As Select *, PRXChange("s/(^0+|0+$)//",-1,Strip(business_code)) As BC_New From Have; Quit;

user24feb · ‎09-23-2015

Data A; Input value1 $ value2 $; Datalines; a a b a c b . m ; Run; Data B; If _N_ eq 1 Then Do; Declare Hash H (Dataset:'A (Drop=value1 Rename=(value2=value1)'); H.Definekey('value1'); H.Definedone(); If 0 Then Set A (Drop=value1 Rename=(value2=value1)); End; Set A; dummy=1-Min(H.Find(),1); Run;

user24feb · ‎09-16-2015

Thanks, your answer is of course right. But I think I will have a follow-up question. (The "helpful answer option is gone, I believe.)

user24feb · ‎09-15-2015

Hello, If this is a constraint (for proc optmodel) I need: Constraint Example:Sum{<v,'123','ABC'> in v_l_m}X[v]*M[v,'123','ABC']; .. but the subscript '123' does not exist for all M[v,l,m]'s. (It's not missing, the entry itself has been left out.) How can I avoid the 'invalid array subscript error'? Thanks&kind regards

user24feb · ‎09-14-2015

Hello, When I run a certain process flow in Enterprise Guide in batch I get the following error message: ERROR: You cannot open xxx for output access with member-level control because xxx.DATA is in use by you in resource environment IOM ROOT COMP ENV. If I run the programs separately, I don't get an error message. What am I doing wrong? Thanks & kind regards

Online Status	Offline
Date Last Visited	‎09-02-2022 10:58 AM

Re: Macros

Conditionally define a constraint with proc optmodel

Re: Define Constraint for Proc Optmodel

Define Constraint for Proc Optmodel

Re: data set for "simulation models .." by Erdman

data set for "simulation models .." by Erdman

Re: Saving Excel-dataset after modifying

Saving Excel-dataset after modifying

Re: Create and slice a sparse set of parameters in proc optmodel

Create and slice a sparse set of parameters in proc optmodel

Re: Conditionally define a constraint with proc optmodel

Re: Define Constraint for Proc Optmodel

Re: data set for "simulation models .." by Erdman

Re: PROC EXPORT to XLSX is creating a .bak file

Re: Saving Excel-dataset after modifying

Re: Passing a comma delimited variable to a Macro

Re: log summary is blank

Re: import excel from , skipping first 7 lines

Re: data set for "simulation models .." by Erdman

Re: Splitting a macro variable string into 2

Change column widths in Enterprise Guide 7.1

Re: Check if two datasets are the same

Re: Check if two datasets are the same

Re: How to calculate buy-and-hold return based on daily return data

Re: How to calculate buy-and-hold return based on daily return data

Re: Do Loops with Multiple Conditions

Re: Increase Decimal places in Excel using ODS TAGSETS EXCELXP option

Re: Complete a string with "@" depending on it length

Proc GMap: Caption and custom legend

Persisting HTTP 404 Not Found Error when calling new communities webpa...

Re: PROC SQL issue

Re: How to create a dummy variable based on if the value in one column...

Re: Proc Optmodel Constraint Specification for Non-Existing (not missi...

Proc Optmodel Constraint Specification for Non-Existing (not missing) ...

program fails in batch mode, runs fine in windowed mode