cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GeorgeSAS
‎08-17-2021
  • 313 Posts
  • 94 Likes Given
  • 4 Solutions
  • 12 Likes Received

Re: compress =yes CPU time

by Lapis Lazuli | Level 10 in SAS Programming
‎09-07-2017 02:08 PM
‎09-07-2017 02:08 PM
This is very interesting,I will test it soon. Thanks! ... View more

compress =yes CPU time

by Lapis Lazuli | Level 10 in SAS Programming
‎09-06-2017 08:00 PM
‎09-06-2017 08:00 PM
Hello everyone,   The compress option will save space around 50% for large dataset. but will run longer and need more time to finish a program.   May I ask approximately how much more CPU time needed to use compress =yes on large SAS dataset?  if the original program use 2 hours to run without compress=yes.    Thanks ... View more

Re: need some trigger program

by Lapis Lazuli | Level 10 in SAS Programming
‎09-06-2017 01:32 PM
‎09-06-2017 01:32 PM
Thank you Reeza,   I am confuse about what you said. would you please modify my code and show me where to make changes? that will greatly help me.   Thank you very much! ... View more

Re: need some trigger program

by Lapis Lazuli | Level 10 in SAS Programming
‎09-05-2017 07:20 PM
‎09-05-2017 07:20 PM
Thank you Patrick,   The waitfor statement should be what I need.but it not works, please help me correct my code in detail:   *A program of PC SAS; libname PC_lib "c:\temp\test123"; data PC_lib.one; x=1; run; *--connect to unix using SAS connect; %connect(U_server,abc);/*a macro use SAS connect to connect from PC to UNIX*/ rsubmit remote=U_server WAIT=NO; libname unix_lib "...";/*unix_lib is a library in UNIX*/ data unix_lib.two; y=2; run; endrsubmit; signoff remote=userver; WAITFOR _ALL_ userver; libname u_map "......."; /*u_map is a mapping drive in PC ,it will point to UNIX drive unix_lib*/ * need u_map.two ready before try to create PC_lib.three; data PC_lib.three; set PC_lib.one u_map.two; run;   Thanks! ... View more

Re: need some trigger program

by Lapis Lazuli | Level 10 in SAS Programming
‎09-05-2017 04:12 PM
‎09-05-2017 04:12 PM
I don't know how to wait and run the include part after SAS connect section finish. %include method is calling SAS program stored out side the current program. I want to know how to active it after SAS connect section finished. if I just add an %include after SAS connect. the %include part will be executed immediately after the SAS connect (it doesn't know SAS connect section finished or not) --so what i need is a trigger that can tell the %include that the SAS connect section is totally finished and %include can start. Thanks ... View more

Re: SAS graph suggestion needed

by Lapis Lazuli | Level 10 in Graphics Programming
‎09-05-2017 12:33 PM
‎09-05-2017 12:33 PM
Other than two lines, is there a better visual effect graph that can compare them in percentage? Thanks! ... View more

Re: need some trigger program

by Lapis Lazuli | Level 10 in SAS Programming
‎09-05-2017 12:31 PM
‎09-05-2017 12:31 PM
Thank you very much!   Read the new file and check its status for every several minutes. that is a very useful solution but it cost I/O too much also need created some extra file and code. I hope there is a better way to to this.     Thanks! ... View more

need some trigger program

by Lapis Lazuli | Level 10 in SAS Programming
‎09-05-2017 12:15 PM
‎09-05-2017 12:15 PM
 Hello everyone,   I run a main SAS program in PC, in this program SAS CONNECT will be used to connect UNIX  and run SAS program in UNIX. after running the UNIX SAS program,the main PC SAS program will run another final program in PC local.this final program will need the output dataset generated from the last UNIX program.   My question is how to create a trigger program so the final program in PC will begin to run after the UNIX SAS program is done?   Thanks! ... View more

SAS graph suggestion needed

by Lapis Lazuli | Level 10 in Graphics Programming
‎08-31-2017 11:54 AM
‎08-31-2017 11:54 AM
Hello everyone,   SAS can draw different kinds of graphics,I need your suggestion for what kind of SAS graph is the best for my project.   In my project, I need to compare two groups of data for 12 months,new_plan and old_plan , the data values are production. new_plan has better value than old .I want to know how good in graphics by monthly. Would you please give me advice on what kind of graph can best discript this comparasion?(value of new group is better in percentage than old.)   data compare; input month new_plan old_plan; cards; 1 131 115 2 130 114 3 129 113 4 128 112 5 126 110 6 125 109 7 124 108 8 122 107 9 121 106 10 120 104 11 118 103 12 117 102 ; run; Thanks!   ... View more

Re: Browse a large format

by Lapis Lazuli | Level 10 in SAS Programming
‎08-23-2017 03:48 PM
‎08-23-2017 03:48 PM
Thank you! %macro makefmt; Proc format library=work; value j3unk %do i=1 %to 100; &i. = "value&i." %end; ; run; %mend makefmt; %makefmt; ods _all_ close; options ps=max; ods listing file="c:\temp\bigformat" ; proc format fmtlib lib=work.formats; select j3unk; /*obs=10 only works for sas dataset;SAS format can't be splitted as sas dataset*/ run; ods listing;   ... View more

Re: Browse a large format

by Lapis Lazuli | Level 10 in SAS Programming
‎08-23-2017 01:40 PM
‎08-23-2017 01:40 PM
filename ffout .; proc catalog catalog=lib.formats; contents FILE=ffout; run; quit;   This is result you want to see:     Name Type Description Create Date Modify Date LARGEJK                       FORMATC                                               21Aug17:17:27:43    21Aug17:17:27:43 Total number of entries: 1   I would like to combine this topic with the old one, the reason I open this new one is I don't want the question jump to much that confuse you.   I can browse SAS format only within a html style output. is there any other way to browse a format? I can't browse the format(LARGEJK) ,it is too large.   There is no firstobs=  obs= option for a format.   Thanks! ... View more

Re: Browse a large format

by Lapis Lazuli | Level 10 in SAS Programming
‎08-23-2017 12:52 PM
‎08-23-2017 12:52 PM
Thank you,   Browse a SAS data set is no problem but how about SAS format?   Thanks ... View more

SAS data set running queue

by Lapis Lazuli | Level 10 in SAS Programming
‎08-22-2017 07:34 PM
‎08-22-2017 07:34 PM
Hello everyone,   When several different SAS programs(run at same time) need to share a same SAS dataset(stored in UNIX) as there input source. Is there any order who will use the dataset first? or they can use it by given CPU time randomly??? that dataset is a large data. each programs will use it for not just a minute.   Thanks! ... View more

Browse a large format

by Lapis Lazuli | Level 10 in SAS Programming
‎08-22-2017 02:35 PM
‎08-22-2017 02:35 PM
  https://communities.sas.com/t5/General-SAS-Programming/SAS-large-format/m-p/386954#M48990     Additional to the above question,May I ask how to browse a large SAS format?   Also, SAS format stored like a html file,I don't know how to split it as we split SAS dataset:   Can we store SAS format to another type?   Thanks! ... View more

Re: execute a shell script from unix sas

by Lapis Lazuli | Level 10 in SAS Programming
‎08-21-2017 12:42 PM
‎08-21-2017 12:42 PM
Thank you Kurt,   Does it must be a .sh file to use 2>&1 ?   if it is a sas file, I can't use this : "sas sortdata.sas 2>&1"  thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-17-2021 03:05 AM
Likes given to
Likes from
Quick links