Hi! See the data set bellow to understand the variables I'm trying to work with   data TEST; input Ref    Date$    Cycle    side$    value; datalines; 024301 2017-04-03 1 A 39.969 024301 2017-04-03 1 B 40.645 024301 2017-04-03 1000 A 44.353 024301 2017-04-03 1000 B 44.788 024301 2017-04-03 10000 A 52.774 024301 2017-04-03 10000 B 47.719 024301 2017-04-03 30000 A 53.998 024301 2017-04-03 30000 B 51.878 ; run;     I have about 4000 observations. Every Ref has 8 observations: cycle 1 (A and B), cycle 1000 (A and B), cycle 10 000 (A and B) and cycle 30 000 (A and B). Here's what I want to do for every different Ref number (about 800 different Ref numbers): - take the Value with cycle= 1 and side =A  (same for Side B) to be stored in a new variable "CYCLE1_VALUE" beside all the other cycles with the same Ref, same Date and same Side. See the table bellow for an illustration of what I want:   data WANT; input Ref    Date$    Cycle    side$    value     CYCLE1_VALUE; datalines; 024301 2017-04-03 1 A 39.969    39.969 024301 2017-04-03 1 B 40.645    40.645 024301 2017-04-03 1000 A 44.353    39.969 024301 2017-04-03 1000 B 44.788    40.645 024301 2017-04-03 10000 A 52.774    39.969 024301 2017-04-03 10000 B 47.719    40.645 024301 2017-04-03 30000 A 53.998     39.969 024301 2017-04-03 30000 B 51.878     40.645 ; run;   I need to do this for the 800 different Ref numbers... There are no regularities in the ref numbers, unfortunately...  I will need to do easy math after that! How can I do that?   Thanks! Marie-Christine ... View more

 In this code bellow, I'm trying to put a varaiable for the letter A in the word ProfileA. I want to bea able to do it for ProfileB and ProfileC. I've tried to put the variable &profile. to replace every "A" in the programme but it gives me empty table... No error in the log... So I figured that the problem was in the did=dopen("ProfileA") or in the findw(name,'ProfileA.csv') section... Hoe can I do to make it work?   Thank you!       %macro ouvrir(table,orni); proc delete data=fichiers_profileA_&orni. fichiers_profileA; run;quit; data _null_;     set &table. end=eof;     if eof then call symput('nomdossier',_n_); run; %do i=1 %to &nomdossier;     data _null_;     set &table.(where=(numero=&i.));     %global dossier;     call symput('dossier',memname);     run;     %put &dossier; /*****Faire la table avec tous les noms de fichiers*******/          %let rep=\\sdlc000-000010\soutien$\Projets\ORN - STL-0108\Acquisitions\&orni.\&dossier.;     filename profileA "&rep.";     data fichiers_profileA;     length name $55;     drop rc did i;     did=dopen("profileA");     if did > 0 then do;     do i=1 to dnum(did);         name=dread(did,i);         if findw(name,'ProfileA.csv')>0 then output;     end;     rc=dclose(did);     end;     else put 'Could not open directory';     run;     proc append data=fichiers_profileA base=fichiers_profileA_&orni.;     run;quit; %end; %mend ouvrir; %ouvrir(Filenames1593_epuree,1593); %ouvrir(Filenames4906_epuree,4906); %ouvrir(Filenames6361_epuree,6361); ... View more

Hi! I did a code to list every folder in a certain path and I sorted them (befor this step) and the folder I'm interested in are in the table "Filenames1593_epuree", witch I called at the end of the macro bellow. It contains 25 folder names.   /*****List of all the folders to open****/ /*****determine the number of different name in the table*****/ %macro ouvrir(table);     data _null_;     set &table. end=eof;     if eof then call symput('nomdossier',_n_); run;   /*****for every non empty line, attribute a memname into the 'dossier' variable************/ %do i=1 %to &nomdossier;     data _null_;     set &table.(where=(numero=&i.));     call symput('dossier',memname);     run;     %put &dossier; %end; %mend ouvrir; %ouvrir(Filenames1593_epuree);   This macro up here works well. The problem is when I want to use these folder names to open them and get to every file inside of it. I did this bellow and it works well if I test it with a specific folder instead of &dossier. But, when I do it with a variable in de %let statement, I get nothing... (see log message after the code). What am I doing wrong? Thank you very much!! %let rep=\\sdlc000-000010\soutien$\Projets\ORN - STL-0108\Acquisitions\1593\&dossier.; filename profileA "&rep."; data fichiers_profileA; length name $55; drop rc did i; did=dopen("profileA"); if did > 0 then do; do i=1 to dnum(did);     name=dread(did,i);     if findw(name, 'profileA.csv')>0 then output; end; rc=dclose(did); end; else put 'Could not open directory'; run;   log message 2764  %let rep=\\sdlc000-000010\soutien$\Projets\ORN - STL-0108\Acquisitions\1593\&dossier.; WARNING: Apparent symbolic reference DOSSIER not resolved. 2765 2766  filename profileA "&rep."; WARNING: Apparent symbolic reference DOSSIER not resolved. 2767 2768  data fichiers_profileA; 2769  length name $55; 2770  drop rc did i; 2771  did=dopen("profileA"); 2772  if did > 0 then do; 2773  do i=1 to dnum(did); 2774      name=dread(did,i); 2775      if findw(name, 'profileA.csv')>0 then output; 2776  end; 2777  rc=dclose(did); 2778  end; 2779  else put 'Could not open directory'; 2780  run; Could not open directory NOTE: The data set WORK.FICHIERS_PROFILEA has 0 observations and 1 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds   ... View more

Hi!   I would like to be able to add a column in my table (see the picture joined) made by proc tabulate where I can put a new column with the result of 'n_insuffisant / indic', in percent... for example,                                                           Indic     n_insuffisant   new_column an         caracteritistique    c              2012     PourBitume          EC-10      55              21                  21/55%                                           EG-10      9                2                    2/9%                                           ...           ...                ...                    ...   thank you!   ... View more

Hi!   I am trying to make a table printed listing few variables (numeric and character). I know how to use one of the variable in the "by" statement so I have 5 different tables (example: in the variable 1, I have 5 different values, so I seperate my 5 tables by grouping them in these 5 values).   My question is: in each of the 5 tables, I want an other variable (TEST)  to be the group indicator in the first column. I dont want any math to be done with the values, I only want to make a list (Proc tabulate makes a sum and I don't want that!). Se the picture.   Can you help me please?   Thanks a lot!!   ... View more

Hi!   I'm trying to make a PROC TABULATE for a big amount of observations (60 000), and there are few missing values for some variables... I want to exclude these missing values from the stats I calculate, but I don't want to delete de rows! Some observations can be used for one variable and not the other... (n=6500 instead of 6480 (there are 20 missing values))   Code:   proc tabulate data=Recyc.aqhc_cc; class     groupe_enrobe         Calibre        R; var        ecart_Ta_5               ecart_Ta_080             ecart_TG              ecart_PourBitume; table (groupe_enrobe)*(calibre),(R    All)*(n)    (R    All)*(ecart_Ta_5    ecart_Ta_080    ecart_TG                                                                                                                                                                                  ecart_PourBitume)*(std); run;   I want n to be counted without missing values of variables... Same for std...   Thanks for your help!!! 🙂 Marie-Christine ... View more