Are you talking about numbers or strings? ... View more

So it seems the file is created as .csv in another part of the program, you need to look there. ... View more

Kumar, if you are already moving towards an "admin" role: - read, read, read. Since there are literally tons (in terms of paper, if printed) of SAS documentation out there, that is an absolute prerogative. I have found that posting the contents of an error message or a log in google with "SAS" prepended often returns a usable link to information immediately. - get a solid grip on the operating system which is used for the SAS server. With CLI access, you may find you can solve lots of problems quickly using generic OS tools. Server OS's are VERY powerful, and the "read, read, read" is also valid there. Knowledge of the server OS puts you on an equal footing with those who run/administrate it. Large operations tend to produce people who avoid work by feeding bullshit to those that they consider to have no clue. Proving them wrong can be exhilarating and rewarding . I often find myself (in the admin role) close to falling into this trap, so I force myself to rethink WHY I have placed certain restrictions on users. - real security for data has to be done at the OS level. Only there can you be sure that nothing untowards happens (think of your case: restricting access via metadata is useless if you can still use the CL to copy a file to your sasuser directory). - if then you have problems that seem impossible to solve, or if you suspect that there may be more efficient solutions, don't hesitate to open threads here or in other places (stackexchange.com, stackoverflow.com etc). That way you tap into the cumulative wisdom of the whole _planet_. ... View more

I see, you need to copy the flow information and not only the items in the PF. That seems to be impossible at the moment. Do you have complex flows with conditions or is it simple A -> B -> C chains? If that were the case, you could try to export the whole code of the PF and handle it from there as a single program source. ... View more

AFAIK, you have to mark all objects in the source process flow and copy/paste them to the new process flow in the target project. ... View more

try this: *get all ID's; proc sort   data=mytab (keep=ID)   out=control   nodupkey ; by ID; run; *to be on the safe side; proc sort data=mytab; by ID MONTH; run; *make 12 months for every ID; data control2; set control; do MONTH = 1 to 12; output; end; run; data result; merge   mytab (in=a)   control2 (in=b) ; if b; by ID MONTH; *everytime there is no record from mytab, quantity is implicitely set to .; run; Edit: Ups, forgot "by ID MONTH;" in the last data step. ... View more

Would you kindly provide the code? I don't really find where your problem is. - Does the code that worked in 9.1 crash in 9.3? - do you get the button in 9.1 but not in 9.3? ... View more

This gets you your required result: data table1; input ID1 ID2:$ Data1; cards; 1 ab 80 2 . 100 . b 55 5 x 10 ; run; data table2; input ID1 ID2:$ Data2; cards; . a 12 1 ab 14 4 b 15 5 . 22 ; run; proc sort data=table1; by ID1; run; proc sort data=table2; by ID1; run; data   merge1 (keep=ID1 ID2 data1 data2 var1 var3)   rest1 (keep=ID1 ID2 data1)   rest2 (keep=ID1 ID21 data2 rename=(ID21=ID2)) ; merge   table1 (in=a)   table2 (     in=b     rename=(ID2=ID21)   ) ; by ID1; if a and b and ID1 ne . then do;   var1 = 1;   if ID2 = ID21   then var3 = 1;   else var3 = 0;   output merge1; end; else do;   var1 = 0;   if a   then output rest1;   if b   then do;     ID2 = ID21;     output rest2;   end; end; run; proc sort data=rest1; by ID2; run; proc sort data=rest2; by ID2; run; data   merge2 (drop=ID11)   rest3 (drop=ID11) ; merge   rest1 (in=a)   rest2 (in=b rename=(ID1=ID11)) ; by ID2; if a and b then do;   var2 = 1;   output merge2; end; else if ID1 ne . then do;   if a then output rest3;   else do;     ID1 = ID11;     output rest3;   end; end; run; data result; format ID1 ID2 data1 data2 var1 var2 var3; *puts the vars in order; set merge1 merge2 rest3; if var1 = . then var1 = 0; if var2 = . then var2 = 0; if var3 = . then var3 = 0; run; var1 = matched by ID1 var2 = matched by ID2; var3 = ID2 would have matched, but ID1 took preference var2 = ... View more

UTILLOC in the configuration file allows you to specify a location different from WORK for the temporary sort file. This will reduce the requirement for the file to be sorted to 2x. If you do proc sort data=x1.xxx out=x2.xxx; where x1 and x2 are libraries on different file systems, this may also help preventing an out of space condition, because you "only" need the size of xxx to be free one time in the UTILLOC and the x2 location, alike. Then I recommend what Jaap suggested, split the file, sort every partial file on its own, and then do: data want; set   have1   have2   ...   haven ; by sortcrit; run; This is called interleaving, the sort order is preserved. ... View more

Your drill through result is just too big to display. You might find this helpful: SAS(R) 9.2 Intelligence Platform: Application Server Administration Guide Look at Set Values in the Performance Tab of the Advanced Options Window and Maximum number of tuples in a set But be careful, these limits are high by default. I recommend doing a manual test on the data to get a feel about how many tuples the drill through should yield. ... View more