SAS Support Communities

PaalNavestad · ‎06-09-2020

Hi , I have several custom ESRI shape files. I get these imported, but I cannot figure out how I can use these in VA 8. Can somebody please tell me how or point me to the right part of the documentation. Thanks

PaalNavestad · ‎05-18-2020

Thanks,

PaalNavestad · ‎05-18-2020

Thanks, Yes the outest has the data.

PaalNavestad · ‎05-18-2020

Hi, I'm coding a work flow where I first try to find a decline curve using Nlin. Some by groups has bad data or do not follow a decline. I can see this from the fact that the procedure does not Converge. I can use non-convergence as flag to call different methods. Basically I just want a way to programmatically see the fact that this text is put to the output/log WARNING: PROC NLIN failed to converge. I would rather not have to read the log/output as text if possible. Does anybody know of a macro/method to test for this in an easy manner?

PaalNavestad · ‎04-28-2020

Thanks again. I owe you a large beer:-)

PaalNavestad · ‎04-28-2020

Thanks a million Rob. I was a bit further along than when I wrote the post, but far from a solution. For Con1 and Con2 here you've coded the roles you can't have together. In real life there is approx. 20 roles to fill all with different roles you can't fullfill at the same time. on the top of your head is there a more dynamic way to write this constraint. If no it is not a large problem as the constraints can be created in a preceding macro. Also in real life some persons have clear preferences for certain roles. This is for an offshore platform where the personnel change rapidly. Since there in most cases are several solutions to the problem you can be assigned role A day 1 and then role B day 2. My thoughts on how to avoid this is to give the role you have the day before the value 1 and your preferred role Value 2. From that i would just hav a Var multiplying value and assign and maximize on that. Do you see any problems with that approach? Again thanks a lot.

PaalNavestad · ‎04-28-2020

Hi, I'm struggling to formulate/program an assignment problem. In real life the problem is filling an Emergency preparedness crew. The problem can be described as follows: Assume that yo have 5 workers P1..P5. These shall be assigned the roles A,B,C,D P1 can fill A and B, P2 can fill B,C,D, P3 can fill C, P4 can fill A,B,D and P5 can fill A,B,C,D. If you are assigned Role A you cannot be assigned any other role. If you are assigned role B You cannot fill role C. For Role A you need 1 person, For Roles B, C and D you need 2 persons. I'm struggling to get a decent formulation for the problem. I can express all assignements explicitly but struggle to find the right combinations. Can somebody please give me some ideas on how to get the problem formulated?

PaalNavestad · ‎06-06-2019

Thanks, works like a dream

PaalNavestad · ‎06-06-2019

Thanks a million. I did not think about dictonary.tables. Shame on me.

PaalNavestad · ‎06-06-2019

Hi. I'm having several Stored Procedures that I use to update/create tables that users can correct numbers and add lines. When I create the I just want to make a screen saying that the data set has been updated. I can get when the dataset information as dates, path, observations in the printed output from proc contents. However I have not found a way to get this in a dataset so I can test the date against current clock time and make a nice message saying updated successfully. The out statement only give the variables. Does anybody have a nice trick for this?

PaalNavestad · ‎05-14-2019

Thanks Falco. I tried creating a hierarchy the first time. However I created the hierarchy after I had added the Network Analyses and chosen Hierarchical. After your post I created the Hiearchy before adding the Network diagram and then i worked. Maybe a bug. The Levels name is a bit confusing

PaalNavestad · ‎05-13-2019

Hi, I'm trying to create a hierarchical Network diagram in VA 8.3. In VA /.x you could use a hierarchy either prebuilt or on the fly. However in VA 8.3 it asks for a level variable when trying to build a hierarchical Network. Can somebody please direct me to how I set a level variable?

PaalNavestad · ‎01-16-2019

HI, I'm trying to import tables from an access database in a Linux Environment. I have Access to PC files installed. However when trying to import I get ERROR: Server Name is invalid or missing. I can't find anywhere in the documentation where I can identicate where the PC Files server is located. The code I'm trying to run is proc import out=ofm_data_dca_case table="OFM_DATA_DCA_CASE" DBMS=ACCESSCS REPLACE ; DATABASE="/shared/winshare/teams_no/SAS_General/subsurface/dev/GGRE_IN/OFM_Avocet.mdb"; run; We are running on a LINUX Grid version 9.4 M5

PaalNavestad · ‎12-06-2018

I do not know. I seem to remember I did create a set of pies or donuts using sgchart about 15 years ago. But I can't exactly remenber how I very seldom use pie charts anymore and for the sunflower chart I had problems seeing the use. Have you just tried using midpoint/group and subgroup in gchart. I would prefer a treemap. There is a mosaic plot in GTL that you can try.

PaalNavestad · ‎12-06-2018

You can do it with sgplot or the GTL language. I do not have an example handy. You can alos look at proc tree from SAS/STAT that show the hierarchy very well. You have to juggle a bit. I think I've seen an example in the graphically speaking blog. Just google graphically speaking sas and it gets you there

Online Status	Offline
Date Last Visited	‎03-05-2024 05:14 AM

SAS Support Communities

Follow Us

What is...