I'm looking for ways to generate new obs from empty dataset(which have 0 obs). Let's say you have 2 obs in adsl. From this data set, we create 0obs dataset(adsl_empty).   After that, please tell me if you know how to generate only 1obs with USUBJID = "No patients"; As I get "0 obs" after executing below sample. I want this to be 1 OBS in "adsl_x" dataset.   data work.adsl; USUBJID ="xx1";output; USUBJID ="xx2";output; run; data work.adsl_empty; set work.adsl; delete; run; data work.adsl_X; set work.adsl_empty; USUBJID = "No patients";output; run; Regards ... View more

When dde "output" from sas to EXCEL, looking for a method of outputting data to be a new line in the EXCEL file.   For example, when I put "ABC" (actually A??B??C) to excel, and open the EXCEL , I want to see it as A B C   "??" is a special code? "'0A'x"?   In the Internet,there is a information about How to "read" the EXCEL which including the new line code can be found , but there was no way of "output" or "export". please let me you know with your sample code?   Sincerely,t_ar_taat ... View more

I'm looking for a way to get the contents/variables of array. For example data work.chars; char1 = "aa"; char2 = "bb"; output; run; data work.test2; length _GETNAMES $40. ; set work.chars; array ch _CHARACTER_; do over ch; _GETNAMES = vname(ch); if _GETNAMES ^= "_GETNAMES" then put _GETNAMES; end; run;   We know that array "ch" has variable cha1 char2 inside,  Is there a way to get it with 1 time?  The result is "cha1 char2" or "cha1,char2". So as to allow “vlabel” function to get the content of label  in the variable. I'm searching a function or way to catch contents of array.   Sincerely. ... View more

Is there any way that I can determine whether the dataset is open or not? For example, If I open the dataset "x" in the work library,which means there is a window which title bar is "VIEWTABLE: work.X". In this situation,I exist below code data work.x; yy = 1; run; There's a ERROR log saying "member-level control" etc., you know. To avoid this, I'm looking for a way to grasp how this data set is open before casting the dataset(work.x) to DATA step.   I know "open" function,which is for open dataset.This time I'm looking "opened" or not. I asked “Google” but it seems no answer. Sincerely, ... View more

While the program is running, whether it is an execute by interactive mode or batch submit, is there any way to get by batch mode or interactive mode? Though the programmer is know it by his eyes or operation.   For example,these codes which you run in a batch submit, there is a little a problem.(a window is shown.) dm "output; clear; odsresults; clear;"; http://support.sas.com/kb/44/705.html   To avoid this, I would want to get my "run;" is by batch submit or interactive mode for make "If statement ". If "&mode_now" know this,I would make these "if branching". %if            &mode_now = "batch" %then %do; %end; %else %if &mode_now = "interactive" %then %do; dm "output; clear; odsresults; clear;"; %end;   Best Regards! ... View more