Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. juanvg1972

    Problems linking dimension tables and fact tables in SSAS cube

    I have a problem with SSAS trying to relate tables. I have this tables: 1) hc_routes (airplanes routes): id_route, id_aeroline, id_airport_source, id_airport_destination PK: id_route 2) co_route_equipments (planes of each route) id_route, id_equipments PK: id_route, id_equipments (I have N...
  2. juanvg1972

    SAS/Pheedit

    Hi, Does anybody know about SAS/Pheedit a SAS solution for clinical studies?? I want to know if it's dificult to create a clinical study database with this tool. Database and queries of validation, How long does it take to create one?? Any advice will be greatly apreciatted. Thanks
  3. juanvg1972

    calling a macro from a data step

    Finally I have used formats (proc format). I think it's a usefull solution. http://recursossassoftware.blogspot.com.es/
  4. juanvg1972

    calling a macro from a data step

    I'm trying to create a field in a datasets based in the value of another field. I'm usind a macro to make se assignment of the value. Yo can see the process bellow. The real macro is not that simplem but I'ms using it to make tests. I expect that result: campo1 campo2 ab 1 ac 2...
  5. juanvg1972

    SAS/EG managing high volume of data and SAS/EG metadata managing high

    Hi, I have started to work with SAS/EG a few ago, I have worked a lot with SAS/BASE, but not SAS/EG. I have a doubt about SAS/EG. I know the main features of the tool, but I don’t know how it works with high volume of data and a lot of number of projects. I am starting a project with SAS/EG...
  6. juanvg1972

    Jobs execution based in events

    I have a question about jobs execution in sqlserver B.I. 2005 platform. I know that I can schedule a job that exec a sys in the platform, for example a batch execution, but I’m trying to launch a sys based in a event. The event is an e-mail. When I receive a e-mail in outlook, I would like to...
  7. juanvg1972

    Jobs execution based in events

    I have a question about jobs execution in sqlserver B.I. 2005 platform. I know that I can schedule a job that exec a sys in the platform, for example a batch execution, but I’m trying to launch a sys based in a event. The event is an e-mail. When I receive a e-mail in outlook, I would like to...
  8. juanvg1972

    How to Create New observation in SAS

    I'm not sure if I have understood your question, but perhaps yo can use 'retain' to repeat var1, var2, var3. and with code like if first.var1 then do; or if last.var2 then do; control the output of the rest of variables. Hope it helps...
  9. juanvg1972

    Question about REALMEMSIZE option

    I have a question about REALMEMSIZE option. Definition says: Some SAS procedures use the REALMEMSIZE option to specify how much virtual memory the procedure can allocate and use without inducing excessive page swapping. Then, I suppose is a parameter to control page swapping and to avoid...
  10. juanvg1972

    Problems using pipelin in MP Connect (UNIX)

    I’m trying to use the MP CONNECT piping facillity that uses ports rather than disk devices por I/O. I have this code: rsubmit wait=no; libname outLib sasesock ":pipe1"; /* create data set - and write to pipe */ data outLib.Intermediate; do i=1 to 5; put 'Writing row ' i; output; end; run...

Part and Inventory Search

Back
Top