Solved: Re: Transposed data - Page 2

art297 · Posted 05-26-2017 10:43 PM

Just post the part of the log from the data step where you tried to create the file work.have

Art, CEO, AnalystFinder.com

kbl · Posted 05-26-2017 10:54 PM

Here %macro transpose(libname_in=,
390                   libname_out=,
391                   data= have,
392                   out= need,
393                   by=,
you go Art; I really appreciate all of your help.

art297 · Posted 05-26-2017 10:58 PM

That is not what I need to see. I need to see the log from your running:

Filename three 'G:\threeone.dat';
data have;
  infile  three expandtabs;
  input TIME_M $ SYM_ROOT $ SIZE PRICE TIME2;
run;
 
proc sort data=have out=need nodupkey;
  by time_m sym_root;
run;

Art, CEO, AnalystFinder.com

kbl · Posted 05-26-2017 11:01 PM

Here you go:

77 Filename three 'G:\threeone.dat';
778 data have;
779    infile three expandtabs;
780    input TIME_M $ SYM_ROOT $ SIZE PRICE TIME2;
781 run;

NOTE: The infile THREE is:
      Filename=G:\threeone.dat,
      RECFM=V,LRECL=32767,File Size (bytes)=4860534,
      Last Modified=26May2017:12:52:06,
      Create Time=25May2017:23:18:31

NOTE: 179219 records were read from the infile THREE.
      The minimum record length was 19.
      The maximum record length was 30.
NOTE: The data set WORK.HAVE has 179219 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.24 seconds
      cpu time            0.17 seconds

782
783 proc sort data=have out=need nodupkey;
784    by time_m sym_root;
785 run;

NOTE: There were 179219 observations read from the data set WORK.HAVE.
NOTE: 13934 observations with duplicate key values were deleted.
NOTE: The data set WORK.NEED has 165285 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.14 seconds
      cpu time            0.24 seconds

art297 · Posted 05-26-2017 11:05 PM

If you're still in the same session then just run:

%transpose(data=need, out=want, by=time_m, id=sym_root,
delimiter=_,var=price size)

Art, CEO, AnalystFinder.com

kbl · Posted 05-26-2017 11:18 PM

Art,

The file ran further into the program, but i have some errors. I just want to make sure I have everything in the proper order since that proc sort is currently appearing near the top and bottom of the program and the transpose macro is at the end. Is this all in the propoer order?

Filename three 'G:\threeone.dat';
data have;
infile three expandtabs;
input TIME_M $ SYM_ROOT $ SIZE PRICE TIME2;
run;

proc sort data=have out=need nodupkey;
by time_m sym_root;
run;
%macro transpose(libname_in=,
                 libname_out=,
                 data= have,
                 out= need,
                 by=,
                 prefix=,
                 var=,
                 autovars=,
                 id=,
                 descendingid=,
                 var_first=,
                 format=,
                 delimiter=,
                 copy=,
                 drop=,
                 sort=,
                 sort_options=,
                 use_varname=,
                 preloadfmt=,
                 guessingrows=,
                 newid=);

/*Check whether the data and out parameters contain one or two-level filenames*/
%let lp=%sysfunc(findc(%superq(data),%str(%()));
%if &lp. %then %do;
    %let rp=%sysfunc(findc(%superq(data),%str(%)),b));
    %let dsoptions=%qsysfunc(substrn(%nrstr(%superq(data)),&lp+1,&rp-&lp-1));
    %let data=%sysfunc(substrn(%nrstr(%superq(data)),1,%eval(&lp-1)));
%end;
%else %let dsoptions=;
%if %sysfunc(countw(&data.)) eq 2 %then %do;
    %let libname_in=%scan(&data.,1);
    %let data=%scan(&data.,2);
%end;
%else %if %length(&libname_in.) eq 0 %then %do;
    %let libname_in=work;
%end;

%if %sysfunc(countw(&out.)) eq 2 %then %do;
    %let libname_out=%scan(&out.,1);
    %let out=%scan(&out.,2);
%end;
%else %if %length(&libname_out.) eq 0 %then %do;
    %let libname_out=work;
%end;

%if %length(&newid.) eq 0 %then %do;
    %let newid=row;
%end;

/*obtain last by variable*/
%if %length(&by.) gt 0 %then %do;
    %let lastby=%scan(&by.,-1);
%end;
%else %do;
    %let lastby=;
%end;

/*Create macro variable to contain a list of variables to be copied*/
%let to_copy=;
%if %length(&copy.) gt 0 %then %do;
    data t_e_m_p;
      set &libname_in..&data. (obs=1 keep=&copy.);
    run;

    proc sql noprint;
      select name
        into :to_copy separated by " "
          from dictionary.columns
            where libname="WORK" and
                  memname="T_E_M_P"
        ;
      quit;
%end;

/*Populate var parameter in the event it has a null value*/
%if %length(&var.) eq 0 %then %do;
    data t_e_m_p;
      set &libname_in..&data. (obs=1 drop=&by. &id. &copy.);
    run;

    proc sql noprint;
      select name
        into :var separated by " "
          from dictionary.columns
            where libname="WORK" and
                  memname="T_E_M_P"
        %if %sysfunc(upcase("&autovars.")) eq "CHAR" %then %do;
                  and type="char"
        %end;
        %else %if %sysfunc(upcase("&autovars.")) ne "ALL" %then %do;
                  and type="num"
        %end;
        ;
      quit;
%end;

/*Initialize macro variables*/
%let vars_char=;
%let varlist_char=;
%let vars_num=;
%let varlist_num=;
%let formats_char=;
%let format_char=;
%let formats_num=;
%let format_num=;

/*Create file t_e_m_p to contain one record with all var variables*/
data t_e_m_p;
    set &libname_in..&data. (obs=1 keep=&var.);
run;

/*Create macro variables containing untransposed var names and formats*/
proc sql noprint;
    select name, case
                   when missing(format) then " $"||strip(put(length,5.))||'.'
                   else strip(format)
                 end
      into :vars_char separated by " ",
           :formats_char separated by "~"
        from dictionary.columns
          where libname="WORK" and
                memname="T_E_M_P" and
                type="char"
    ;
    select name, case
                   when missing(format) then "best12."
                   else strip(format)
                 end
      into :vars_num separated by " ",
           :formats_num separated by "~"
        from dictionary.columns
          where libname="WORK" and
                memname="T_E_M_P" and
                type="num"
    ;
    select name
      into :vars_all separated by " "
        from dictionary.columns
          where libname="WORK" and
                memname="T_E_M_P"
    ;
quit;

/*If sort parameter has a value of YES, create a sorted temporary data file*/
%if %sysfunc(upcase("&sort.")) eq "YES" %then %do;
    %let notsorted=;
    proc sort data=&libname_in..&data.
                (
                 keep=&by. &id. &vars_char. &vars_num. &to_copy.
                 &dsoptions.
                )
                 out=t_e_m_p &sort_options. noequals;
      by &by.;
    run;
    %let data=t_e_m_p;
    %let libname_in=work;
%end;
%else %do;
    %let notsorted=notsorted;
%end;

/*if no id parameter is present, create one from &newid.*/
%if %length(&id.) eq 0 %then %do;
    data t_e_m_p;
      set &libname_in..&data.;
      by &by.;
      if first.&lastby then &newid.=1;
      else &newid+1;
    run;
    %let id=&newid.;
    %let data=t_e_m_p;
    %let libname_in=work;
%end;

/*Ensure guessingrows parameter contains a value*/
%if %length(&guessingrows.) eq 0 %then %do;
    %let guessingrows=%sysfunc(constant(EXACTINT));
%end;

/*Ensure a format is assigned to an id variable*/
%if %length(&id.) gt 0 %then %do;
    proc sql noprint;
      select type,length,%sysfunc(strip(format))
        into :tr_macro_type, :tr_macro_len, :tr_macro_format
          from dictionary.columns
            where libname="%sysfunc(upcase(&libname_in.))" and
                  memname="%sysfunc(upcase(&data.))" and
                  upcase(name)="%sysfunc(upcase(&id.))"
        ;
    quit;

    %if %length(&format.) eq 0 %then %do;
      %let optsave=%sysfunc(getoption(missing),$quote.);
      options missing=.;
      %if %length(&tr_macro_format.) gt 0 %then %do;
        %let format=&tr_macro_format.;
      %end;
      %else %if "&tr_macro_type." eq "num " %then %do;
        %let format=%sysfunc(catt(best,&tr_macro_len.,%str(.)));
      %end;
      %else %do;
        %let format=%sysfunc(catt($,&tr_macro_len.,%str(.)));
      %end;
      options missing=&optsave;
    %end;
%end;

/*Create macro variables containing ordered lists of the requested transposed variable
names for character (varlist_char) and numeric (varlist_num) var variables */
%if %length(&preloadfmt.) gt 0 %then %do;
    %if %sysfunc(countw(&preloadfmt.)) eq 1 %then %do;
      %let preloadfmt=&libname_in..&preloadfmt.;
    %end;
%end;
%else %do;
    %if %sysfunc(upcase("&sort.")) eq "YES" %then
     %let dsoptions=;
    proc freq data=&libname_in..&data. (obs=&guessingrows. keep=&id. &dsoptions.)
       noprint;
      tables &id./out=_for_format (keep=&id.);
    run;
    %if %sysfunc(upcase("&descendingid.")) eq "YES" %then %do;
      proc sort data=_for_format;
        by descending &id;
      run;
    %end;
    data _for_format;
      set _for_format;
      order=_n_;
    run;
%end;

proc sql noprint;
%do i=1 %to 2;
    %if &i. eq 1 %then %let i_type=char;
    %else %let i_type=num;
    %if %length(&&vars_&i_type.) gt 0 %then %do;
    select distinct
      %do j=1 %to 2;
        %if &j. eq 1 %then %let j_type=;
        %else %let j_type=format;
        %do k=1 %to %sysfunc(countw(&&vars_&i_type.));
         "&j_type. "||cats("&prefix.",
          %if %sysfunc(upcase("&var_first.")) eq "NO" %then %do;
            put(&id.,&format),"&delimiter."
            %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
            ,scan("&&vars_&i_type.",&k.);
          %end;
          %else %do;
            %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
               scan("&&vars_&i_type.",&k.),;
            "&delimiter.",put(&id.,&format)
          %end;
          )
          %if &j. eq 2 %then
            ||" "||cats(scan("&&formats_&i_type.",&k.,"~"),";");
          %if &k. lt %sysfunc(countw(&&vars_&i_type.)) %then ||;
          %else ,;
        %end;
      %end;
      %if "&tr_macro_type." eq "num " %then &id. format=best12.;
        %else &id.;
        ,order
          into :varlist_&i_type. separated by " ",
               :format_&i_type. separated by " ",
               :idlist separated by " ",
               :idorder separated by " "
           %if %length(&preloadfmt.) gt 0 %then from &preloadfmt.;
           %else from _for_format;
               order by order
    ;
      %let num_numlabels=&sqlobs.;
    %end;
%end;
quit;

proc sql noprint;
    select distinct
        %let j_type=;
        %do k=1 %to %sysfunc(countw(&&vars_all.));
      "&j_type. "||cats("&prefix.",

          %if %sysfunc(upcase("&var_first.")) eq "NO" %then %do;
          put(&id.,&format),"&delimiter.",
            %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
          scan("&&vars_all.",&k.);
          )
          %end;
          %else %do;
            %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
          scan("&&vars_all.",&k.),;
          "&delimiter.",put(&id.,&format))
          %end;
          %if &k. lt %sysfunc(countw(&&vars_all.)) %then ||;
          %else ,;
        %end;
        order
          into :varlist_all separated by " ",
               :idorder separated by " "
           %if %length(&preloadfmt.) gt 0 %then from &preloadfmt.;
           %else from _for_format;
               order by order
    ;
quit;

/*Create a format that will be used to assign values to the transposed variables*/
data _for_format;
    %if %length(&preloadfmt.) gt 0 %then set &preloadfmt. (rename=(&id.=start));
    %else set _for_format (rename=(&id.=start));
    ;
    %if "&tr_macro_type." eq "num " %then retain fmtname "labelfmt" type "N";
    %else retain fmtname "$labelfmt" type "C";
    ;
    label=
     %if %length(&preloadfmt.) eq 0 %then _n_-1;
     %else order-1;
     ;
run;

proc format cntlin = _for_format;
run ;

/*Create and run the datastep that does the transposition*/
data &libname_out..&out.;
    set &libname_in..&data. (keep=&by. &id.
      %do i=1 %to %sysfunc(countw("&vars_char."));
        %scan(&vars_char.,&i.)
      %end;
      %do i=1 %to %sysfunc(countw("&vars_num."));
        %scan(&vars_num.,&i.)
      %end;
      %do i=1 %to %sysfunc(countw("&to_copy."));
        %scan(&to_copy.,&i.)
      %end;
      &dsoptions.
      );
    by &by. &notsorted.;
    &format_char. &format_num.
%if %length(&vars_char.) gt 0 %then %do;
    array want_char(*) $
    %do i=1 %to %eval(&num_numlabels.*%sysfunc(countw("&vars_char.")));
      %scan(&varlist_char.,&i.)
    %end;
    ;
    array have_char(*) $ &vars_char.;
    retain want_char;
    if first.&lastby. then call missing(of want_char(*));
    ___nchar=put(&id.,labelfmt.)*dim(have_char);
    do ___i=1 to dim(have_char);
      want_char(___nchar+___i)=have_char(___i);
    end;
%end;
%if %length(&vars_num.) gt 0 %then %do;
    array want_num(*)
    %do i=1 %to %eval(&num_numlabels.*%sysfunc(countw("&vars_num.")));
      %scan(&varlist_num.,&i.)
    %end;
    ;
    array have_num(*) &vars_num.;
    retain want_num;
    if first.&lastby. then call missing(of want_num(*));
    ___nnum=put(&id.,labelfmt.)*dim(have_num);
    do ___i=1 to dim(have_num);
      want_num(___nnum+___i)=have_num(___i);
    end;
%end;
    drop &id. ___: &var. &drop.;
    if last.&lastby. then output;
run;

data &libname_out..&out.;
    retain &by. &to_copy. &varlist_all.;
    set &libname_out..&out.;
run;

/*Delete all temporary files*/
proc delete data=work.t_e_m_p work._for_format;
run;

%mend transpose;
options NOQUOTELENMAX;
proc sort data=have out=need nodupkey;
by time_m sym_root;
run;

%transpose(data=need, out=want, by=time_m, id=sym_root,
delimiter=_,var=price size)

art297 · Posted 05-26-2017 11:24 PM

Again, without seeing your log I can't tell what did or didn't happen.

Art, CEO, AnalystFinder.com

kbl · Posted 05-26-2017 11:25 PM

Here you go:

2372 Filename three 'G:\threeone.dat';
2373 data have;
2374 infile three expandtabs;
2375 input TIME_M $ SYM_ROOT $ SIZE PRICE TIME2;
2376 run;

NOTE: The infile THREE is:
Filename=G:\threeone.dat,
RECFM=V,LRECL=32767,File Size (bytes)=4860534,
Last Modified=26May2017:12:52:06,
Create Time=25May2017:23:18:31

NOTE: 179219 records were read from the infile THREE.
The minimum record length was 19.
The maximum record length was 30.
NOTE: The data set WORK.HAVE has 179219 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.15 seconds

2377
2378 proc sort data=have out=need nodupkey;
2379 by time_m sym_root;
2380 run;

NOTE: There were 179219 observations read from the data set WORK.HAVE.
NOTE: 13934 observations with duplicate key values were deleted.
NOTE: The data set WORK.NEED has 165285 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.11 seconds
cpu time 0.17 seconds

2381 %macro transpose(libname_in=,
2382 libname_out=,
2383 data= have,
2384 out= need,
2385 by=,
2386 prefix=,
2387 var=,
2388 autovars=,
2389 id=,
2390 descendingid=,
2391 var_first=,
2392 format=,
2393 delimiter=,
2394 copy=,
2395 drop=,
2396 sort=,
2397 sort_options=,
2398 use_varname=,
2399 preloadfmt=,
2400 guessingrows=,
2401 newid=);
2402
2403 /*Check whether the data and out parameters contain one or two-level filenames*/
2404 %let lp=%sysfunc(findc(%superq(data),%str(%()));
2405 %if &lp. %then %do;
2406 %let rp=%sysfunc(findc(%superq(data),%str(%)),b));
2407 %let dsoptions=%qsysfunc(substrn(%nrstr(%superq(data)),&lp+1,&rp-&lp-1));
2408 %let data=%sysfunc(substrn(%nrstr(%superq(data)),1,%eval(&lp-1)));
2409 %end;
2410 %else %let dsoptions=;
2411 %if %sysfunc(countw(&data.)) eq 2 %then %do;
2412 %let libname_in=%scan(&data.,1);
2413 %let data=%scan(&data.,2);
2414 %end;
2415 %else %if %length(&libname_in.) eq 0 %then %do;
2416 %let libname_in=work;
2417 %end;
2418
2419 %if %sysfunc(countw(&out.)) eq 2 %then %do;
2420 %let libname_out=%scan(&out.,1);
2421 %let out=%scan(&out.,2);
2422 %end;
2423 %else %if %length(&libname_out.) eq 0 %then %do;
2424 %let libname_out=work;
2425 %end;
2426
2427 %if %length(&newid.) eq 0 %then %do;
2428 %let newid=row;
2429 %end;
2430
2431 /*obtain last by variable*/
2432 %if %length(&by.) gt 0 %then %do;
2433 %let lastby=%scan(&by.,-1);
2434 %end;
2435 %else %do;
2436 %let lastby=;
2437 %end;
2438
2439 /*Create macro variable to contain a list of variables to be copied*/
2440 %let to_copy=;
2441 %if %length(&copy.) gt 0 %then %do;
2442 data t_e_m_p;
2443 set &libname_in..&data. (obs=1 keep=&copy.);
2444 run;
2445
2446 proc sql noprint;
2447 select name
2448 into :to_copy separated by " "
2449 from dictionary.columns
2450 where libname="WORK" and
2451 memname="T_E_M_P"
2452 ;
2453 quit;
2454 %end;
2455
2456 /*Populate var parameter in the event it has a null value*/
2457 %if %length(&var.) eq 0 %then %do;
2458 data t_e_m_p;
2459 set &libname_in..&data. (obs=1 drop=&by. &id. &copy.);
2460 run;
2461
2462 proc sql noprint;
2463 select name
2464 into :var separated by " "
2465 from dictionary.columns
2466 where libname="WORK" and
2467 memname="T_E_M_P"
2468 %if %sysfunc(upcase("&autovars.")) eq "CHAR" %then %do;
2469 and type="char"
2470 %end;
2471 %else %if %sysfunc(upcase("&autovars.")) ne "ALL" %then %do;
2472 and type="num"
2473 %end;
2474 ;
2475 quit;
2476 %end;
2477
2478 /*Initialize macro variables*/
2479 %let vars_char=;
2480 %let varlist_char=;
2481 %let vars_num=;
2482 %let varlist_num=;
2483 %let formats_char=;
2484 %let format_char=;
2485 %let formats_num=;
2486 %let format_num=;
2487
2488 /*Create file t_e_m_p to contain one record with all var variables*/
2489 data t_e_m_p;
2490 set &libname_in..&data. (obs=1 keep=&var.);
2491 run;
2492
2493 /*Create macro variables containing untransposed var names and formats*/
2494 proc sql noprint;
2495 select name, case
2496 when missing(format) then " $"||strip(put(length,5.))||'.'
2497 else strip(format)
2498 end
2499 into :vars_char separated by " ",
2500 :formats_char separated by "~"
2501 from dictionary.columns
2502 where libname="WORK" and
2503 memname="T_E_M_P" and
2504 type="char"
2505 ;
2506 select name, case
2507 when missing(format) then "best12."
2508 else strip(format)
2509 end
2510 into :vars_num separated by " ",
2511 :formats_num separated by "~"
2512 from dictionary.columns
2513 where libname="WORK" and
2514 memname="T_E_M_P" and
2515 type="num"
2516 ;
2517 select name
2518 into :vars_all separated by " "
2519 from dictionary.columns
2520 where libname="WORK" and
2521 memname="T_E_M_P"
2522 ;
2523 quit;
2524
2525 /*If sort parameter has a value of YES, create a sorted temporary data file*/
2526 %if %sysfunc(upcase("&sort.")) eq "YES" %then %do;
2527 %let notsorted=;
2528 proc sort data=&libname_in..&data.
2529 (
2530 keep=&by. &id. &vars_char. &vars_num. &to_copy.
2531 &dsoptions.
2532 )
2533 out=t_e_m_p &sort_options. noequals;
2534 by &by.;
2535 run;
2536 %let data=t_e_m_p;
2537 %let libname_in=work;
2538 %end;
2539 %else %do;
2540 %let notsorted=notsorted;
2541 %end;
2542
2543 /*if no id parameter is present, create one from &newid.*/
2544 %if %length(&id.) eq 0 %then %do;
2545 data t_e_m_p;
2546 set &libname_in..&data.;
2547 by &by.;
2548 if first.&lastby then &newid.=1;
2549 else &newid+1;
2550 run;
2551 %let id=&newid.;
2552 %let data=t_e_m_p;
2553 %let libname_in=work;
2554 %end;
2555
2556 /*Ensure guessingrows parameter contains a value*/
2557 %if %length(&guessingrows.) eq 0 %then %do;
2558 %let guessingrows=%sysfunc(constant(EXACTINT));
2559 %end;
2560
2561 /*Ensure a format is assigned to an id variable*/
2562 %if %length(&id.) gt 0 %then %do;
2563 proc sql noprint;
2564 select type,length,%sysfunc(strip(format))
2565 into :tr_macro_type, :tr_macro_len, :tr_macro_format
2566 from dictionary.columns
2567 where libname="%sysfunc(upcase(&libname_in.))" and
2568 memname="%sysfunc(upcase(&data.))" and
2569 upcase(name)="%sysfunc(upcase(&id.))"
2570 ;
2571 quit;
2572
2573 %if %length(&format.) eq 0 %then %do;
2574 %let optsave=%sysfunc(getoption(missing),$quote.);
2575 options missing=.;
2576 %if %length(&tr_macro_format.) gt 0 %then %do;
2577 %let format=&tr_macro_format.;
2578 %end;
2579 %else %if "&tr_macro_type." eq "num " %then %do;
2580 %let format=%sysfunc(catt(best,&tr_macro_len.,%str(.)));
2581 %end;
2582 %else %do;
2583 %let format=%sysfunc(catt($,&tr_macro_len.,%str(.)));
2584 %end;
2585 options missing=&optsave;
2586 %end;
2587 %end;
2588
2589 /*Create macro variables containing ordered lists of the requested transposed variable
2590 names for character (varlist_char) and numeric (varlist_num) var variables */
2591 %if %length(&preloadfmt.) gt 0 %then %do;
2592 %if %sysfunc(countw(&preloadfmt.)) eq 1 %then %do;
2593 %let preloadfmt=&libname_in..&preloadfmt.;
2594 %end;
2595 %end;
2596 %else %do;
2597 %if %sysfunc(upcase("&sort.")) eq "YES" %then
2598 %let dsoptions=;
2599 proc freq data=&libname_in..&data. (obs=&guessingrows. keep=&id. &dsoptions.)
2600 noprint;
2601 tables &id./out=_for_format (keep=&id.);
2602 run;
2603 %if %sysfunc(upcase("&descendingid.")) eq "YES" %then %do;
2604 proc sort data=_for_format;
2605 by descending &id;
2606 run;
2607 %end;
2608 data _for_format;
2609 set _for_format;
2610 order=_n_;
2611 run;
2612 %end;
2613
2614 proc sql noprint;
2615 %do i=1 %to 2;
2616 %if &i. eq 1 %then %let i_type=char;
2617 %else %let i_type=num;
2618 %if %length(&&vars_&i_type.) gt 0 %then %do;
2619 select distinct
2620 %do j=1 %to 2;
2621 %if &j. eq 1 %then %let j_type=;
2622 %else %let j_type=format;
2623 %do k=1 %to %sysfunc(countw(&&vars_&i_type.));
2624 "&j_type. "||cats("&prefix.",
2625 %if %sysfunc(upcase("&var_first.")) eq "NO" %then %do;
2626 put(&id.,&format),"&delimiter."
2627 %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
2628 ,scan("&&vars_&i_type.",&k.);
2629 %end;
2630 %else %do;
2631 %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
2632 scan("&&vars_&i_type.",&k.),;
2633 "&delimiter.",put(&id.,&format)
2634 %end;
2635 )
2636 %if &j. eq 2 %then
2637 ||" "||cats(scan("&&formats_&i_type.",&k.,"~"),";");
2638 %if &k. lt %sysfunc(countw(&&vars_&i_type.)) %then ||;
2639 %else ,;
2640 %end;
2641 %end;
2642 %if "&tr_macro_type." eq "num " %then &id. format=best12.;
2643 %else &id.;
2644 ,order
2645 into :varlist_&i_type. separated by " ",
2646 :format_&i_type. separated by " ",
2647 :idlist separated by " ",
2648 :idorder separated by " "
2649 %if %length(&preloadfmt.) gt 0 %then from &preloadfmt.;
2650 %else from _for_format;
2651 order by order
2652 ;
2653 %let num_numlabels=&sqlobs.;
2654 %end;
2655 %end;
2656 quit;
2657
2658 proc sql noprint;
2659 select distinct
2660 %let j_type=;
2661 %do k=1 %to %sysfunc(countw(&&vars_all.));
2662 "&j_type. "||cats("&prefix.",
2663
2664 %if %sysfunc(upcase("&var_first.")) eq "NO" %then %do;
2665 put(&id.,&format),"&delimiter.",
2666 %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
2667 scan("&&vars_all.",&k.);
2668 )
2669 %end;
2670 %else %do;
2671 %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
2672 scan("&&vars_all.",&k.),;
2673 "&delimiter.",put(&id.,&format))
2674 %end;
2675 %if &k. lt %sysfunc(countw(&&vars_all.)) %then ||;
2676 %else ,;
2677 %end;
2678 order
2679 into :varlist_all separated by " ",
2680 :idorder separated by " "
2681 %if %length(&preloadfmt.) gt 0 %then from &preloadfmt.;
2682 %else from _for_format;
2683 order by order
2684 ;
2685 quit;
2686
2687 /*Create a format that will be used to assign values to the transposed variables*/
2688 data _for_format;
2689 %if %length(&preloadfmt.) gt 0 %then set &preloadfmt. (rename=(&id.=start));
2690 %else set _for_format (rename=(&id.=start));
2691 ;
2692 %if "&tr_macro_type." eq "num " %then retain fmtname "labelfmt" type "N";
2693 %else retain fmtname "$labelfmt" type "C";
2694 ;
2695 label=
2696 %if %length(&preloadfmt.) eq 0 %then _n_-1;
2697 %else order-1;
2698 ;
2699 run;
2700
2701 proc format cntlin = _for_format;
2702 run ;
2703
2704 /*Create and run the datastep that does the transposition*/
2705 data &libname_out..&out.;
2706 set &libname_in..&data. (keep=&by. &id.
2707 %do i=1 %to %sysfunc(countw("&vars_char."));
2708 %scan(&vars_char.,&i.)
2709 %end;
2710 %do i=1 %to %sysfunc(countw("&vars_num."));
2711 %scan(&vars_num.,&i.)
2712 %end;
2713 %do i=1 %to %sysfunc(countw("&to_copy."));
2714 %scan(&to_copy.,&i.)
2715 %end;
2716 &dsoptions.
2717 );
2718 by &by. &notsorted.;
2719 &format_char. &format_num.
2720 %if %length(&vars_char.) gt 0 %then %do;
2721 array want_char(*) $
2722 %do i=1 %to %eval(&num_numlabels.*%sysfunc(countw("&vars_char.")));
2723 %scan(&varlist_char.,&i.)
2724 %end;
2725 ;
2726 array have_char(*) $ &vars_char.;
2727 retain want_char;
2728 if first.&lastby. then call missing(of want_char(*));
2729 ___nchar=put(&id.,labelfmt.)*dim(have_char);
2730 do ___i=1 to dim(have_char);
2731 want_char(___nchar+___i)=have_char(___i);
2732 end;
2733 %end;
2734 %if %length(&vars_num.) gt 0 %then %do;
2735 array want_num(*)
2736 %do i=1 %to %eval(&num_numlabels.*%sysfunc(countw("&vars_num.")));
2737 %scan(&varlist_num.,&i.)
2738 %end;
2739 ;
2740 array have_num(*) &vars_num.;
2741 retain want_num;
2742 if first.&lastby. then call missing(of want_num(*));
2743 ___nnum=put(&id.,labelfmt.)*dim(have_num);
2744 do ___i=1 to dim(have_num);
2745 want_num(___nnum+___i)=have_num(___i);
2746 end;
2747 %end;
2748 drop &id. ___: &var. &drop.;
2749 if last.&lastby. then output;
2750 run;
2751
2752 data &libname_out..&out.;
2753 retain &by. &to_copy. &varlist_all.;
2754 set &libname_out..&out.;
2755 run;
2756
2757 /*Delete all temporary files*/
2758 proc delete data=work.t_e_m_p work._for_format;
2759 run;
2760
2761 %mend transpose;
2762 options NOQUOTELENMAX;
2763 proc sort data=have out=need nodupkey;
2764 by time_m sym_root;
2765 run;

NOTE: There were 179219 observations read from the data set WORK.HAVE.
NOTE: 13934 observations with duplicate key values were deleted.
NOTE: The data set WORK.NEED has 165285 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.08 seconds
cpu time 0.21 seconds

2766
2767 %transpose(data=need, out=want, by=time_m, id=sym_root,
2768 delimiter=_,var=price size)

NOTE: There were 1 observations read from the data set WORK.NEED.
NOTE: The data set WORK.T_E_M_P has 1 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.03 seconds

NOTE: No rows were selected.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

NOTE: There were 165285 observations read from the data set WORK.NEED.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 1 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.05 seconds
cpu time 0.04 seconds

NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.04 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

ERROR: These two ranges overlap: LOW-LOW and A-A (fuzz=0).

WARNING: RUN statement ignored due to previous errors. Submit QUIT; to terminate the procedure.
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.

NOTE: Line generated by the invoked macro "TRANSPOSE".
1997 ; array have_num(*) &vars_num.; retain want_num; if first.&lastby. then
1997! call missing(of want_num(*)); ___nnum=put(&id.,labelfmt.)*dim(have_num); do
---------
48
1997! ___i=1 to dim(have_num); want_num(___nnum+___i)=have_num(___i); end;

ERROR 48-59: The format $LABELFMT was not found or could not be loaded.

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
1997:132
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.WANT may be incomplete. When this step was stopped there were 0
observations and 943 variables.
WARNING: Data set WORK.WANT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.70 seconds
cpu time 0.70 seconds

NOTE: Variable time_m is uninitialized.
NOTE: Variable SIZE_A is uninitialized.
NOTE: Variable PRICE_A is uninitialized.
NOTE: Variable SIZE_AA is uninitialized.
NOTE: Variable PRICE_AA is uninitialized.
NOTE: Variable SIZE_AAPL is uninitialized.
NOTE: Variable PRICE_AAPL is uninitialized.
NOTE: Variable SIZE_ABC is uninitialized.
NOTE: Variable PRICE_ABC is uninitialized.
NOTE: Variable SIZE_ABT is uninitialized.
NOTE: Variable PRICE_ABT is uninitialized.
NOTE: Variable SIZE_ADBE is uninitialized.
NOTE: Variable PRICE_ADBE is uninitialized.
NOTE: Variable SIZE_ADI is uninitialized.
NOTE: Variable PRICE_ADI is uninitialized.
NOTE: Variable SIZE_ADM is uninitialized.
NOTE: Variable PRICE_ADM is uninitialized.
NOTE: Variable SIZE_ADP is uninitialized.
NOTE: Variable PRICE_ADP is uninitialized.
NOTE: Variable SIZE_ADSK is uninitialized.
NOTE: Variable PRICE_ADSK is uninitialized.
NOTE: Variable SIZE_AEE is uninitialized.
NOTE: Variable PRICE_AEE is uninitialized.
NOTE: Variable SIZE_AEP is uninitialized.
NOTE: Variable PRICE_AEP is uninitialized.
NOTE: Variable SIZE_AES is uninitialized.
NOTE: Variable PRICE_AES is uninitialized.
NOTE: Variable SIZE_AET is uninitialized.
NOTE: Variable PRICE_AET is uninitialized.
NOTE: Variable SIZE_AFL is uninitialized.
NOTE: Variable PRICE_AFL is uninitialized.
NOTE: Variable SIZE_AGN is uninitialized.
NOTE: Variable PRICE_AGN is uninitialized.
NOTE: Variable SIZE_AIG is uninitialized.
NOTE: Variable PRICE_AIG is uninitialized.
NOTE: Variable SIZE_AIV is uninitialized.
NOTE: Variable PRICE_AIV is uninitialized.
NOTE: Variable SIZE_AIZ is uninitialized.
NOTE: Variable PRICE_AIZ is uninitialized.
NOTE: Variable SIZE_AKAM is uninitialized.
NOTE: Variable PRICE_AKAM is uninitialized.
NOTE: Variable SIZE_AKS is uninitialized.
NOTE: Variable PRICE_AKS is uninitialized.
NOTE: Variable SIZE_ALL is uninitialized.
NOTE: Variable PRICE_ALL is uninitialized.
NOTE: Variable SIZE_ALTR is uninitialized.
NOTE: Variable PRICE_ALTR is uninitialized.
NOTE: Variable SIZE_AMAT is uninitialized.
NOTE: Variable PRICE_AMAT is uninitialized.
NOTE: Variable SIZE_AMD is uninitialized.
NOTE: Variable PRICE_AMD is uninitialized.
NOTE: Variable SIZE_AMGN is uninitialized.
NOTE: Variable PRICE_AMGN is uninitialized.
NOTE: Variable SIZE_AMP is uninitialized.
NOTE: Variable PRICE_AMP is uninitialized.
NOTE: Variable SIZE_AMT is uninitialized.
NOTE: Variable PRICE_AMT is uninitialized.
NOTE: Variable SIZE_AMZN is uninitialized.
NOTE: Variable PRICE_AMZN is uninitialized.
NOTE: Variable SIZE_AN is uninitialized.
NOTE: Variable PRICE_AN is uninitialized.
NOTE: Variable SIZE_ANF is uninitialized.
NOTE: Variable PRICE_ANF is uninitialized.
NOTE: Variable SIZE_AON is uninitialized.
NOTE: Variable PRICE_AON is uninitialized.
NOTE: Variable SIZE_APA is uninitialized.
NOTE: Variable PRICE_APA is uninitialized.
NOTE: Variable SIZE_APC is uninitialized.
NOTE: Variable PRICE_APC is uninitialized.
NOTE: Variable SIZE_APD is uninitialized.
NOTE: Variable PRICE_APD is uninitialized.
NOTE: Variable SIZE_APH is uninitialized.
NOTE: Variable PRICE_APH is uninitialized.
NOTE: Variable SIZE_APOL is uninitialized.
NOTE: Variable PRICE_APOL is uninitialized.
NOTE: Variable SIZE_ARG is uninitialized.
NOTE: Variable PRICE_ARG is uninitialized.
NOTE: Variable SIZE_ATI is uninitialized.
NOTE: Variable PRICE_ATI is uninitialized.
NOTE: Variable SIZE_AVB is uninitialized.
NOTE: Variable PRICE_AVB is uninitialized.
NOTE: Variable SIZE_AVP is uninitialized.
NOTE: Variable PRICE_AVP is uninitialized.
NOTE: Variable SIZE_AVY is uninitialized.
NOTE: Variable PRICE_AVY is uninitialized.
NOTE: Variable SIZE_AXP is uninitialized.
NOTE: Variable PRICE_AXP is uninitialized.
NOTE: Variable SIZE_AYE is uninitialized.
NOTE: Variable PRICE_AYE is uninitialized.
NOTE: Variable SIZE_AZO is uninitialized.
NOTE: Variable PRICE_AZO is uninitialized.
NOTE: Variable SIZE_BA is uninitialized.
NOTE: Variable PRICE_BA is uninitialized.
NOTE: Variable SIZE_BAC is uninitialized.
NOTE: Variable PRICE_BAC is uninitialized.
NOTE: Variable SIZE_BAX is uninitialized.
NOTE: Variable PRICE_BAX is uninitialized.
NOTE: Variable SIZE_BBBY is uninitialized.
NOTE: Variable PRICE_BBBY is uninitialized.
NOTE: Variable SIZE_BBT is uninitialized.
NOTE: Variable PRICE_BBT is uninitialized.
NOTE: Variable SIZE_BBY is uninitialized.
NOTE: Variable PRICE_BBY is uninitialized.
NOTE: Variable SIZE_BCR is uninitialized.
NOTE: Variable PRICE_BCR is uninitialized.
NOTE: Variable SIZE_BDX is uninitialized.
NOTE: Variable PRICE_BDX is uninitialized.
NOTE: Variable SIZE_BEN is uninitialized.
NOTE: Variable PRICE_BEN is uninitialized.
NOTE: Variable SIZE_BHI is uninitialized.
NOTE: Variable PRICE_BHI is uninitialized.
NOTE: Variable SIZE_BIG is uninitialized.
NOTE: Variable PRICE_BIG is uninitialized.
NOTE: Variable SIZE_BIIB is uninitialized.
NOTE: Variable PRICE_BIIB is uninitialized.
NOTE: Variable SIZE_BK is uninitialized.
NOTE: Variable PRICE_BK is uninitialized.
NOTE: Variable SIZE_BLL is uninitialized.
NOTE: Variable PRICE_BLL is uninitialized.
NOTE: Variable SIZE_BMC is uninitialized.
NOTE: Variable PRICE_BMC is uninitialized.
NOTE: Variable SIZE_BMS is uninitialized.
NOTE: Variable PRICE_BMS is uninitialized.
NOTE: Variable SIZE_BMY is uninitialized.
NOTE: Variable PRICE_BMY is uninitialized.
NOTE: Variable SIZE_BRCM is uninitialized.
NOTE: Variable PRICE_BRCM is uninitialized.
NOTE: Variable SIZE_BSX is uninitialized.
NOTE: Variable PRICE_BSX is uninitialized.
NOTE: Variable SIZE_BTU is uninitialized.
NOTE: Variable PRICE_BTU is uninitialized.
NOTE: Variable SIZE_BXP is uninitialized.
NOTE: Variable PRICE_BXP is uninitialized.
NOTE: Variable SIZE_C is uninitialized.
NOTE: Variable PRICE_C is uninitialized.
NOTE: Variable SIZE_CA is uninitialized.
NOTE: Variable PRICE_CA is uninitialized.
NOTE: Variable SIZE_CAG is uninitialized.
NOTE: Variable PRICE_CAG is uninitialized.
NOTE: Variable SIZE_CAH is uninitialized.
NOTE: Variable PRICE_CAH is uninitialized.
NOTE: Variable SIZE_CAM is uninitialized.
NOTE: Variable PRICE_CAM is uninitialized.
NOTE: Variable SIZE_CAT is uninitialized.
NOTE: Variable PRICE_CAT is uninitialized.
NOTE: Variable SIZE_CB is uninitialized.
NOTE: Variable PRICE_CB is uninitialized.
NOTE: Variable SIZE_CBG is uninitialized.
NOTE: Variable PRICE_CBG is uninitialized.
NOTE: Variable SIZE_CBS is uninitialized.
NOTE: Variable PRICE_CBS is uninitialized.
NOTE: Variable SIZE_CCE is uninitialized.
NOTE: Variable PRICE_CCE is uninitialized.
NOTE: Variable SIZE_CCL is uninitialized.
NOTE: Variable PRICE_CCL is uninitialized.
NOTE: Variable SIZE_CEG is uninitialized.
NOTE: Variable PRICE_CEG is uninitialized.
NOTE: Variable SIZE_CELG is uninitialized.
NOTE: Variable PRICE_CELG is uninitialized.
NOTE: Variable SIZE_CEPH is uninitialized.
NOTE: Variable PRICE_CEPH is uninitialized.
NOTE: Variable SIZE_CF is uninitialized.
NOTE: Variable PRICE_CF is uninitialized.
NOTE: Variable SIZE_CFN is uninitialized.
NOTE: Variable PRICE_CFN is uninitialized.
NOTE: Variable SIZE_CHK is uninitialized.
NOTE: Variable PRICE_CHK is uninitialized.
NOTE: Variable SIZE_CHRW is uninitialized.
NOTE: Variable PRICE_CHRW is uninitialized.
NOTE: Variable SIZE_CI is uninitialized.
NOTE: Variable PRICE_CI is uninitialized.
NOTE: Variable SIZE_CINF is uninitialized.
NOTE: Variable PRICE_CINF is uninitialized.
NOTE: Variable SIZE_CL is uninitialized.
NOTE: Variable PRICE_CL is uninitialized.
NOTE: Variable SIZE_CLF is uninitialized.
NOTE: Variable PRICE_CLF is uninitialized.
NOTE: Variable SIZE_CLX is uninitialized.
NOTE: Variable PRICE_CLX is uninitialized.
NOTE: Variable SIZE_CMA is uninitialized.
NOTE: Variable PRICE_CMA is uninitialized.
NOTE: Variable SIZE_CME is uninitialized.
NOTE: Variable PRICE_CME is uninitialized.
NOTE: Variable SIZE_CMI is uninitialized.
NOTE: Variable PRICE_CMI is uninitialized.
NOTE: Variable SIZE_CMS is uninitialized.
NOTE: Variable PRICE_CMS is uninitialized.
NOTE: Variable SIZE_CNP is uninitialized.
NOTE: Variable PRICE_CNP is uninitialized.
NOTE: Variable SIZE_CNX is uninitialized.
NOTE: Variable PRICE_CNX is uninitialized.
NOTE: Variable SIZE_COF is uninitialized.
NOTE: Variable PRICE_COF is uninitialized.
NOTE: Variable SIZE_COG is uninitialized.
NOTE: Variable PRICE_COG is uninitialized.
NOTE: Variable SIZE_COH is uninitialized.
NOTE: Variable PRICE_COH is uninitialized.
NOTE: Variable SIZE_COL is uninitialized.
NOTE: Variable PRICE_COL is uninitialized.
NOTE: Variable SIZE_COP is uninitialized.
NOTE: Variable PRICE_COP is uninitialized.
NOTE: Variable SIZE_COST is uninitialized.
NOTE: Variable PRICE_COST is uninitialized.
NOTE: Variable SIZE_CPB is uninitialized.
NOTE: Variable PRICE_CPB is uninitialized.
NOTE: Variable SIZE_CPWR is uninitialized.
NOTE: Variable PRICE_CPWR is uninitialized.
NOTE: Variable SIZE_CRM is uninitialized.
NOTE: Variable PRICE_CRM is uninitialized.
NOTE: Variable SIZE_CSC is uninitialized.
NOTE: Variable PRICE_CSC is uninitialized.
NOTE: Variable SIZE_CSCO is uninitialized.
NOTE: Variable PRICE_CSCO is uninitialized.
NOTE: Variable SIZE_CSX is uninitialized.
NOTE: Variable PRICE_CSX is uninitialized.
NOTE: Variable SIZE_CTAS is uninitialized.
NOTE: Variable PRICE_CTAS is uninitialized.
NOTE: Variable SIZE_CTL is uninitialized.
NOTE: Variable PRICE_CTL is uninitialized.
NOTE: Variable SIZE_CTSH is uninitialized.
NOTE: Variable PRICE_CTSH is uninitialized.
NOTE: Variable SIZE_CTXS is uninitialized.
NOTE: Variable PRICE_CTXS is uninitialized.
NOTE: Variable SIZE_CVH is uninitialized.
NOTE: Variable PRICE_CVH is uninitialized.
NOTE: Variable SIZE_CVS is uninitialized.
NOTE: Variable PRICE_CVS is uninitialized.
NOTE: Variable SIZE_CVX is uninitialized.
NOTE: Variable PRICE_CVX is uninitialized.
NOTE: Variable SIZE_D is uninitialized.
NOTE: Variable PRICE_D is uninitialized.
NOTE: Variable SIZE_DD is uninitialized.
NOTE: Variable PRICE_DD is uninitialized.
NOTE: Variable SIZE_DE is uninitialized.
NOTE: Variable PRICE_DE is uninitialized.
NOTE: Variable SIZE_DELL is uninitialized.
NOTE: Variable PRICE_DELL is uninitialized.
NOTE: Variable SIZE_DF is uninitialized.
NOTE: Variable PRICE_DF is uninitialized.
NOTE: Variable SIZE_DFS is uninitialized.
NOTE: Variable PRICE_DFS is uninitialized.
NOTE: Variable SIZE_DGX is uninitialized.
NOTE: Variable PRICE_DGX is uninitialized.
NOTE: Variable SIZE_DHI is uninitialized.
NOTE: Variable PRICE_DHI is uninitialized.
NOTE: Variable SIZE_DHR is uninitialized.
NOTE: Variable PRICE_DHR is uninitialized.
NOTE: Variable SIZE_DIS is uninitialized.
NOTE: Variable PRICE_DIS is uninitialized.
NOTE: Variable SIZE_DNB is uninitialized.
NOTE: Variable PRICE_DNB is uninitialized.
NOTE: Variable SIZE_DNR is uninitialized.
NOTE: Variable PRICE_DNR is uninitialized.
NOTE: Variable SIZE_DO is uninitialized.
NOTE: Variable PRICE_DO is uninitialized.
NOTE: Variable SIZE_DOV is uninitialized.
NOTE: Variable PRICE_DOV is uninitialized.
NOTE: Variable SIZE_DOW is uninitialized.
NOTE: Variable PRICE_DOW is uninitialized.
NOTE: Variable SIZE_DPS is uninitialized.
NOTE: Variable PRICE_DPS is uninitialized.
NOTE: Variable SIZE_DRI is uninitialized.
NOTE: Variable PRICE_DRI is uninitialized.
NOTE: Variable SIZE_DTE is uninitialized.
NOTE: Variable PRICE_DTE is uninitialized.
NOTE: Variable SIZE_DTV is uninitialized.
NOTE: Variable PRICE_DTV is uninitialized.
NOTE: Variable SIZE_DUK is uninitialized.
NOTE: Variable PRICE_DUK is uninitialized.
NOTE: Variable SIZE_DV is uninitialized.
NOTE: Variable PRICE_DV is uninitialized.
NOTE: Variable SIZE_DVA is uninitialized.
NOTE: Variable PRICE_DVA is uninitialized.
NOTE: Variable SIZE_DVN is uninitialized.
NOTE: Variable PRICE_DVN is uninitialized.
NOTE: Variable SIZE_EBAY is uninitialized.
NOTE: Variable PRICE_EBAY is uninitialized.
NOTE: Variable SIZE_ECL is uninitialized.
NOTE: Variable PRICE_ECL is uninitialized.
NOTE: Variable SIZE_ED is uninitialized.
NOTE: Variable PRICE_ED is uninitialized.
NOTE: Variable SIZE_EFX is uninitialized.
NOTE: Variable PRICE_EFX is uninitialized.
NOTE: Variable SIZE_EIX is uninitialized.
NOTE: Variable PRICE_EIX is uninitialized.
NOTE: Variable SIZE_EL is uninitialized.
NOTE: Variable PRICE_EL is uninitialized.
NOTE: Variable SIZE_EMC is uninitialized.
NOTE: Variable PRICE_EMC is uninitialized.
NOTE: Variable SIZE_EMN is uninitialized.
NOTE: Variable PRICE_EMN is uninitialized.
NOTE: Variable SIZE_EMR is uninitialized.
NOTE: Variable PRICE_EMR is uninitialized.
NOTE: Variable SIZE_EOG is uninitialized.
NOTE: Variable PRICE_EOG is uninitialized.
NOTE: Variable SIZE_EP is uninitialized.
NOTE: Variable PRICE_EP is uninitialized.
NOTE: Variable SIZE_EQR is uninitialized.
NOTE: Variable PRICE_EQR is uninitialized.
NOTE: Variable SIZE_EQT is uninitialized.
NOTE: Variable PRICE_EQT is uninitialized.
NOTE: Variable SIZE_ES is uninitialized.
NOTE: Variable PRICE_ES is uninitialized.
NOTE: Variable SIZE_ESRX is uninitialized.
NOTE: Variable PRICE_ESRX is uninitialized.
NOTE: Variable SIZE_ETFC is uninitialized.
NOTE: Variable PRICE_ETFC is uninitialized.
NOTE: Variable SIZE_ETN is uninitialized.
NOTE: Variable PRICE_ETN is uninitialized.
NOTE: Variable SIZE_ETR is uninitialized.
NOTE: Variable PRICE_ETR is uninitialized.
NOTE: Variable SIZE_EXC is uninitialized.
NOTE: Variable PRICE_EXC is uninitialized.
NOTE: Variable SIZE_EXPD is uninitialized.
NOTE: Variable PRICE_EXPD is uninitialized.
NOTE: Variable SIZE_EXPE is uninitialized.
NOTE: Variable PRICE_EXPE is uninitialized.
NOTE: Variable SIZE_F is uninitialized.
NOTE: Variable PRICE_F is uninitialized.
NOTE: Variable SIZE_FAST is uninitialized.
NOTE: Variable PRICE_FAST is uninitialized.
NOTE: Variable SIZE_FCX is uninitialized.
NOTE: Variable PRICE_FCX is uninitialized.
NOTE: Variable SIZE_FDO is uninitialized.
NOTE: Variable PRICE_FDO is uninitialized.
NOTE: Variable SIZE_FDX is uninitialized.
NOTE: Variable PRICE_FDX is uninitialized.
NOTE: Variable SIZE_FE is uninitialized.
NOTE: Variable PRICE_FE is uninitialized.
NOTE: Variable SIZE_FHN is uninitialized.
NOTE: Variable PRICE_FHN is uninitialized.
NOTE: Variable SIZE_FII is uninitialized.
NOTE: Variable PRICE_FII is uninitialized.
NOTE: Variable SIZE_FIS is uninitialized.
NOTE: Variable PRICE_FIS is uninitialized.
NOTE: Variable SIZE_FISV is uninitialized.
NOTE: Variable PRICE_FISV is uninitialized.
NOTE: Variable SIZE_FITB is uninitialized.
NOTE: Variable PRICE_FITB is uninitialized.
NOTE: Variable SIZE_FLIR is uninitialized.
NOTE: Variable PRICE_FLIR is uninitialized.
NOTE: Variable SIZE_FLR is uninitialized.
NOTE: Variable PRICE_FLR is uninitialized.
NOTE: Variable SIZE_FLS is uninitialized.
NOTE: Variable PRICE_FLS is uninitialized.
NOTE: Variable SIZE_FMC is uninitialized.
NOTE: Variable PRICE_FMC is uninitialized.
NOTE: Variable SIZE_FRX is uninitialized.
NOTE: Variable PRICE_FRX is uninitialized.
NOTE: Variable SIZE_FSLR is uninitialized.
NOTE: Variable PRICE_FSLR is uninitialized.
NOTE: Variable SIZE_FTI is uninitialized.
NOTE: Variable PRICE_FTI is uninitialized.
NOTE: Variable SIZE_FTR is uninitialized.
NOTE: Variable PRICE_FTR is uninitialized.
NOTE: Variable SIZE_GAS is uninitialized.
NOTE: Variable PRICE_GAS is uninitialized.
NOTE: Variable SIZE_GD is uninitialized.
NOTE: Variable PRICE_GD is uninitialized.
NOTE: Variable SIZE_GE is uninitialized.
NOTE: Variable PRICE_GE is uninitialized.
NOTE: Variable SIZE_GENZ is uninitialized.
NOTE: Variable PRICE_GENZ is uninitialized.
NOTE: Variable SIZE_GILD is uninitialized.
NOTE: Variable PRICE_GILD is uninitialized.
NOTE: Variable SIZE_GIS is uninitialized.
NOTE: Variable PRICE_GIS is uninitialized.
NOTE: Variable SIZE_GLW is uninitialized.
NOTE: Variable PRICE_GLW is uninitialized.
NOTE: Variable SIZE_GME is uninitialized.
NOTE: Variable PRICE_GME is uninitialized.
NOTE: Variable SIZE_GNW is uninitialized.
NOTE: Variable PRICE_GNW is uninitialized.
NOTE: Variable SIZE_GPC is uninitialized.
NOTE: Variable PRICE_GPC is uninitialized.
NOTE: Variable SIZE_GPS is uninitialized.
NOTE: Variable PRICE_GPS is uninitialized.
NOTE: Variable SIZE_GR is uninitialized.
NOTE: Variable PRICE_GR is uninitialized.
NOTE: Variable SIZE_GS is uninitialized.
NOTE: Variable PRICE_GS is uninitialized.
NOTE: Variable SIZE_GT is uninitialized.
NOTE: Variable PRICE_GT is uninitialized.
NOTE: Variable SIZE_GWW is uninitialized.
NOTE: Variable PRICE_GWW is uninitialized.
NOTE: Variable SIZE_HAL is uninitialized.
NOTE: Variable PRICE_HAL is uninitialized.
NOTE: Variable SIZE_HAR is uninitialized.
NOTE: Variable PRICE_HAR is uninitialized.
NOTE: Variable SIZE_HAS is uninitialized.
NOTE: Variable PRICE_HAS is uninitialized.
NOTE: Variable SIZE_HBAN is uninitialized.
NOTE: Variable PRICE_HBAN is uninitialized.
NOTE: Variable SIZE_HCBK is uninitialized.
NOTE: Variable PRICE_HCBK is uninitialized.
NOTE: Variable SIZE_HCN is uninitialized.
NOTE: Variable PRICE_HCN is uninitialized.
NOTE: Variable SIZE_HCP is uninitialized.
NOTE: Variable PRICE_HCP is uninitialized.
NOTE: Variable SIZE_HD is uninitialized.
NOTE: Variable PRICE_HD is uninitialized.
NOTE: Variable SIZE_HES is uninitialized.
NOTE: Variable PRICE_HES is uninitialized.
NOTE: Variable SIZE_HIG is uninitialized.
NOTE: Variable PRICE_HIG is uninitialized.
NOTE: Variable SIZE_HOG is uninitialized.
NOTE: Variable PRICE_HOG is uninitialized.
NOTE: Variable SIZE_HON is uninitialized.
NOTE: Variable PRICE_HON is uninitialized.
NOTE: Variable SIZE_HOT is uninitialized.
NOTE: Variable PRICE_HOT is uninitialized.
NOTE: Variable SIZE_HP is uninitialized.
NOTE: Variable PRICE_HP is uninitialized.
NOTE: Variable SIZE_HPQ is uninitialized.
NOTE: Variable PRICE_HPQ is uninitialized.
NOTE: Variable SIZE_HRB is uninitialized.
NOTE: Variable PRICE_HRB is uninitialized.
NOTE: Variable SIZE_HRL is uninitialized.
NOTE: Variable PRICE_HRL is uninitialized.
NOTE: Variable SIZE_HRS is uninitialized.
NOTE: Variable PRICE_HRS is uninitialized.
NOTE: Variable SIZE_HS is uninitialized.
NOTE: Variable PRICE_HS is uninitialized.
NOTE: Variable SIZE_HSP is uninitialized.
NOTE: Variable PRICE_HSP is uninitialized.
NOTE: Variable SIZE_HST is uninitialized.
NOTE: Variable PRICE_HST is uninitialized.
NOTE: Variable SIZE_HUM is uninitialized.
NOTE: Variable PRICE_HUM is uninitialized.
NOTE: Variable SIZE_IBM is uninitialized.
NOTE: Variable PRICE_IBM is uninitialized.
NOTE: Variable SIZE_ICE is uninitialized.
NOTE: Variable PRICE_ICE is uninitialized.
NOTE: Variable SIZE_IFF is uninitialized.
NOTE: Variable PRICE_IFF is uninitialized.
NOTE: Variable SIZE_IGT is uninitialized.
NOTE: Variable PRICE_IGT is uninitialized.
NOTE: Variable SIZE_IMS is uninitialized.
NOTE: Variable PRICE_IMS is uninitialized.
NOTE: Variable SIZE_INTC is uninitialized.
NOTE: Variable PRICE_INTC is uninitialized.
NOTE: Variable SIZE_INTU is uninitialized.
NOTE: Variable PRICE_INTU is uninitialized.
NOTE: Variable SIZE_IP is uninitialized.
NOTE: Variable PRICE_IP is uninitialized.
NOTE: Variable SIZE_IPG is uninitialized.
NOTE: Variable PRICE_IPG is uninitialized.
NOTE: Variable SIZE_IRM is uninitialized.
NOTE: Variable PRICE_IRM is uninitialized.
NOTE: Variable SIZE_ISRG is uninitialized.
NOTE: Variable PRICE_ISRG is uninitialized.
NOTE: Variable SIZE_ITT is uninitialized.
NOTE: Variable PRICE_ITT is uninitialized.
NOTE: Variable SIZE_ITW is uninitialized.
NOTE: Variable PRICE_ITW is uninitialized.
NOTE: Variable SIZE_IVZ is uninitialized.
NOTE: Variable PRICE_IVZ is uninitialized.
NOTE: Variable SIZE_JBL is uninitialized.
NOTE: Variable PRICE_JBL is uninitialized.
NOTE: Variable SIZE_JCI is uninitialized.
NOTE: Variable PRICE_JCI is uninitialized.
NOTE: Variable SIZE_JCP is uninitialized.
NOTE: Variable PRICE_JCP is uninitialized.
NOTE: Variable SIZE_JEC is uninitialized.
NOTE: Variable PRICE_JEC is uninitialized.
NOTE: Variable SIZE_JNJ is uninitialized.
NOTE: Variable PRICE_JNJ is uninitialized.
NOTE: Variable SIZE_JNPR is uninitialized.
NOTE: Variable PRICE_JNPR is uninitialized.
NOTE: Variable SIZE_JNS is uninitialized.
NOTE: Variable PRICE_JNS is uninitialized.
NOTE: Variable SIZE_JPM is uninitialized.
NOTE: Variable PRICE_JPM is uninitialized.
NOTE: Variable SIZE_JWN is uninitialized.
NOTE: Variable PRICE_JWN is uninitialized.
NOTE: Variable SIZE_K is uninitialized.
NOTE: Variable PRICE_K is uninitialized.
NOTE: Variable SIZE_KEY is uninitialized.
NOTE: Variable PRICE_KEY is uninitialized.
NOTE: Variable SIZE_KG is uninitialized.
NOTE: Variable PRICE_KG is uninitialized.
NOTE: Variable SIZE_KIM is uninitialized.
NOTE: Variable PRICE_KIM is uninitialized.
NOTE: Variable SIZE_KLAC is uninitialized.
NOTE: Variable PRICE_KLAC is uninitialized.
NOTE: Variable SIZE_KMB is uninitialized.
NOTE: Variable PRICE_KMB is uninitialized.
NOTE: Variable SIZE_KO is uninitialized.
NOTE: Variable PRICE_KO is uninitialized.
NOTE: Variable SIZE_KR is uninitialized.
NOTE: Variable PRICE_KR is uninitialized.
NOTE: Variable SIZE_KSS is uninitialized.
NOTE: Variable PRICE_KSS is uninitialized.
NOTE: Variable SIZE_L is uninitialized.
NOTE: Variable PRICE_L is uninitialized.
NOTE: Variable SIZE_LB is uninitialized.
NOTE: Variable PRICE_LB is uninitialized.
NOTE: Variable SIZE_LEG is uninitialized.
NOTE: Variable PRICE_LEG is uninitialized.
NOTE: Variable SIZE_LEN is uninitialized.
NOTE: Variable PRICE_LEN is uninitialized.
NOTE: Variable SIZE_LH is uninitialized.
NOTE: Variable PRICE_LH is uninitialized.
NOTE: Variable SIZE_LIFE is uninitialized.
NOTE: Variable PRICE_LIFE is uninitialized.
NOTE: Variable SIZE_LLL is uninitialized.
NOTE: Variable PRICE_LLL is uninitialized.
NOTE: Variable SIZE_LLTC is uninitialized.
NOTE: Variable PRICE_LLTC is uninitialized.
NOTE: Variable SIZE_LLY is uninitialized.
NOTE: Variable PRICE_LLY is uninitialized.
NOTE: Variable SIZE_LM is uninitialized.
NOTE: Variable PRICE_LM is uninitialized.
NOTE: Variable SIZE_LMT is uninitialized.
NOTE: Variable PRICE_LMT is uninitialized.
NOTE: Variable SIZE_LNC is uninitialized.
NOTE: Variable PRICE_LNC is uninitialized.
NOTE: Variable SIZE_LO is uninitialized.
NOTE: Variable PRICE_LO is uninitialized.
NOTE: Variable SIZE_LOW is uninitialized.
NOTE: Variable PRICE_LOW is uninitialized.
NOTE: Variable SIZE_LSI is uninitialized.
NOTE: Variable PRICE_LSI is uninitialized.
NOTE: Variable SIZE_LUK is uninitialized.
NOTE: Variable PRICE_LUK is uninitialized.
NOTE: Variable SIZE_LUV is uninitialized.
NOTE: Variable PRICE_LUV is uninitialized.
NOTE: Variable SIZE_LXK is uninitialized.
NOTE: Variable PRICE_LXK is uninitialized.
NOTE: Variable SIZE_M is uninitialized.
NOTE: Variable PRICE_M is uninitialized.
NOTE: Variable SIZE_MA is uninitialized.
NOTE: Variable PRICE_MA is uninitialized.
NOTE: Variable SIZE_MAR is uninitialized.
NOTE: Variable PRICE_MAR is uninitialized.
NOTE: Variable SIZE_MAS is uninitialized.
NOTE: Variable PRICE_MAS is uninitialized.
NOTE: Variable SIZE_MAT is uninitialized.
NOTE: Variable PRICE_MAT is uninitialized.
NOTE: Variable SIZE_MCD is uninitialized.
NOTE: Variable PRICE_MCD is uninitialized.
NOTE: Variable SIZE_MCHP is uninitialized.
NOTE: Variable PRICE_MCHP is uninitialized.
NOTE: Variable SIZE_MCK is uninitialized.
NOTE: Variable PRICE_MCK is uninitialized.
NOTE: Variable SIZE_MCO is uninitialized.
NOTE: Variable PRICE_MCO is uninitialized.
NOTE: Variable SIZE_MDP is uninitialized.
NOTE: Variable PRICE_MDP is uninitialized.
NOTE: Variable SIZE_MDT is uninitialized.
NOTE: Variable PRICE_MDT is uninitialized.
NOTE: Variable SIZE_MEE is uninitialized.
NOTE: Variable PRICE_MEE is uninitialized.
NOTE: Variable SIZE_MET is uninitialized.
NOTE: Variable PRICE_MET is uninitialized.
NOTE: Variable SIZE_MFE is uninitialized.
NOTE: Variable PRICE_MFE is uninitialized.
NOTE: Variable SIZE_MHS is uninitialized.
NOTE: Variable PRICE_MHS is uninitialized.
NOTE: Variable SIZE_MI is uninitialized.
NOTE: Variable PRICE_MI is uninitialized.
NOTE: Variable SIZE_MIL is uninitialized.
NOTE: Variable PRICE_MIL is uninitialized.
NOTE: Variable SIZE_MJN is uninitialized.
NOTE: Variable PRICE_MJN is uninitialized.
NOTE: Variable SIZE_MKC is uninitialized.
NOTE: Variable PRICE_MKC is uninitialized.
NOTE: Variable SIZE_MMC is uninitialized.
NOTE: Variable PRICE_MMC is uninitialized.
NOTE: Variable SIZE_MMM is uninitialized.
NOTE: Variable PRICE_MMM is uninitialized.
NOTE: Variable SIZE_MO is uninitialized.
NOTE: Variable PRICE_MO is uninitialized.
NOTE: Variable SIZE_MOLX is uninitialized.
NOTE: Variable PRICE_MOLX is uninitialized.
NOTE: Variable SIZE_MON is uninitialized.
NOTE: Variable PRICE_MON is uninitialized.
NOTE: Variable SIZE_MRK is uninitialized.
NOTE: Variable PRICE_MRK is uninitialized.
NOTE: Variable SIZE_MRO is uninitialized.
NOTE: Variable PRICE_MRO is uninitialized.
NOTE: Variable SIZE_MS is uninitialized.
NOTE: Variable PRICE_MS is uninitialized.
NOTE: Variable SIZE_MSFT is uninitialized.
NOTE: Variable PRICE_MSFT is uninitialized.
NOTE: Variable SIZE_MTB is uninitialized.
NOTE: Variable PRICE_MTB is uninitialized.
NOTE: Variable SIZE_MU is uninitialized.
NOTE: Variable PRICE_MU is uninitialized.
NOTE: Variable SIZE_MUR is uninitialized.
NOTE: Variable PRICE_MUR is uninitialized.
NOTE: Variable SIZE_MWV is uninitialized.
NOTE: Variable PRICE_MWV is uninitialized.
NOTE: Variable SIZE_MWW is uninitialized.
NOTE: Variable PRICE_MWW is uninitialized.
NOTE: Variable SIZE_MYL is uninitialized.
NOTE: Variable PRICE_MYL is uninitialized.
NOTE: Variable SIZE_NAVI is uninitialized.
NOTE: Variable PRICE_NAVI is uninitialized.
NOTE: Variable SIZE_NBL is uninitialized.
NOTE: Variable PRICE_NBL is uninitialized.
NOTE: Variable SIZE_NBR is uninitialized.
NOTE: Variable PRICE_NBR is uninitialized.
NOTE: Variable SIZE_NDAQ is uninitialized.
NOTE: Variable PRICE_NDAQ is uninitialized.
NOTE: Variable SIZE_NEM is uninitialized.
NOTE: Variable PRICE_NEM is uninitialized.
NOTE: Variable SIZE_NI is uninitialized.
NOTE: Variable PRICE_NI is uninitialized.
NOTE: Variable SIZE_NKE is uninitialized.
NOTE: Variable PRICE_NKE is uninitialized.
NOTE: Variable SIZE_NOC is uninitialized.
NOTE: Variable PRICE_NOC is uninitialized.
NOTE: Variable SIZE_NOV is uninitialized.
NOTE: Variable PRICE_NOV is uninitialized.
NOTE: Variable SIZE_NOVL is uninitialized.
NOTE: Variable PRICE_NOVL is uninitialized.
NOTE: Variable SIZE_NRG is uninitialized.
NOTE: Variable PRICE_NRG is uninitialized.
NOTE: Variable SIZE_NSC is uninitialized.
NOTE: Variable PRICE_NSC is uninitialized.
NOTE: Variable SIZE_NSM is uninitialized.
NOTE: Variable PRICE_NSM is uninitialized.
NOTE: Variable SIZE_NTAP is uninitialized.
NOTE: Variable PRICE_NTAP is uninitialized.
NOTE: Variable SIZE_NTRS is uninitialized.
NOTE: Variable PRICE_NTRS is uninitialized.
NOTE: Variable SIZE_NUE is uninitialized.
NOTE: Variable PRICE_NUE is uninitialized.
NOTE: Variable SIZE_NVDA is uninitialized.
NOTE: Variable PRICE_NVDA is uninitialized.
NOTE: Variable SIZE_NVLS is uninitialized.
NOTE: Variable PRICE_NVLS is uninitialized.
NOTE: Variable SIZE_NWL is uninitialized.
NOTE: Variable PRICE_NWL is uninitialized.
NOTE: Variable SIZE_NYT is uninitialized.
NOTE: Variable PRICE_NYT is uninitialized.
NOTE: Variable SIZE_NYX is uninitialized.
NOTE: Variable PRICE_NYX is uninitialized.
NOTE: Variable SIZE_ODP is uninitialized.
NOTE: Variable PRICE_ODP is uninitialized.
NOTE: Variable SIZE_OI is uninitialized.
NOTE: Variable PRICE_OI is uninitialized.
NOTE: Variable SIZE_OKE is uninitialized.
NOTE: Variable PRICE_OKE is uninitialized.
NOTE: Variable SIZE_OMC is uninitialized.
NOTE: Variable PRICE_OMC is uninitialized.
NOTE: Variable SIZE_ORCL is uninitialized.
NOTE: Variable PRICE_ORCL is uninitialized.
NOTE: Variable SIZE_ORLY is uninitialized.
NOTE: Variable PRICE_ORLY is uninitialized.
NOTE: Variable SIZE_OXY is uninitialized.
NOTE: Variable PRICE_OXY is uninitialized.
NOTE: Variable SIZE_PAYX is uninitialized.
NOTE: Variable PRICE_PAYX is uninitialized.
NOTE: Variable SIZE_PBCT is uninitialized.
NOTE: Variable PRICE_PBCT is uninitialized.
NOTE: Variable SIZE_PBI is uninitialized.
NOTE: Variable PRICE_PBI is uninitialized.
NOTE: Variable SIZE_PCAR is uninitialized.
NOTE: Variable PRICE_PCAR is uninitialized.
NOTE: Variable SIZE_PCG is uninitialized.
NOTE: Variable PRICE_PCG is uninitialized.
NOTE: Variable SIZE_PCL is uninitialized.
NOTE: Variable PRICE_PCL is uninitialized.
NOTE: Variable SIZE_PCLN is uninitialized.
NOTE: Variable PRICE_PCLN is uninitialized.
NOTE: Variable SIZE_PCP is uninitialized.
NOTE: Variable PRICE_PCP is uninitialized.
NOTE: Variable SIZE_PCS is uninitialized.
NOTE: Variable PRICE_PCS is uninitialized.
NOTE: Variable SIZE_PDCO is uninitialized.
NOTE: Variable PRICE_PDCO is uninitialized.
NOTE: Variable SIZE_PEG is uninitialized.
NOTE: Variable PRICE_PEG is uninitialized.
NOTE: Variable SIZE_PEP is uninitialized.
NOTE: Variable PRICE_PEP is uninitialized.
NOTE: Variable SIZE_PFE is uninitialized.
NOTE: Variable PRICE_PFE is uninitialized.
NOTE: Variable SIZE_PFG is uninitialized.
NOTE: Variable PRICE_PFG is uninitialized.
NOTE: Variable SIZE_PG is uninitialized.
NOTE: Variable PRICE_PG is uninitialized.
NOTE: Variable SIZE_PGR is uninitialized.
NOTE: Variable PRICE_PGR is uninitialized.
NOTE: Variable SIZE_PH is uninitialized.
NOTE: Variable PRICE_PH is uninitialized.
NOTE: Variable SIZE_PHM is uninitialized.
NOTE: Variable PRICE_PHM is uninitialized.
NOTE: Variable SIZE_PKI is uninitialized.
NOTE: Variable PRICE_PKI is uninitialized.
NOTE: Variable SIZE_PLD is uninitialized.
NOTE: Variable PRICE_PLD is uninitialized.
NOTE: Variable SIZE_PLL is uninitialized.
NOTE: Variable PRICE_PLL is uninitialized.
NOTE: Variable SIZE_PM is uninitialized.
NOTE: Variable PRICE_PM is uninitialized.
NOTE: Variable SIZE_PNC is uninitialized.
NOTE: Variable PRICE_PNC is uninitialized.
NOTE: Variable SIZE_PNW is uninitialized.
NOTE: Variable PRICE_PNW is uninitialized.
NOTE: Variable SIZE_POM is uninitialized.
NOTE: Variable PRICE_POM is uninitialized.
NOTE: Variable SIZE_PPG is uninitialized.
NOTE: Variable PRICE_PPG is uninitialized.
NOTE: Variable SIZE_PPL is uninitialized.
NOTE: Variable PRICE_PPL is uninitialized.
NOTE: Variable SIZE_PRU is uninitialized.
NOTE: Variable PRICE_PRU is uninitialized.
NOTE: Variable SIZE_PSA is uninitialized.
NOTE: Variable PRICE_PSA is uninitialized.
NOTE: Variable SIZE_PTV is uninitialized.
NOTE: Variable PRICE_PTV is uninitialized.
NOTE: Variable SIZE_PWR is uninitialized.
NOTE: Variable PRICE_PWR is uninitialized.
NOTE: Variable SIZE_PX is uninitialized.
NOTE: Variable PRICE_PX is uninitialized.
NOTE: Variable SIZE_PXD is uninitialized.
NOTE: Variable PRICE_PXD is uninitialized.
NOTE: Variable SIZE_Q is uninitialized.
NOTE: Variable PRICE_Q is uninitialized.
NOTE: Variable SIZE_QCOM is uninitialized.
NOTE: Variable PRICE_QCOM is uninitialized.
NOTE: Variable SIZE_QLGC is uninitialized.
NOTE: Variable PRICE_QLGC is uninitialized.
NOTE: Variable SIZE_R is uninitialized.
NOTE: Variable PRICE_R is uninitialized.
NOTE: Variable SIZE_RAI is uninitialized.
NOTE: Variable PRICE_RAI is uninitialized.
NOTE: Variable SIZE_RDC is uninitialized.
NOTE: Variable PRICE_RDC is uninitialized.
NOTE: Variable SIZE_RF is uninitialized.
NOTE: Variable PRICE_RF is uninitialized.
NOTE: Variable SIZE_RHI is uninitialized.
NOTE: Variable PRICE_RHI is uninitialized.
NOTE: Variable SIZE_RHT is uninitialized.
NOTE: Variable PRICE_RHT is uninitialized.
NOTE: Variable SIZE_RL is uninitialized.
NOTE: Variable PRICE_RL is uninitialized.
NOTE: Variable SIZE_ROK is uninitialized.
NOTE: Variable PRICE_ROK is uninitialized.
NOTE: Variable SIZE_ROP is uninitialized.
NOTE: Variable PRICE_ROP is uninitialized.
NOTE: Variable SIZE_ROST is uninitialized.
NOTE: Variable PRICE_ROST is uninitialized.
NOTE: Variable SIZE_RRC is uninitialized.
NOTE: Variable PRICE_RRC is uninitialized.
NOTE: Variable SIZE_RRD is uninitialized.
NOTE: Variable PRICE_RRD is uninitialized.
NOTE: Variable SIZE_RSG is uninitialized.
NOTE: Variable PRICE_RSG is uninitialized.
NOTE: Variable SIZE_RTN is uninitialized.
NOTE: Variable PRICE_RTN is uninitialized.
NOTE: Variable SIZE_S is uninitialized.
NOTE: Variable PRICE_S is uninitialized.
NOTE: Variable SIZE_SBUX is uninitialized.
NOTE: Variable PRICE_SBUX is uninitialized.
NOTE: Variable SIZE_SCG is uninitialized.
NOTE: Variable PRICE_SCG is uninitialized.
NOTE: Variable SIZE_SCHW is uninitialized.
NOTE: Variable PRICE_SCHW is uninitialized.
NOTE: Variable SIZE_SE is uninitialized.
NOTE: Variable PRICE_SE is uninitialized.
NOTE: Variable SIZE_SEE is uninitialized.
NOTE: Variable PRICE_SEE is uninitialized.
NOTE: Variable SIZE_SHLD is uninitialized.
NOTE: Variable PRICE_SHLD is uninitialized.
NOTE: Variable SIZE_SHW is uninitialized.
NOTE: Variable PRICE_SHW is uninitialized.
NOTE: Variable SIZE_SIAL is uninitialized.
NOTE: Variable PRICE_SIAL is uninitialized.
NOTE: Variable SIZE_SII is uninitialized.
NOTE: Variable PRICE_SII is uninitialized.
NOTE: Variable SIZE_SJM is uninitialized.
NOTE: Variable PRICE_SJM is uninitialized.
NOTE: Variable SIZE_SLB is uninitialized.
NOTE: Variable PRICE_SLB is uninitialized.
NOTE: Variable SIZE_SNA is uninitialized.
NOTE: Variable PRICE_SNA is uninitialized.
NOTE: Variable SIZE_SNDK is uninitialized.
NOTE: Variable PRICE_SNDK is uninitialized.
NOTE: Variable SIZE_SNI is uninitialized.
NOTE: Variable PRICE_SNI is uninitialized.
NOTE: Variable SIZE_SO is uninitialized.
NOTE: Variable PRICE_SO is uninitialized.
NOTE: Variable SIZE_SPG is uninitialized.
NOTE: Variable PRICE_SPG is uninitialized.
NOTE: Variable SIZE_SRCL is uninitialized.
NOTE: Variable PRICE_SRCL is uninitialized.
NOTE: Variable SIZE_SRE is uninitialized.
NOTE: Variable PRICE_SRE is uninitialized.
NOTE: Variable SIZE_STI is uninitialized.
NOTE: Variable PRICE_STI is uninitialized.
NOTE: Variable SIZE_STJ is uninitialized.
NOTE: Variable PRICE_STJ is uninitialized.
NOTE: Variable SIZE_STR is uninitialized.
NOTE: Variable PRICE_STR is uninitialized.
NOTE: Variable SIZE_STT is uninitialized.
NOTE: Variable PRICE_STT is uninitialized.
NOTE: Variable SIZE_STZ is uninitialized.
NOTE: Variable PRICE_STZ is uninitialized.
NOTE: Variable SIZE_SUN is uninitialized.
NOTE: Variable PRICE_SUN is uninitialized.
NOTE: Variable SIZE_SVU is uninitialized.
NOTE: Variable PRICE_SVU is uninitialized.
NOTE: Variable SIZE_SWK is uninitialized.
NOTE: Variable PRICE_SWK is uninitialized.
NOTE: Variable SIZE_SWN is uninitialized.
NOTE: Variable PRICE_SWN is uninitialized.
NOTE: Variable SIZE_SWY is uninitialized.
NOTE: Variable PRICE_SWY is uninitialized.
NOTE: Variable SIZE_SYK is uninitialized.
NOTE: Variable PRICE_SYK is uninitialized.
NOTE: Variable SIZE_SYMC is uninitialized.
NOTE: Variable PRICE_SYMC is uninitialized.
NOTE: Variable SIZE_SYY is uninitialized.
NOTE: Variable PRICE_SYY is uninitialized.
NOTE: Variable SIZE_T is uninitialized.
NOTE: Variable PRICE_T is uninitialized.
NOTE: Variable SIZE_TAP is uninitialized.
NOTE: Variable PRICE_TAP is uninitialized.
NOTE: Variable SIZE_TDC is uninitialized.
NOTE: Variable PRICE_TDC is uninitialized.
NOTE: Variable SIZE_TE is uninitialized.
NOTE: Variable PRICE_TE is uninitialized.
NOTE: Variable SIZE_TER is uninitialized.
NOTE: Variable PRICE_TER is uninitialized.
NOTE: Variable SIZE_TGT is uninitialized.
NOTE: Variable PRICE_TGT is uninitialized.
NOTE: Variable SIZE_THC is uninitialized.
NOTE: Variable PRICE_THC is uninitialized.
NOTE: Variable SIZE_TIE is uninitialized.
NOTE: Variable PRICE_TIE is uninitialized.
NOTE: Variable SIZE_TIF is uninitialized.
NOTE: Variable PRICE_TIF is uninitialized.
NOTE: Variable SIZE_TJX is uninitialized.
NOTE: Variable PRICE_TJX is uninitialized.
NOTE: Variable SIZE_TLAB is uninitialized.
NOTE: Variable PRICE_TLAB is uninitialized.
NOTE: Variable SIZE_TMK is uninitialized.
NOTE: Variable PRICE_TMK is uninitialized.
NOTE: Variable SIZE_TMO is uninitialized.
NOTE: Variable PRICE_TMO is uninitialized.
NOTE: Variable SIZE_TROW is uninitialized.
NOTE: Variable PRICE_TROW is uninitialized.
NOTE: Variable SIZE_TRV is uninitialized.
NOTE: Variable PRICE_TRV is uninitialized.
NOTE: Variable SIZE_TSN is uninitialized.
NOTE: Variable PRICE_TSN is uninitialized.
NOTE: Variable SIZE_TSO is uninitialized.
NOTE: Variable PRICE_TSO is uninitialized.
NOTE: Variable SIZE_TSS is uninitialized.
NOTE: Variable PRICE_TSS is uninitialized.
NOTE: Variable SIZE_TWC is uninitialized.
NOTE: Variable PRICE_TWC is uninitialized.
NOTE: Variable SIZE_TWX is uninitialized.
NOTE: Variable PRICE_TWX is uninitialized.
NOTE: Variable SIZE_TXN is uninitialized.
NOTE: Variable PRICE_TXN is uninitialized.
NOTE: Variable SIZE_TXT is uninitialized.
NOTE: Variable PRICE_TXT is uninitialized.
NOTE: Variable SIZE_UNH is uninitialized.
NOTE: Variable PRICE_UNH is uninitialized.
NOTE: Variable SIZE_UNM is uninitialized.
NOTE: Variable PRICE_UNM is uninitialized.
NOTE: Variable SIZE_UNP is uninitialized.
NOTE: Variable PRICE_UNP is uninitialized.
NOTE: Variable SIZE_UPS is uninitialized.
NOTE: Variable PRICE_UPS is uninitialized.
NOTE: Variable SIZE_URBN is uninitialized.
NOTE: Variable PRICE_URBN is uninitialized.
NOTE: Variable SIZE_USB is uninitialized.
NOTE: Variable PRICE_USB is uninitialized.
NOTE: Variable SIZE_UTX is uninitialized.
NOTE: Variable PRICE_UTX is uninitialized.
NOTE: Variable SIZE_V is uninitialized.
NOTE: Variable PRICE_V is uninitialized.
NOTE: Variable SIZE_VAR is uninitialized.
NOTE: Variable PRICE_VAR is uninitialized.
NOTE: Variable SIZE_VFC is uninitialized.
NOTE: Variable PRICE_VFC is uninitialized.
NOTE: Variable SIZE_VLO is uninitialized.
NOTE: Variable PRICE_VLO is uninitialized.
NOTE: Variable SIZE_VMC is uninitialized.
NOTE: Variable PRICE_VMC is uninitialized.
NOTE: Variable SIZE_VNO is uninitialized.
NOTE: Variable PRICE_VNO is uninitialized.
NOTE: Variable SIZE_VRSN is uninitialized.
NOTE: Variable PRICE_VRSN is uninitialized.
NOTE: Variable SIZE_VTR is uninitialized.
NOTE: Variable PRICE_VTR is uninitialized.
NOTE: Variable SIZE_VZ is uninitialized.
NOTE: Variable PRICE_VZ is uninitialized.
NOTE: Variable SIZE_WAT is uninitialized.
NOTE: Variable PRICE_WAT is uninitialized.
NOTE: Variable SIZE_WDC is uninitialized.
NOTE: Variable PRICE_WDC is uninitialized.
NOTE: Variable SIZE_WEC is uninitialized.
NOTE: Variable PRICE_WEC is uninitialized.
NOTE: Variable SIZE_WFC is uninitialized.
NOTE: Variable PRICE_WFC is uninitialized.
NOTE: Variable SIZE_WHR is uninitialized.
NOTE: Variable PRICE_WHR is uninitialized.
NOTE: Variable SIZE_WIN is uninitialized.
NOTE: Variable PRICE_WIN is uninitialized.
NOTE: Variable SIZE_WM is uninitialized.
NOTE: Variable PRICE_WM is uninitialized.
NOTE: Variable SIZE_WMB is uninitialized.
NOTE: Variable PRICE_WMB is uninitialized.
NOTE: Variable SIZE_WMT is uninitialized.
NOTE: Variable PRICE_WMT is uninitialized.
NOTE: Variable SIZE_WU is uninitialized.
NOTE: Variable PRICE_WU is uninitialized.
NOTE: Variable SIZE_WY is uninitialized.
NOTE: Variable PRICE_WY is uninitialized.
NOTE: Variable SIZE_WYN is uninitialized.
NOTE: Variable PRICE_WYN is uninitialized.
NOTE: Variable SIZE_WYNN is uninitialized.
NOTE: Variable PRICE_WYNN is uninitialized.
NOTE: Variable SIZE_X is uninitialized.
NOTE: Variable PRICE_X is uninitialized.
NOTE: Variable SIZE_XEL is uninitialized.
NOTE: Variable PRICE_XEL is uninitialized.
NOTE: Variable SIZE_XL is uninitialized.
NOTE: Variable PRICE_XL is uninitialized.
NOTE: Variable SIZE_XLNX is uninitialized.
NOTE: Variable PRICE_XLNX is uninitialized.
NOTE: Variable SIZE_XOM is uninitialized.
NOTE: Variable PRICE_XOM is uninitialized.
NOTE: Variable SIZE_XRAY is uninitialized.
NOTE: Variable PRICE_XRAY is uninitialized.
NOTE: Variable SIZE_XRX is uninitialized.
NOTE: Variable PRICE_XRX is uninitialized.
NOTE: Variable SIZE_XTO is uninitialized.
NOTE: Variable PRICE_XTO is uninitialized.
NOTE: Variable SIZE_Y is uninitialized.
NOTE: Variable PRICE_Y is uninitialized.
NOTE: Variable SIZE_YHOO is uninitialized.
NOTE: Variable PRICE_YHOO is uninitialized.
NOTE: Variable SIZE_YUM is uninitialized.
NOTE: Variable PRICE_YUM is uninitialized.
NOTE: Variable SIZE_ZION is uninitialized.
NOTE: Variable PRICE_ZION is uninitialized.
NOTE: There were 0 observations read from the data set WORK.WANT.
NOTE: The data set WORK.WANT has 0 observations and 0 variables.
NOTE: DATA statement used (Total process time):
real time 0.89 seconds
cpu time 0.86 seconds

NOTE: Deleting WORK.T_E_M_P (memtype=DATA).
NOTE: Deleting WORK._FOR_FORMAT (memtype=DATA).
NOTE: PROCEDURE DELETE used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

art297 · Posted 05-26-2017 11:36 PM

I would have to see your data to be able to understand what went wrong. If you can share it, you can send it to me directly at:

art@analystfinder.com

Art, CEO, AnalystFinder.com

art297 · Posted 05-27-2017 12:00 AM

As it turns out, time is a character variable representation of time2 which is a SAS time variable. Try it with the following:

Filename three 'g:\threeone.dat';
data have;
  infile three expandtabs;
  input TIME_M $ SYM_ROOT $ SIZE PRICE TIME2;
run;

proc sort data=have out=need nodupkey;
  by time2 sym_root;
run;

%transpose(data=need, out=want, by=time2, id=sym_root,
delimiter=_,var=price size)

Art, CEO, AnalystFinder.com

kbl · Posted 05-27-2017 12:05 AM

Here is the log Art:

2769
2770 Filename three 'g:\threeone.dat';
2771 data have;
2772 infile three expandtabs;
2773 input TIME_M $ SYM_ROOT $ SIZE PRICE TIME2;
2774 run;

NOTE: The infile THREE is:
Filename=g:\threeone.dat,
RECFM=V,LRECL=32767,File Size (bytes)=4860534,
Last Modified=26May2017:12:52:06,
Create Time=25May2017:23:18:31

NOTE: 179219 records were read from the infile THREE.
The minimum record length was 19.
The maximum record length was 30.
NOTE: The data set WORK.HAVE has 179219 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.20 seconds
cpu time 0.15 seconds

2775
2776 proc sort data=have out=need nodupkey;
2777 by time2 sym_root;
2778 run;

NOTE: There were 179219 observations read from the data set WORK.HAVE.
NOTE: 199 observations with duplicate key values were deleted.
NOTE: The data set WORK.NEED has 179020 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.13 seconds
cpu time 0.25 seconds

2779
2780 %transpose(data=need, out=want, by=time2, id=sym_root,
2781 delimiter=_,var=price size)

NOTE: There were 1 observations read from the data set WORK.NEED.
NOTE: The data set WORK.T_E_M_P has 1 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.03 seconds

NOTE: No rows were selected.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: There were 179020 observations read from the data set WORK.NEED.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 1 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds

NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.03 seconds

ERROR: These two ranges overlap: LOW-LOW and A-A (fuzz=0).

WARNING: RUN statement ignored due to previous errors. Submit QUIT; to terminate the procedure.
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.

NOTE: Line generated by the invoked macro "TRANSPOSE".
1997 ; array have_num(*) &vars_num.; retain want_num; if first.&lastby. then
1997! call missing(of want_num(*)); ___nnum=put(&id.,labelfmt.)*dim(have_num); do
---------
48
1997! ___i=1 to dim(have_num); want_num(___nnum+___i)=have_num(___i); end;

ERROR 48-59: The format $LABELFMT was not found or could not be loaded.

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
1997:132
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.WANT may be incomplete. When this step was stopped there were 0
observations and 943 variables.
WARNING: Data set WORK.WANT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.76 seconds
cpu time 0.76 seconds

NOTE: Variable time2 is uninitialized.
NOTE: Variable SIZE_A is uninitialized.
NOTE: Variable PRICE_A is uninitialized.
NOTE: Variable SIZE_AA is uninitialized.
NOTE: Variable PRICE_AA is uninitialized.
NOTE: Variable SIZE_AAPL is uninitialized.
NOTE: Variable PRICE_AAPL is uninitialized.
NOTE: Variable SIZE_ABC is uninitialized.
NOTE: Variable PRICE_ABC is uninitialized.
NOTE: Variable SIZE_ABT is uninitialized.
NOTE: Variable PRICE_ABT is uninitialized.
NOTE: Variable SIZE_ADBE is uninitialized.
NOTE: Variable PRICE_ADBE is uninitialized.
NOTE: Variable SIZE_ADI is uninitialized.
NOTE: Variable PRICE_ADI is uninitialized.
NOTE: Variable SIZE_ADM is uninitialized.
NOTE: Variable PRICE_ADM is uninitialized.
NOTE: Variable SIZE_ADP is uninitialized.
NOTE: Variable PRICE_ADP is uninitialized.
NOTE: Variable SIZE_ADSK is uninitialized.
NOTE: Variable PRICE_ADSK is uninitialized.
NOTE: Variable SIZE_AEE is uninitialized.
NOTE: Variable PRICE_AEE is uninitialized.
NOTE: Variable SIZE_AEP is uninitialized.
NOTE: Variable PRICE_AEP is uninitialized.
NOTE: Variable SIZE_AES is uninitialized.
NOTE: Variable PRICE_AES is uninitialized.
NOTE: Variable SIZE_AET is uninitialized.
NOTE: Variable PRICE_AET is uninitialized.
NOTE: Variable SIZE_AFL is uninitialized.
NOTE: Variable PRICE_AFL is uninitialized.
NOTE: Variable SIZE_AGN is uninitialized.
NOTE: Variable PRICE_AGN is uninitialized.
NOTE: Variable SIZE_AIG is uninitialized.
NOTE: Variable PRICE_AIG is uninitialized.
NOTE: Variable SIZE_AIV is uninitialized.
NOTE: Variable PRICE_AIV is uninitialized.
NOTE: Variable SIZE_AIZ is uninitialized.
NOTE: Variable PRICE_AIZ is uninitialized.
NOTE: Variable SIZE_AKAM is uninitialized.
NOTE: Variable PRICE_AKAM is uninitialized.
NOTE: Variable SIZE_AKS is uninitialized.
NOTE: Variable PRICE_AKS is uninitialized.
NOTE: Variable SIZE_ALL is uninitialized.
NOTE: Variable PRICE_ALL is uninitialized.
NOTE: Variable SIZE_ALTR is uninitialized.
NOTE: Variable PRICE_ALTR is uninitialized.
NOTE: Variable SIZE_AMAT is uninitialized.
NOTE: Variable PRICE_AMAT is uninitialized.
NOTE: Variable SIZE_AMD is uninitialized.
NOTE: Variable PRICE_AMD is uninitialized.
NOTE: Variable SIZE_AMGN is uninitialized.
NOTE: Variable PRICE_AMGN is uninitialized.
NOTE: Variable SIZE_AMP is uninitialized.
NOTE: Variable PRICE_AMP is uninitialized.
NOTE: Variable SIZE_AMT is uninitialized.
NOTE: Variable PRICE_AMT is uninitialized.
NOTE: Variable SIZE_AMZN is uninitialized.
NOTE: Variable PRICE_AMZN is uninitialized.
NOTE: Variable SIZE_AN is uninitialized.
NOTE: Variable PRICE_AN is uninitialized.
NOTE: Variable SIZE_ANF is uninitialized.
NOTE: Variable PRICE_ANF is uninitialized.
NOTE: Variable SIZE_AON is uninitialized.
NOTE: Variable PRICE_AON is uninitialized.
NOTE: Variable SIZE_APA is uninitialized.
NOTE: Variable PRICE_APA is uninitialized.
NOTE: Variable SIZE_APC is uninitialized.
NOTE: Variable PRICE_APC is uninitialized.
NOTE: Variable SIZE_APD is uninitialized.
NOTE: Variable PRICE_APD is uninitialized.
NOTE: Variable SIZE_APH is uninitialized.
NOTE: Variable PRICE_APH is uninitialized.
NOTE: Variable SIZE_APOL is uninitialized.
NOTE: Variable PRICE_APOL is uninitialized.
NOTE: Variable SIZE_ARG is uninitialized.
NOTE: Variable PRICE_ARG is uninitialized.
NOTE: Variable SIZE_ATI is uninitialized.
NOTE: Variable PRICE_ATI is uninitialized.
NOTE: Variable SIZE_AVB is uninitialized.
NOTE: Variable PRICE_AVB is uninitialized.
NOTE: Variable SIZE_AVP is uninitialized.
NOTE: Variable PRICE_AVP is uninitialized.
NOTE: Variable SIZE_AVY is uninitialized.
NOTE: Variable PRICE_AVY is uninitialized.
NOTE: Variable SIZE_AXP is uninitialized.
NOTE: Variable PRICE_AXP is uninitialized.
NOTE: Variable SIZE_AYE is uninitialized.
NOTE: Variable PRICE_AYE is uninitialized.
NOTE: Variable SIZE_AZO is uninitialized.
NOTE: Variable PRICE_AZO is uninitialized.
NOTE: Variable SIZE_BA is uninitialized.
NOTE: Variable PRICE_BA is uninitialized.
NOTE: Variable SIZE_BAC is uninitialized.
NOTE: Variable PRICE_BAC is uninitialized.
NOTE: Variable SIZE_BAX is uninitialized.
NOTE: Variable PRICE_BAX is uninitialized.
NOTE: Variable SIZE_BBBY is uninitialized.
NOTE: Variable PRICE_BBBY is uninitialized.
NOTE: Variable SIZE_BBT is uninitialized.
NOTE: Variable PRICE_BBT is uninitialized.
NOTE: Variable SIZE_BBY is uninitialized.
NOTE: Variable PRICE_BBY is uninitialized.
NOTE: Variable SIZE_BCR is uninitialized.
NOTE: Variable PRICE_BCR is uninitialized.
NOTE: Variable SIZE_BDX is uninitialized.
NOTE: Variable PRICE_BDX is uninitialized.
NOTE: Variable SIZE_BEN is uninitialized.
NOTE: Variable PRICE_BEN is uninitialized.
NOTE: Variable SIZE_BHI is uninitialized.
NOTE: Variable PRICE_BHI is uninitialized.
NOTE: Variable SIZE_BIG is uninitialized.
NOTE: Variable PRICE_BIG is uninitialized.
NOTE: Variable SIZE_BIIB is uninitialized.
NOTE: Variable PRICE_BIIB is uninitialized.
NOTE: Variable SIZE_BK is uninitialized.
NOTE: Variable PRICE_BK is uninitialized.
NOTE: Variable SIZE_BLL is uninitialized.
NOTE: Variable PRICE_BLL is uninitialized.
NOTE: Variable SIZE_BMC is uninitialized.
NOTE: Variable PRICE_BMC is uninitialized.
NOTE: Variable SIZE_BMS is uninitialized.
NOTE: Variable PRICE_BMS is uninitialized.
NOTE: Variable SIZE_BMY is uninitialized.
NOTE: Variable PRICE_BMY is uninitialized.
NOTE: Variable SIZE_BRCM is uninitialized.
NOTE: Variable PRICE_BRCM is uninitialized.
NOTE: Variable SIZE_BSX is uninitialized.
NOTE: Variable PRICE_BSX is uninitialized.
NOTE: Variable SIZE_BTU is uninitialized.
NOTE: Variable PRICE_BTU is uninitialized.
NOTE: Variable SIZE_BXP is uninitialized.
NOTE: Variable PRICE_BXP is uninitialized.
NOTE: Variable SIZE_C is uninitialized.
NOTE: Variable PRICE_C is uninitialized.
NOTE: Variable SIZE_CA is uninitialized.
NOTE: Variable PRICE_CA is uninitialized.
NOTE: Variable SIZE_CAG is uninitialized.
NOTE: Variable PRICE_CAG is uninitialized.
NOTE: Variable SIZE_CAH is uninitialized.
NOTE: Variable PRICE_CAH is uninitialized.
NOTE: Variable SIZE_CAM is uninitialized.
NOTE: Variable PRICE_CAM is uninitialized.
NOTE: Variable SIZE_CAT is uninitialized.
NOTE: Variable PRICE_CAT is uninitialized.
NOTE: Variable SIZE_CB is uninitialized.
NOTE: Variable PRICE_CB is uninitialized.
NOTE: Variable SIZE_CBG is uninitialized.
NOTE: Variable PRICE_CBG is uninitialized.
NOTE: Variable SIZE_CBS is uninitialized.
NOTE: Variable PRICE_CBS is uninitialized.
NOTE: Variable SIZE_CCE is uninitialized.
NOTE: Variable PRICE_CCE is uninitialized.
NOTE: Variable SIZE_CCL is uninitialized.
NOTE: Variable PRICE_CCL is uninitialized.
NOTE: Variable SIZE_CEG is uninitialized.
NOTE: Variable PRICE_CEG is uninitialized.
NOTE: Variable SIZE_CELG is uninitialized.
NOTE: Variable PRICE_CELG is uninitialized.
NOTE: Variable SIZE_CEPH is uninitialized.
NOTE: Variable PRICE_CEPH is uninitialized.
NOTE: Variable SIZE_CF is uninitialized.
NOTE: Variable PRICE_CF is uninitialized.
NOTE: Variable SIZE_CFN is uninitialized.
NOTE: Variable PRICE_CFN is uninitialized.
NOTE: Variable SIZE_CHK is uninitialized.
NOTE: Variable PRICE_CHK is uninitialized.
NOTE: Variable SIZE_CHRW is uninitialized.
NOTE: Variable PRICE_CHRW is uninitialized.
NOTE: Variable SIZE_CI is uninitialized.
NOTE: Variable PRICE_CI is uninitialized.
NOTE: Variable SIZE_CINF is uninitialized.
NOTE: Variable PRICE_CINF is uninitialized.
NOTE: Variable SIZE_CL is uninitialized.
NOTE: Variable PRICE_CL is uninitialized.
NOTE: Variable SIZE_CLF is uninitialized.
NOTE: Variable PRICE_CLF is uninitialized.
NOTE: Variable SIZE_CLX is uninitialized.
NOTE: Variable PRICE_CLX is uninitialized.
NOTE: Variable SIZE_CMA is uninitialized.
NOTE: Variable PRICE_CMA is uninitialized.
NOTE: Variable SIZE_CME is uninitialized.
NOTE: Variable PRICE_CME is uninitialized.
NOTE: Variable SIZE_CMI is uninitialized.
NOTE: Variable PRICE_CMI is uninitialized.
NOTE: Variable SIZE_CMS is uninitialized.
NOTE: Variable PRICE_CMS is uninitialized.
NOTE: Variable SIZE_CNP is uninitialized.
NOTE: Variable PRICE_CNP is uninitialized.
NOTE: Variable SIZE_CNX is uninitialized.
NOTE: Variable PRICE_CNX is uninitialized.
NOTE: Variable SIZE_COF is uninitialized.
NOTE: Variable PRICE_COF is uninitialized.
NOTE: Variable SIZE_COG is uninitialized.
NOTE: Variable PRICE_COG is uninitialized.
NOTE: Variable SIZE_COH is uninitialized.
NOTE: Variable PRICE_COH is uninitialized.
NOTE: Variable SIZE_COL is uninitialized.
NOTE: Variable PRICE_COL is uninitialized.
NOTE: Variable SIZE_COP is uninitialized.
NOTE: Variable PRICE_COP is uninitialized.
NOTE: Variable SIZE_COST is uninitialized.
NOTE: Variable PRICE_COST is uninitialized.
NOTE: Variable SIZE_CPB is uninitialized.
NOTE: Variable PRICE_CPB is uninitialized.
NOTE: Variable SIZE_CPWR is uninitialized.
NOTE: Variable PRICE_CPWR is uninitialized.
NOTE: Variable SIZE_CRM is uninitialized.
NOTE: Variable PRICE_CRM is uninitialized.
NOTE: Variable SIZE_CSC is uninitialized.
NOTE: Variable PRICE_CSC is uninitialized.
NOTE: Variable SIZE_CSCO is uninitialized.
NOTE: Variable PRICE_CSCO is uninitialized.
NOTE: Variable SIZE_CSX is uninitialized.
NOTE: Variable PRICE_CSX is uninitialized.
NOTE: Variable SIZE_CTAS is uninitialized.
NOTE: Variable PRICE_CTAS is uninitialized.
NOTE: Variable SIZE_CTL is uninitialized.
NOTE: Variable PRICE_CTL is uninitialized.
NOTE: Variable SIZE_CTSH is uninitialized.
NOTE: Variable PRICE_CTSH is uninitialized.
NOTE: Variable SIZE_CTXS is uninitialized.
NOTE: Variable PRICE_CTXS is uninitialized.
NOTE: Variable SIZE_CVH is uninitialized.
NOTE: Variable PRICE_CVH is uninitialized.
NOTE: Variable SIZE_CVS is uninitialized.
NOTE: Variable PRICE_CVS is uninitialized.
NOTE: Variable SIZE_CVX is uninitialized.
NOTE: Variable PRICE_CVX is uninitialized.
NOTE: Variable SIZE_D is uninitialized.
NOTE: Variable PRICE_D is uninitialized.
NOTE: Variable SIZE_DD is uninitialized.
NOTE: Variable PRICE_DD is uninitialized.
NOTE: Variable SIZE_DE is uninitialized.
NOTE: Variable PRICE_DE is uninitialized.
NOTE: Variable SIZE_DELL is uninitialized.
NOTE: Variable PRICE_DELL is uninitialized.
NOTE: Variable SIZE_DF is uninitialized.
NOTE: Variable PRICE_DF is uninitialized.
NOTE: Variable SIZE_DFS is uninitialized.
NOTE: Variable PRICE_DFS is uninitialized.
NOTE: Variable SIZE_DGX is uninitialized.
NOTE: Variable PRICE_DGX is uninitialized.
NOTE: Variable SIZE_DHI is uninitialized.
NOTE: Variable PRICE_DHI is uninitialized.
NOTE: Variable SIZE_DHR is uninitialized.
NOTE: Variable PRICE_DHR is uninitialized.
NOTE: Variable SIZE_DIS is uninitialized.
NOTE: Variable PRICE_DIS is uninitialized.
NOTE: Variable SIZE_DNB is uninitialized.
NOTE: Variable PRICE_DNB is uninitialized.
NOTE: Variable SIZE_DNR is uninitialized.
NOTE: Variable PRICE_DNR is uninitialized.
NOTE: Variable SIZE_DO is uninitialized.
NOTE: Variable PRICE_DO is uninitialized.
NOTE: Variable SIZE_DOV is uninitialized.
NOTE: Variable PRICE_DOV is uninitialized.
NOTE: Variable SIZE_DOW is uninitialized.
NOTE: Variable PRICE_DOW is uninitialized.
NOTE: Variable SIZE_DPS is uninitialized.
NOTE: Variable PRICE_DPS is uninitialized.
NOTE: Variable SIZE_DRI is uninitialized.
NOTE: Variable PRICE_DRI is uninitialized.
NOTE: Variable SIZE_DTE is uninitialized.
NOTE: Variable PRICE_DTE is uninitialized.
NOTE: Variable SIZE_DTV is uninitialized.
NOTE: Variable PRICE_DTV is uninitialized.
NOTE: Variable SIZE_DUK is uninitialized.
NOTE: Variable PRICE_DUK is uninitialized.
NOTE: Variable SIZE_DV is uninitialized.
NOTE: Variable PRICE_DV is uninitialized.
NOTE: Variable SIZE_DVA is uninitialized.
NOTE: Variable PRICE_DVA is uninitialized.
NOTE: Variable SIZE_DVN is uninitialized.
NOTE: Variable PRICE_DVN is uninitialized.
NOTE: Variable SIZE_EBAY is uninitialized.
NOTE: Variable PRICE_EBAY is uninitialized.
NOTE: Variable SIZE_ECL is uninitialized.
NOTE: Variable PRICE_ECL is uninitialized.
NOTE: Variable SIZE_ED is uninitialized.
NOTE: Variable PRICE_ED is uninitialized.
NOTE: Variable SIZE_EFX is uninitialized.
NOTE: Variable PRICE_EFX is uninitialized.
NOTE: Variable SIZE_EIX is uninitialized.
NOTE: Variable PRICE_EIX is uninitialized.
NOTE: Variable SIZE_EL is uninitialized.
NOTE: Variable PRICE_EL is uninitialized.
NOTE: Variable SIZE_EMC is uninitialized.
NOTE: Variable PRICE_EMC is uninitialized.
NOTE: Variable SIZE_EMN is uninitialized.
NOTE: Variable PRICE_EMN is uninitialized.
NOTE: Variable SIZE_EMR is uninitialized.
NOTE: Variable PRICE_EMR is uninitialized.
NOTE: Variable SIZE_EOG is uninitialized.
NOTE: Variable PRICE_EOG is uninitialized.
NOTE: Variable SIZE_EP is uninitialized.
NOTE: Variable PRICE_EP is uninitialized.
NOTE: Variable SIZE_EQR is uninitialized.
NOTE: Variable PRICE_EQR is uninitialized.
NOTE: Variable SIZE_EQT is uninitialized.
NOTE: Variable PRICE_EQT is uninitialized.
NOTE: Variable SIZE_ES is uninitialized.
NOTE: Variable PRICE_ES is uninitialized.
NOTE: Variable SIZE_ESRX is uninitialized.
NOTE: Variable PRICE_ESRX is uninitialized.
NOTE: Variable SIZE_ETFC is uninitialized.
NOTE: Variable PRICE_ETFC is uninitialized.
NOTE: Variable SIZE_ETN is uninitialized.
NOTE: Variable PRICE_ETN is uninitialized.
NOTE: Variable SIZE_ETR is uninitialized.
NOTE: Variable PRICE_ETR is uninitialized.
NOTE: Variable SIZE_EXC is uninitialized.
NOTE: Variable PRICE_EXC is uninitialized.
NOTE: Variable SIZE_EXPD is uninitialized.
NOTE: Variable PRICE_EXPD is uninitialized.
NOTE: Variable SIZE_EXPE is uninitialized.
NOTE: Variable PRICE_EXPE is uninitialized.
NOTE: Variable SIZE_F is uninitialized.
NOTE: Variable PRICE_F is uninitialized.
NOTE: Variable SIZE_FAST is uninitialized.
NOTE: Variable PRICE_FAST is uninitialized.
NOTE: Variable SIZE_FCX is uninitialized.
NOTE: Variable PRICE_FCX is uninitialized.
NOTE: Variable SIZE_FDO is uninitialized.
NOTE: Variable PRICE_FDO is uninitialized.
NOTE: Variable SIZE_FDX is uninitialized.
NOTE: Variable PRICE_FDX is uninitialized.
NOTE: Variable SIZE_FE is uninitialized.
NOTE: Variable PRICE_FE is uninitialized.
NOTE: Variable SIZE_FHN is uninitialized.
NOTE: Variable PRICE_FHN is uninitialized.
NOTE: Variable SIZE_FII is uninitialized.
NOTE: Variable PRICE_FII is uninitialized.
NOTE: Variable SIZE_FIS is uninitialized.
NOTE: Variable PRICE_FIS is uninitialized.
NOTE: Variable SIZE_FISV is uninitialized.
NOTE: Variable PRICE_FISV is uninitialized.
NOTE: Variable SIZE_FITB is uninitialized.
NOTE: Variable PRICE_FITB is uninitialized.
NOTE: Variable SIZE_FLIR is uninitialized.
NOTE: Variable PRICE_FLIR is uninitialized.
NOTE: Variable SIZE_FLR is uninitialized.
NOTE: Variable PRICE_FLR is uninitialized.
NOTE: Variable SIZE_FLS is uninitialized.
NOTE: Variable PRICE_FLS is uninitialized.
NOTE: Variable SIZE_FMC is uninitialized.
NOTE: Variable PRICE_FMC is uninitialized.
NOTE: Variable SIZE_FRX is uninitialized.
NOTE: Variable PRICE_FRX is uninitialized.
NOTE: Variable SIZE_FSLR is uninitialized.
NOTE: Variable PRICE_FSLR is uninitialized.
NOTE: Variable SIZE_FTI is uninitialized.
NOTE: Variable PRICE_FTI is uninitialized.
NOTE: Variable SIZE_FTR is uninitialized.
NOTE: Variable PRICE_FTR is uninitialized.
NOTE: Variable SIZE_GAS is uninitialized.
NOTE: Variable PRICE_GAS is uninitialized.
NOTE: Variable SIZE_GD is uninitialized.
NOTE: Variable PRICE_GD is uninitialized.
NOTE: Variable SIZE_GE is uninitialized.
NOTE: Variable PRICE_GE is uninitialized.
NOTE: Variable SIZE_GENZ is uninitialized.
NOTE: Variable PRICE_GENZ is uninitialized.
NOTE: Variable SIZE_GILD is uninitialized.
NOTE: Variable PRICE_GILD is uninitialized.
NOTE: Variable SIZE_GIS is uninitialized.
NOTE: Variable PRICE_GIS is uninitialized.
NOTE: Variable SIZE_GLW is uninitialized.
NOTE: Variable PRICE_GLW is uninitialized.
NOTE: Variable SIZE_GME is uninitialized.
NOTE: Variable PRICE_GME is uninitialized.
NOTE: Variable SIZE_GNW is uninitialized.
NOTE: Variable PRICE_GNW is uninitialized.
NOTE: Variable SIZE_GPC is uninitialized.
NOTE: Variable PRICE_GPC is uninitialized.
NOTE: Variable SIZE_GPS is uninitialized.
NOTE: Variable PRICE_GPS is uninitialized.
NOTE: Variable SIZE_GR is uninitialized.
NOTE: Variable PRICE_GR is uninitialized.
NOTE: Variable SIZE_GS is uninitialized.
NOTE: Variable PRICE_GS is uninitialized.
NOTE: Variable SIZE_GT is uninitialized.
NOTE: Variable PRICE_GT is uninitialized.
NOTE: Variable SIZE_GWW is uninitialized.
NOTE: Variable PRICE_GWW is uninitialized.
NOTE: Variable SIZE_HAL is uninitialized.
NOTE: Variable PRICE_HAL is uninitialized.
NOTE: Variable SIZE_HAR is uninitialized.
NOTE: Variable PRICE_HAR is uninitialized.
NOTE: Variable SIZE_HAS is uninitialized.
NOTE: Variable PRICE_HAS is uninitialized.
NOTE: Variable SIZE_HBAN is uninitialized.
NOTE: Variable PRICE_HBAN is uninitialized.
NOTE: Variable SIZE_HCBK is uninitialized.
NOTE: Variable PRICE_HCBK is uninitialized.
NOTE: Variable SIZE_HCN is uninitialized.
NOTE: Variable PRICE_HCN is uninitialized.
NOTE: Variable SIZE_HCP is uninitialized.
NOTE: Variable PRICE_HCP is uninitialized.
NOTE: Variable SIZE_HD is uninitialized.
NOTE: Variable PRICE_HD is uninitialized.
NOTE: Variable SIZE_HES is uninitialized.
NOTE: Variable PRICE_HES is uninitialized.
NOTE: Variable SIZE_HIG is uninitialized.
NOTE: Variable PRICE_HIG is uninitialized.
NOTE: Variable SIZE_HOG is uninitialized.
NOTE: Variable PRICE_HOG is uninitialized.
NOTE: Variable SIZE_HON is uninitialized.
NOTE: Variable PRICE_HON is uninitialized.
NOTE: Variable SIZE_HOT is uninitialized.
NOTE: Variable PRICE_HOT is uninitialized.
NOTE: Variable SIZE_HP is uninitialized.
NOTE: Variable PRICE_HP is uninitialized.
NOTE: Variable SIZE_HPQ is uninitialized.
NOTE: Variable PRICE_HPQ is uninitialized.
NOTE: Variable SIZE_HRB is uninitialized.
NOTE: Variable PRICE_HRB is uninitialized.
NOTE: Variable SIZE_HRL is uninitialized.
NOTE: Variable PRICE_HRL is uninitialized.
NOTE: Variable SIZE_HRS is uninitialized.
NOTE: Variable PRICE_HRS is uninitialized.
NOTE: Variable SIZE_HS is uninitialized.
NOTE: Variable PRICE_HS is uninitialized.
NOTE: Variable SIZE_HSP is uninitialized.
NOTE: Variable PRICE_HSP is uninitialized.
NOTE: Variable SIZE_HST is uninitialized.
NOTE: Variable PRICE_HST is uninitialized.
NOTE: Variable SIZE_HUM is uninitialized.
NOTE: Variable PRICE_HUM is uninitialized.
NOTE: Variable SIZE_IBM is uninitialized.
NOTE: Variable PRICE_IBM is uninitialized.
NOTE: Variable SIZE_ICE is uninitialized.
NOTE: Variable PRICE_ICE is uninitialized.
NOTE: Variable SIZE_IFF is uninitialized.
NOTE: Variable PRICE_IFF is uninitialized.
NOTE: Variable SIZE_IGT is uninitialized.
NOTE: Variable PRICE_IGT is uninitialized.
NOTE: Variable SIZE_IMS is uninitialized.
NOTE: Variable PRICE_IMS is uninitialized.
NOTE: Variable SIZE_INTC is uninitialized.
NOTE: Variable PRICE_INTC is uninitialized.
NOTE: Variable SIZE_INTU is uninitialized.
NOTE: Variable PRICE_INTU is uninitialized.
NOTE: Variable SIZE_IP is uninitialized.
NOTE: Variable PRICE_IP is uninitialized.
NOTE: Variable SIZE_IPG is uninitialized.
NOTE: Variable PRICE_IPG is uninitialized.
NOTE: Variable SIZE_IRM is uninitialized.
NOTE: Variable PRICE_IRM is uninitialized.
NOTE: Variable SIZE_ISRG is uninitialized.
NOTE: Variable PRICE_ISRG is uninitialized.
NOTE: Variable SIZE_ITT is uninitialized.
NOTE: Variable PRICE_ITT is uninitialized.
NOTE: Variable SIZE_ITW is uninitialized.
NOTE: Variable PRICE_ITW is uninitialized.
NOTE: Variable SIZE_IVZ is uninitialized.
NOTE: Variable PRICE_IVZ is uninitialized.
NOTE: Variable SIZE_JBL is uninitialized.
NOTE: Variable PRICE_JBL is uninitialized.
NOTE: Variable SIZE_JCI is uninitialized.
NOTE: Variable PRICE_JCI is uninitialized.
NOTE: Variable SIZE_JCP is uninitialized.
NOTE: Variable PRICE_JCP is uninitialized.
NOTE: Variable SIZE_JEC is uninitialized.
NOTE: Variable PRICE_JEC is uninitialized.
NOTE: Variable SIZE_JNJ is uninitialized.
NOTE: Variable PRICE_JNJ is uninitialized.
NOTE: Variable SIZE_JNPR is uninitialized.
NOTE: Variable PRICE_JNPR is uninitialized.
NOTE: Variable SIZE_JNS is uninitialized.
NOTE: Variable PRICE_JNS is uninitialized.
NOTE: Variable SIZE_JPM is uninitialized.
NOTE: Variable PRICE_JPM is uninitialized.
NOTE: Variable SIZE_JWN is uninitialized.
NOTE: Variable PRICE_JWN is uninitialized.
NOTE: Variable SIZE_K is uninitialized.
NOTE: Variable PRICE_K is uninitialized.
NOTE: Variable SIZE_KEY is uninitialized.
NOTE: Variable PRICE_KEY is uninitialized.
NOTE: Variable SIZE_KG is uninitialized.
NOTE: Variable PRICE_KG is uninitialized.
NOTE: Variable SIZE_KIM is uninitialized.
NOTE: Variable PRICE_KIM is uninitialized.
NOTE: Variable SIZE_KLAC is uninitialized.
NOTE: Variable PRICE_KLAC is uninitialized.
NOTE: Variable SIZE_KMB is uninitialized.
NOTE: Variable PRICE_KMB is uninitialized.
NOTE: Variable SIZE_KO is uninitialized.
NOTE: Variable PRICE_KO is uninitialized.
NOTE: Variable SIZE_KR is uninitialized.
NOTE: Variable PRICE_KR is uninitialized.
NOTE: Variable SIZE_KSS is uninitialized.
NOTE: Variable PRICE_KSS is uninitialized.
NOTE: Variable SIZE_L is uninitialized.
NOTE: Variable PRICE_L is uninitialized.
NOTE: Variable SIZE_LB is uninitialized.
NOTE: Variable PRICE_LB is uninitialized.
NOTE: Variable SIZE_LEG is uninitialized.
NOTE: Variable PRICE_LEG is uninitialized.
NOTE: Variable SIZE_LEN is uninitialized.
NOTE: Variable PRICE_LEN is uninitialized.
NOTE: Variable SIZE_LH is uninitialized.
NOTE: Variable PRICE_LH is uninitialized.
NOTE: Variable SIZE_LIFE is uninitialized.
NOTE: Variable PRICE_LIFE is uninitialized.
NOTE: Variable SIZE_LLL is uninitialized.
NOTE: Variable PRICE_LLL is uninitialized.
NOTE: Variable SIZE_LLTC is uninitialized.
NOTE: Variable PRICE_LLTC is uninitialized.
NOTE: Variable SIZE_LLY is uninitialized.
NOTE: Variable PRICE_LLY is uninitialized.
NOTE: Variable SIZE_LM is uninitialized.
NOTE: Variable PRICE_LM is uninitialized.
NOTE: Variable SIZE_LMT is uninitialized.
NOTE: Variable PRICE_LMT is uninitialized.
NOTE: Variable SIZE_LNC is uninitialized.
NOTE: Variable PRICE_LNC is uninitialized.
NOTE: Variable SIZE_LO is uninitialized.
NOTE: Variable PRICE_LO is uninitialized.
NOTE: Variable SIZE_LOW is uninitialized.
NOTE: Variable PRICE_LOW is uninitialized.
NOTE: Variable SIZE_LSI is uninitialized.
NOTE: Variable PRICE_LSI is uninitialized.
NOTE: Variable SIZE_LUK is uninitialized.
NOTE: Variable PRICE_LUK is uninitialized.
NOTE: Variable SIZE_LUV is uninitialized.
NOTE: Variable PRICE_LUV is uninitialized.
NOTE: Variable SIZE_LXK is uninitialized.
NOTE: Variable PRICE_LXK is uninitialized.
NOTE: Variable SIZE_M is uninitialized.
NOTE: Variable PRICE_M is uninitialized.
NOTE: Variable SIZE_MA is uninitialized.
NOTE: Variable PRICE_MA is uninitialized.
NOTE: Variable SIZE_MAR is uninitialized.
NOTE: Variable PRICE_MAR is uninitialized.
NOTE: Variable SIZE_MAS is uninitialized.
NOTE: Variable PRICE_MAS is uninitialized.
NOTE: Variable SIZE_MAT is uninitialized.
NOTE: Variable PRICE_MAT is uninitialized.
NOTE: Variable SIZE_MCD is uninitialized.
NOTE: Variable PRICE_MCD is uninitialized.
NOTE: Variable SIZE_MCHP is uninitialized.
NOTE: Variable PRICE_MCHP is uninitialized.
NOTE: Variable SIZE_MCK is uninitialized.
NOTE: Variable PRICE_MCK is uninitialized.
NOTE: Variable SIZE_MCO is uninitialized.
NOTE: Variable PRICE_MCO is uninitialized.
NOTE: Variable SIZE_MDP is uninitialized.
NOTE: Variable PRICE_MDP is uninitialized.
NOTE: Variable SIZE_MDT is uninitialized.
NOTE: Variable PRICE_MDT is uninitialized.
NOTE: Variable SIZE_MEE is uninitialized.
NOTE: Variable PRICE_MEE is uninitialized.
NOTE: Variable SIZE_MET is uninitialized.
NOTE: Variable PRICE_MET is uninitialized.
NOTE: Variable SIZE_MFE is uninitialized.
NOTE: Variable PRICE_MFE is uninitialized.
NOTE: Variable SIZE_MHS is uninitialized.
NOTE: Variable PRICE_MHS is uninitialized.
NOTE: Variable SIZE_MI is uninitialized.
NOTE: Variable PRICE_MI is uninitialized.
NOTE: Variable SIZE_MIL is uninitialized.
NOTE: Variable PRICE_MIL is uninitialized.
NOTE: Variable SIZE_MJN is uninitialized.
NOTE: Variable PRICE_MJN is uninitialized.
NOTE: Variable SIZE_MKC is uninitialized.
NOTE: Variable PRICE_MKC is uninitialized.
NOTE: Variable SIZE_MMC is uninitialized.
NOTE: Variable PRICE_MMC is uninitialized.
NOTE: Variable SIZE_MMM is uninitialized.
NOTE: Variable PRICE_MMM is uninitialized.
NOTE: Variable SIZE_MO is uninitialized.
NOTE: Variable PRICE_MO is uninitialized.
NOTE: Variable SIZE_MOLX is uninitialized.
NOTE: Variable PRICE_MOLX is uninitialized.
NOTE: Variable SIZE_MON is uninitialized.
NOTE: Variable PRICE_MON is uninitialized.
NOTE: Variable SIZE_MRK is uninitialized.
NOTE: Variable PRICE_MRK is uninitialized.
NOTE: Variable SIZE_MRO is uninitialized.
NOTE: Variable PRICE_MRO is uninitialized.
NOTE: Variable SIZE_MS is uninitialized.
NOTE: Variable PRICE_MS is uninitialized.
NOTE: Variable SIZE_MSFT is uninitialized.
NOTE: Variable PRICE_MSFT is uninitialized.
NOTE: Variable SIZE_MTB is uninitialized.
NOTE: Variable PRICE_MTB is uninitialized.
NOTE: Variable SIZE_MU is uninitialized.
NOTE: Variable PRICE_MU is uninitialized.
NOTE: Variable SIZE_MUR is uninitialized.
NOTE: Variable PRICE_MUR is uninitialized.
NOTE: Variable SIZE_MWV is uninitialized.
NOTE: Variable PRICE_MWV is uninitialized.
NOTE: Variable SIZE_MWW is uninitialized.
NOTE: Variable PRICE_MWW is uninitialized.
NOTE: Variable SIZE_MYL is uninitialized.
NOTE: Variable PRICE_MYL is uninitialized.
NOTE: Variable SIZE_NAVI is uninitialized.
NOTE: Variable PRICE_NAVI is uninitialized.
NOTE: Variable SIZE_NBL is uninitialized.
NOTE: Variable PRICE_NBL is uninitialized.
NOTE: Variable SIZE_NBR is uninitialized.
NOTE: Variable PRICE_NBR is uninitialized.
NOTE: Variable SIZE_NDAQ is uninitialized.
NOTE: Variable PRICE_NDAQ is uninitialized.
NOTE: Variable SIZE_NEM is uninitialized.
NOTE: Variable PRICE_NEM is uninitialized.
NOTE: Variable SIZE_NI is uninitialized.
NOTE: Variable PRICE_NI is uninitialized.
NOTE: Variable SIZE_NKE is uninitialized.
NOTE: Variable PRICE_NKE is uninitialized.
NOTE: Variable SIZE_NOC is uninitialized.
NOTE: Variable PRICE_NOC is uninitialized.
NOTE: Variable SIZE_NOV is uninitialized.
NOTE: Variable PRICE_NOV is uninitialized.
NOTE: Variable SIZE_NOVL is uninitialized.
NOTE: Variable PRICE_NOVL is uninitialized.
NOTE: Variable SIZE_NRG is uninitialized.
NOTE: Variable PRICE_NRG is uninitialized.
NOTE: Variable SIZE_NSC is uninitialized.
NOTE: Variable PRICE_NSC is uninitialized.
NOTE: Variable SIZE_NSM is uninitialized.
NOTE: Variable PRICE_NSM is uninitialized.
NOTE: Variable SIZE_NTAP is uninitialized.
NOTE: Variable PRICE_NTAP is uninitialized.
NOTE: Variable SIZE_NTRS is uninitialized.
NOTE: Variable PRICE_NTRS is uninitialized.
NOTE: Variable SIZE_NUE is uninitialized.
NOTE: Variable PRICE_NUE is uninitialized.
NOTE: Variable SIZE_NVDA is uninitialized.
NOTE: Variable PRICE_NVDA is uninitialized.
NOTE: Variable SIZE_NVLS is uninitialized.
NOTE: Variable PRICE_NVLS is uninitialized.
NOTE: Variable SIZE_NWL is uninitialized.
NOTE: Variable PRICE_NWL is uninitialized.
NOTE: Variable SIZE_NYT is uninitialized.
NOTE: Variable PRICE_NYT is uninitialized.
NOTE: Variable SIZE_NYX is uninitialized.
NOTE: Variable PRICE_NYX is uninitialized.
NOTE: Variable SIZE_ODP is uninitialized.
NOTE: Variable PRICE_ODP is uninitialized.
NOTE: Variable SIZE_OI is uninitialized.
NOTE: Variable PRICE_OI is uninitialized.
NOTE: Variable SIZE_OKE is uninitialized.
NOTE: Variable PRICE_OKE is uninitialized.
NOTE: Variable SIZE_OMC is uninitialized.
NOTE: Variable PRICE_OMC is uninitialized.
NOTE: Variable SIZE_ORCL is uninitialized.
NOTE: Variable PRICE_ORCL is uninitialized.
NOTE: Variable SIZE_ORLY is uninitialized.
NOTE: Variable PRICE_ORLY is uninitialized.
NOTE: Variable SIZE_OXY is uninitialized.
NOTE: Variable PRICE_OXY is uninitialized.
NOTE: Variable SIZE_PAYX is uninitialized.
NOTE: Variable PRICE_PAYX is uninitialized.
NOTE: Variable SIZE_PBCT is uninitialized.
NOTE: Variable PRICE_PBCT is uninitialized.
NOTE: Variable SIZE_PBI is uninitialized.
NOTE: Variable PRICE_PBI is uninitialized.
NOTE: Variable SIZE_PCAR is uninitialized.
NOTE: Variable PRICE_PCAR is uninitialized.
NOTE: Variable SIZE_PCG is uninitialized.
NOTE: Variable PRICE_PCG is uninitialized.
NOTE: Variable SIZE_PCL is uninitialized.
NOTE: Variable PRICE_PCL is uninitialized.
NOTE: Variable SIZE_PCLN is uninitialized.
NOTE: Variable PRICE_PCLN is uninitialized.
NOTE: Variable SIZE_PCP is uninitialized.
NOTE: Variable PRICE_PCP is uninitialized.
NOTE: Variable SIZE_PCS is uninitialized.
NOTE: Variable PRICE_PCS is uninitialized.
NOTE: Variable SIZE_PDCO is uninitialized.
NOTE: Variable PRICE_PDCO is uninitialized.
NOTE: Variable SIZE_PEG is uninitialized.
NOTE: Variable PRICE_PEG is uninitialized.
NOTE: Variable SIZE_PEP is uninitialized.
NOTE: Variable PRICE_PEP is uninitialized.
NOTE: Variable SIZE_PFE is uninitialized.
NOTE: Variable PRICE_PFE is uninitialized.
NOTE: Variable SIZE_PFG is uninitialized.
NOTE: Variable PRICE_PFG is uninitialized.
NOTE: Variable SIZE_PG is uninitialized.
NOTE: Variable PRICE_PG is uninitialized.
NOTE: Variable SIZE_PGR is uninitialized.
NOTE: Variable PRICE_PGR is uninitialized.
NOTE: Variable SIZE_PH is uninitialized.
NOTE: Variable PRICE_PH is uninitialized.
NOTE: Variable SIZE_PHM is uninitialized.
NOTE: Variable PRICE_PHM is uninitialized.
NOTE: Variable SIZE_PKI is uninitialized.
NOTE: Variable PRICE_PKI is uninitialized.
NOTE: Variable SIZE_PLD is uninitialized.
NOTE: Variable PRICE_PLD is uninitialized.
NOTE: Variable SIZE_PLL is uninitialized.
NOTE: Variable PRICE_PLL is uninitialized.
NOTE: Variable SIZE_PM is uninitialized.
NOTE: Variable PRICE_PM is uninitialized.
NOTE: Variable SIZE_PNC is uninitialized.
NOTE: Variable PRICE_PNC is uninitialized.
NOTE: Variable SIZE_PNW is uninitialized.
NOTE: Variable PRICE_PNW is uninitialized.
NOTE: Variable SIZE_POM is uninitialized.
NOTE: Variable PRICE_POM is uninitialized.
NOTE: Variable SIZE_PPG is uninitialized.
NOTE: Variable PRICE_PPG is uninitialized.
NOTE: Variable SIZE_PPL is uninitialized.
NOTE: Variable PRICE_PPL is uninitialized.
NOTE: Variable SIZE_PRU is uninitialized.
NOTE: Variable PRICE_PRU is uninitialized.
NOTE: Variable SIZE_PSA is uninitialized.
NOTE: Variable PRICE_PSA is uninitialized.
NOTE: Variable SIZE_PTV is uninitialized.
NOTE: Variable PRICE_PTV is uninitialized.
NOTE: Variable SIZE_PWR is uninitialized.
NOTE: Variable PRICE_PWR is uninitialized.
NOTE: Variable SIZE_PX is uninitialized.
NOTE: Variable PRICE_PX is uninitialized.
NOTE: Variable SIZE_PXD is uninitialized.
NOTE: Variable PRICE_PXD is uninitialized.
NOTE: Variable SIZE_Q is uninitialized.
NOTE: Variable PRICE_Q is uninitialized.
NOTE: Variable SIZE_QCOM is uninitialized.
NOTE: Variable PRICE_QCOM is uninitialized.
NOTE: Variable SIZE_QLGC is uninitialized.
NOTE: Variable PRICE_QLGC is uninitialized.
NOTE: Variable SIZE_R is uninitialized.
NOTE: Variable PRICE_R is uninitialized.
NOTE: Variable SIZE_RAI is uninitialized.
NOTE: Variable PRICE_RAI is uninitialized.
NOTE: Variable SIZE_RDC is uninitialized.
NOTE: Variable PRICE_RDC is uninitialized.
NOTE: Variable SIZE_RF is uninitialized.
NOTE: Variable PRICE_RF is uninitialized.
NOTE: Variable SIZE_RHI is uninitialized.
NOTE: Variable PRICE_RHI is uninitialized.
NOTE: Variable SIZE_RHT is uninitialized.
NOTE: Variable PRICE_RHT is uninitialized.
NOTE: Variable SIZE_RL is uninitialized.
NOTE: Variable PRICE_RL is uninitialized.
NOTE: Variable SIZE_ROK is uninitialized.
NOTE: Variable PRICE_ROK is uninitialized.
NOTE: Variable SIZE_ROP is uninitialized.
NOTE: Variable PRICE_ROP is uninitialized.
NOTE: Variable SIZE_ROST is uninitialized.
NOTE: Variable PRICE_ROST is uninitialized.
NOTE: Variable SIZE_RRC is uninitialized.
NOTE: Variable PRICE_RRC is uninitialized.
NOTE: Variable SIZE_RRD is uninitialized.
NOTE: Variable PRICE_RRD is uninitialized.
NOTE: Variable SIZE_RSG is uninitialized.
NOTE: Variable PRICE_RSG is uninitialized.
NOTE: Variable SIZE_RTN is uninitialized.
NOTE: Variable PRICE_RTN is uninitialized.
NOTE: Variable SIZE_S is uninitialized.
NOTE: Variable PRICE_S is uninitialized.
NOTE: Variable SIZE_SBUX is uninitialized.
NOTE: Variable PRICE_SBUX is uninitialized.
NOTE: Variable SIZE_SCG is uninitialized.
NOTE: Variable PRICE_SCG is uninitialized.
NOTE: Variable SIZE_SCHW is uninitialized.
NOTE: Variable PRICE_SCHW is uninitialized.
NOTE: Variable SIZE_SE is uninitialized.
NOTE: Variable PRICE_SE is uninitialized.
NOTE: Variable SIZE_SEE is uninitialized.
NOTE: Variable PRICE_SEE is uninitialized.
NOTE: Variable SIZE_SHLD is uninitialized.
NOTE: Variable PRICE_SHLD is uninitialized.
NOTE: Variable SIZE_SHW is uninitialized.
NOTE: Variable PRICE_SHW is uninitialized.
NOTE: Variable SIZE_SIAL is uninitialized.
NOTE: Variable PRICE_SIAL is uninitialized.
NOTE: Variable SIZE_SII is uninitialized.
NOTE: Variable PRICE_SII is uninitialized.
NOTE: Variable SIZE_SJM is uninitialized.
NOTE: Variable PRICE_SJM is uninitialized.
NOTE: Variable SIZE_SLB is uninitialized.
NOTE: Variable PRICE_SLB is uninitialized.
NOTE: Variable SIZE_SNA is uninitialized.
NOTE: Variable PRICE_SNA is uninitialized.
NOTE: Variable SIZE_SNDK is uninitialized.
NOTE: Variable PRICE_SNDK is uninitialized.
NOTE: Variable SIZE_SNI is uninitialized.
NOTE: Variable PRICE_SNI is uninitialized.
NOTE: Variable SIZE_SO is uninitialized.
NOTE: Variable PRICE_SO is uninitialized.
NOTE: Variable SIZE_SPG is uninitialized.
NOTE: Variable PRICE_SPG is uninitialized.
NOTE: Variable SIZE_SRCL is uninitialized.
NOTE: Variable PRICE_SRCL is uninitialized.
NOTE: Variable SIZE_SRE is uninitialized.
NOTE: Variable PRICE_SRE is uninitialized.
NOTE: Variable SIZE_STI is uninitialized.
NOTE: Variable PRICE_STI is uninitialized.
NOTE: Variable SIZE_STJ is uninitialized.
NOTE: Variable PRICE_STJ is uninitialized.
NOTE: Variable SIZE_STR is uninitialized.
NOTE: Variable PRICE_STR is uninitialized.
NOTE: Variable SIZE_STT is uninitialized.
NOTE: Variable PRICE_STT is uninitialized.
NOTE: Variable SIZE_STZ is uninitialized.
NOTE: Variable PRICE_STZ is uninitialized.
NOTE: Variable SIZE_SUN is uninitialized.
NOTE: Variable PRICE_SUN is uninitialized.
NOTE: Variable SIZE_SVU is uninitialized.
NOTE: Variable PRICE_SVU is uninitialized.
NOTE: Variable SIZE_SWK is uninitialized.
NOTE: Variable PRICE_SWK is uninitialized.
NOTE: Variable SIZE_SWN is uninitialized.
NOTE: Variable PRICE_SWN is uninitialized.
NOTE: Variable SIZE_SWY is uninitialized.
NOTE: Variable PRICE_SWY is uninitialized.
NOTE: Variable SIZE_SYK is uninitialized.
NOTE: Variable PRICE_SYK is uninitialized.
NOTE: Variable SIZE_SYMC is uninitialized.
NOTE: Variable PRICE_SYMC is uninitialized.
NOTE: Variable SIZE_SYY is uninitialized.
NOTE: Variable PRICE_SYY is uninitialized.
NOTE: Variable SIZE_T is uninitialized.
NOTE: Variable PRICE_T is uninitialized.
NOTE: Variable SIZE_TAP is uninitialized.
NOTE: Variable PRICE_TAP is uninitialized.
NOTE: Variable SIZE_TDC is uninitialized.
NOTE: Variable PRICE_TDC is uninitialized.
NOTE: Variable SIZE_TE is uninitialized.
NOTE: Variable PRICE_TE is uninitialized.
NOTE: Variable SIZE_TER is uninitialized.
NOTE: Variable PRICE_TER is uninitialized.
NOTE: Variable SIZE_TGT is uninitialized.
NOTE: Variable PRICE_TGT is uninitialized.
NOTE: Variable SIZE_THC is uninitialized.
NOTE: Variable PRICE_THC is uninitialized.
NOTE: Variable SIZE_TIE is uninitialized.
NOTE: Variable PRICE_TIE is uninitialized.
NOTE: Variable SIZE_TIF is uninitialized.
NOTE: Variable PRICE_TIF is uninitialized.
NOTE: Variable SIZE_TJX is uninitialized.
NOTE: Variable PRICE_TJX is uninitialized.
NOTE: Variable SIZE_TLAB is uninitialized.
NOTE: Variable PRICE_TLAB is uninitialized.
NOTE: Variable SIZE_TMK is uninitialized.
NOTE: Variable PRICE_TMK is uninitialized.
NOTE: Variable SIZE_TMO is uninitialized.
NOTE: Variable PRICE_TMO is uninitialized.
NOTE: Variable SIZE_TROW is uninitialized.
NOTE: Variable PRICE_TROW is uninitialized.
NOTE: Variable SIZE_TRV is uninitialized.
NOTE: Variable PRICE_TRV is uninitialized.
NOTE: Variable SIZE_TSN is uninitialized.
NOTE: Variable PRICE_TSN is uninitialized.
NOTE: Variable SIZE_TSO is uninitialized.
NOTE: Variable PRICE_TSO is uninitialized.
NOTE: Variable SIZE_TSS is uninitialized.
NOTE: Variable PRICE_TSS is uninitialized.
NOTE: Variable SIZE_TWC is uninitialized.
NOTE: Variable PRICE_TWC is uninitialized.
NOTE: Variable SIZE_TWX is uninitialized.
NOTE: Variable PRICE_TWX is uninitialized.
NOTE: Variable SIZE_TXN is uninitialized.
NOTE: Variable PRICE_TXN is uninitialized.
NOTE: Variable SIZE_TXT is uninitialized.
NOTE: Variable PRICE_TXT is uninitialized.
NOTE: Variable SIZE_UNH is uninitialized.
NOTE: Variable PRICE_UNH is uninitialized.
NOTE: Variable SIZE_UNM is uninitialized.
NOTE: Variable PRICE_UNM is uninitialized.
NOTE: Variable SIZE_UNP is uninitialized.
NOTE: Variable PRICE_UNP is uninitialized.
NOTE: Variable SIZE_UPS is uninitialized.
NOTE: Variable PRICE_UPS is uninitialized.
NOTE: Variable SIZE_URBN is uninitialized.
NOTE: Variable PRICE_URBN is uninitialized.
NOTE: Variable SIZE_USB is uninitialized.
NOTE: Variable PRICE_USB is uninitialized.
NOTE: Variable SIZE_UTX is uninitialized.
NOTE: Variable PRICE_UTX is uninitialized.
NOTE: Variable SIZE_V is uninitialized.
NOTE: Variable PRICE_V is uninitialized.
NOTE: Variable SIZE_VAR is uninitialized.
NOTE: Variable PRICE_VAR is uninitialized.
NOTE: Variable SIZE_VFC is uninitialized.
NOTE: Variable PRICE_VFC is uninitialized.
NOTE: Variable SIZE_VLO is uninitialized.
NOTE: Variable PRICE_VLO is uninitialized.
NOTE: Variable SIZE_VMC is uninitialized.
NOTE: Variable PRICE_VMC is uninitialized.
NOTE: Variable SIZE_VNO is uninitialized.
NOTE: Variable PRICE_VNO is uninitialized.
NOTE: Variable SIZE_VRSN is uninitialized.
NOTE: Variable PRICE_VRSN is uninitialized.
NOTE: Variable SIZE_VTR is uninitialized.
NOTE: Variable PRICE_VTR is uninitialized.
NOTE: Variable SIZE_VZ is uninitialized.
NOTE: Variable PRICE_VZ is uninitialized.
NOTE: Variable SIZE_WAT is uninitialized.
NOTE: Variable PRICE_WAT is uninitialized.
NOTE: Variable SIZE_WDC is uninitialized.
NOTE: Variable PRICE_WDC is uninitialized.
NOTE: Variable SIZE_WEC is uninitialized.
NOTE: Variable PRICE_WEC is uninitialized.
NOTE: Variable SIZE_WFC is uninitialized.
NOTE: Variable PRICE_WFC is uninitialized.
NOTE: Variable SIZE_WHR is uninitialized.
NOTE: Variable PRICE_WHR is uninitialized.
NOTE: Variable SIZE_WIN is uninitialized.
NOTE: Variable PRICE_WIN is uninitialized.
NOTE: Variable SIZE_WM is uninitialized.
NOTE: Variable PRICE_WM is uninitialized.
NOTE: Variable SIZE_WMB is uninitialized.
NOTE: Variable PRICE_WMB is uninitialized.
NOTE: Variable SIZE_WMT is uninitialized.
NOTE: Variable PRICE_WMT is uninitialized.
NOTE: Variable SIZE_WU is uninitialized.
NOTE: Variable PRICE_WU is uninitialized.
NOTE: Variable SIZE_WY is uninitialized.
NOTE: Variable PRICE_WY is uninitialized.
NOTE: Variable SIZE_WYN is uninitialized.
NOTE: Variable PRICE_WYN is uninitialized.
NOTE: Variable SIZE_WYNN is uninitialized.
NOTE: Variable PRICE_WYNN is uninitialized.
NOTE: Variable SIZE_X is uninitialized.
NOTE: Variable PRICE_X is uninitialized.
NOTE: Variable SIZE_XEL is uninitialized.
NOTE: Variable PRICE_XEL is uninitialized.
NOTE: Variable SIZE_XL is uninitialized.
NOTE: Variable PRICE_XL is uninitialized.
NOTE: Variable SIZE_XLNX is uninitialized.
NOTE: Variable PRICE_XLNX is uninitialized.
NOTE: Variable SIZE_XOM is uninitialized.
NOTE: Variable PRICE_XOM is uninitialized.
NOTE: Variable SIZE_XRAY is uninitialized.
NOTE: Variable PRICE_XRAY is uninitialized.
NOTE: Variable SIZE_XRX is uninitialized.
NOTE: Variable PRICE_XRX is uninitialized.
NOTE: Variable SIZE_XTO is uninitialized.
NOTE: Variable PRICE_XTO is uninitialized.
NOTE: Variable SIZE_Y is uninitialized.
NOTE: Variable PRICE_Y is uninitialized.
NOTE: Variable SIZE_YHOO is uninitialized.
NOTE: Variable PRICE_YHOO is uninitialized.
NOTE: Variable SIZE_YUM is uninitialized.
NOTE: Variable PRICE_YUM is uninitialized.
NOTE: Variable SIZE_ZION is uninitialized.
NOTE: Variable PRICE_ZION is uninitialized.
NOTE: There were 0 observations read from the data set WORK.WANT.
NOTE: The data set WORK.WANT has 0 observations and 0 variables.
NOTE: DATA statement used (Total process time):
real time 1.32 seconds
cpu time 1.28 seconds

NOTE: Deleting WORK.T_E_M_P (memtype=DATA).
NOTE: Deleting WORK._FOR_FORMAT (memtype=DATA).
NOTE: PROCEDURE DELETE used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

2782
2783
2784
2785 %macro transpose(libname_in=,
2786 libname_out=,
2787 data= have,
2788 out= need,
2789 by=,
2790 prefix=,
2791 var=,
2792 autovars=,
2793 id=,
2794 descendingid=,
2795 var_first=,
2796 format=,
2797 delimiter=,
2798 copy=,
2799 drop=,
2800 sort=,
2801 sort_options=,
2802 use_varname=,
2803 preloadfmt=,
2804 guessingrows=,
2805 newid=);
2806
2807 /*Check whether the data and out parameters contain one or two-level filenames*/
2808 %let lp=%sysfunc(findc(%superq(data),%str(%()));
2809 %if &lp. %then %do;
2810 %let rp=%sysfunc(findc(%superq(data),%str(%)),b));
2811 %let dsoptions=%qsysfunc(substrn(%nrstr(%superq(data)),&lp+1,&rp-&lp-1));
2812 %let data=%sysfunc(substrn(%nrstr(%superq(data)),1,%eval(&lp-1)));
2813 %end;
2814 %else %let dsoptions=;
2815 %if %sysfunc(countw(&data.)) eq 2 %then %do;
2816 %let libname_in=%scan(&data.,1);
2817 %let data=%scan(&data.,2);
2818 %end;
2819 %else %if %length(&libname_in.) eq 0 %then %do;
2820 %let libname_in=work;
2821 %end;
2822
2823 %if %sysfunc(countw(&out.)) eq 2 %then %do;
2824 %let libname_out=%scan(&out.,1);
2825 %let out=%scan(&out.,2);
2826 %end;
2827 %else %if %length(&libname_out.) eq 0 %then %do;
2828 %let libname_out=work;
2829 %end;
2830
2831 %if %length(&newid.) eq 0 %then %do;
2832 %let newid=row;
2833 %end;
2834
2835 /*obtain last by variable*/
2836 %if %length(&by.) gt 0 %then %do;
2837 %let lastby=%scan(&by.,-1);
2838 %end;
2839 %else %do;
2840 %let lastby=;
2841 %end;
2842
2843 /*Create macro variable to contain a list of variables to be copied*/
2844 %let to_copy=;
2845 %if %length(&copy.) gt 0 %then %do;
2846 data t_e_m_p;
2847 set &libname_in..&data. (obs=1 keep=&copy.);
2848 run;
2849
2850 proc sql noprint;
2851 select name
2852 into :to_copy separated by " "
2853 from dictionary.columns
2854 where libname="WORK" and
2855 memname="T_E_M_P"
2856 ;
2857 quit;
2858 %end;
2859
2860 /*Populate var parameter in the event it has a null value*/
2861 %if %length(&var.) eq 0 %then %do;
2862 data t_e_m_p;
2863 set &libname_in..&data. (obs=1 drop=&by. &id. &copy.);
2864 run;
2865
2866 proc sql noprint;
2867 select name
2868 into :var separated by " "
2869 from dictionary.columns
2870 where libname="WORK" and
2871 memname="T_E_M_P"
2872 %if %sysfunc(upcase("&autovars.")) eq "CHAR" %then %do;
2873 and type="char"
2874 %end;
2875 %else %if %sysfunc(upcase("&autovars.")) ne "ALL" %then %do;
2876 and type="num"
2877 %end;
2878 ;
2879 quit;
2880 %end;
2881
2882 /*Initialize macro variables*/
2883 %let vars_char=;
2884 %let varlist_char=;
2885 %let vars_num=;
2886 %let varlist_num=;
2887 %let formats_char=;
2888 %let format_char=;
2889 %let formats_num=;
2890 %let format_num=;
2891
2892 /*Create file t_e_m_p to contain one record with all var variables*/
2893 data t_e_m_p;
2894 set &libname_in..&data. (obs=1 keep=&var.);
2895 run;
2896
2897 /*Create macro variables containing untransposed var names and formats*/
2898 proc sql noprint;
2899 select name, case
2900 when missing(format) then " $"||strip(put(length,5.))||'.'
2901 else strip(format)
2902 end
2903 into :vars_char separated by " ",
2904 :formats_char separated by "~"
2905 from dictionary.columns
2906 where libname="WORK" and
2907 memname="T_E_M_P" and
2908 type="char"
2909 ;
2910 select name, case
2911 when missing(format) then "best12."
2912 else strip(format)
2913 end
2914 into :vars_num separated by " ",
2915 :formats_num separated by "~"
2916 from dictionary.columns
2917 where libname="WORK" and
2918 memname="T_E_M_P" and
2919 type="num"
2920 ;
2921 select name
2922 into :vars_all separated by " "
2923 from dictionary.columns
2924 where libname="WORK" and
2925 memname="T_E_M_P"
2926 ;
2927 quit;
2928
2929 /*If sort parameter has a value of YES, create a sorted temporary data file*/
2930 %if %sysfunc(upcase("&sort.")) eq "YES" %then %do;
2931 %let notsorted=;
2932 proc sort data=&libname_in..&data.
2933 (
2934 keep=&by. &id. &vars_char. &vars_num. &to_copy.
2935 &dsoptions.
2936 )
2937 out=t_e_m_p &sort_options. noequals;
2938 by &by.;
2939 run;
2940 %let data=t_e_m_p;
2941 %let libname_in=work;
2942 %end;
2943 %else %do;
2944 %let notsorted=notsorted;
2945 %end;
2946
2947 /*if no id parameter is present, create one from &newid.*/
2948 %if %length(&id.) eq 0 %then %do;
2949 data t_e_m_p;
2950 set &libname_in..&data.;
2951 by &by.;
2952 if first.&lastby then &newid.=1;
2953 else &newid+1;
2954 run;
2955 %let id=&newid.;
2956 %let data=t_e_m_p;
2957 %let libname_in=work;
2958 %end;
2959
2960 /*Ensure guessingrows parameter contains a value*/
2961 %if %length(&guessingrows.) eq 0 %then %do;
2962 %let guessingrows=%sysfunc(constant(EXACTINT));
2963 %end;
2964
2965 /*Ensure a format is assigned to an id variable*/
2966 %if %length(&id.) gt 0 %then %do;
2967 proc sql noprint;
2968 select type,length,%sysfunc(strip(format))
2969 into :tr_macro_type, :tr_macro_len, :tr_macro_format
2970 from dictionary.columns
2971 where libname="%sysfunc(upcase(&libname_in.))" and
2972 memname="%sysfunc(upcase(&data.))" and
2973 upcase(name)="%sysfunc(upcase(&id.))"
2974 ;
2975 quit;
2976
2977 %if %length(&format.) eq 0 %then %do;
2978 %let optsave=%sysfunc(getoption(missing),$quote.);
2979 options missing=.;
2980 %if %length(&tr_macro_format.) gt 0 %then %do;
2981 %let format=&tr_macro_format.;
2982 %end;
2983 %else %if "&tr_macro_type." eq "num " %then %do;
2984 %let format=%sysfunc(catt(best,&tr_macro_len.,%str(.)));
2985 %end;
2986 %else %do;
2987 %let format=%sysfunc(catt($,&tr_macro_len.,%str(.)));
2988 %end;
2989 options missing=&optsave;
2990 %end;
2991 %end;
2992
2993 /*Create macro variables containing ordered lists of the requested transposed variable
2994 names for character (varlist_char) and numeric (varlist_num) var variables */
2995 %if %length(&preloadfmt.) gt 0 %then %do;
2996 %if %sysfunc(countw(&preloadfmt.)) eq 1 %then %do;
2997 %let preloadfmt=&libname_in..&preloadfmt.;
2998 %end;
2999 %end;
3000 %else %do;
3001 %if %sysfunc(upcase("&sort.")) eq "YES" %then
3002 %let dsoptions=;
3003 proc freq data=&libname_in..&data. (obs=&guessingrows. keep=&id. &dsoptions.)
3004 noprint;
3005 tables &id./out=_for_format (keep=&id.);
3006 run;
3007 %if %sysfunc(upcase("&descendingid.")) eq "YES" %then %do;
3008 proc sort data=_for_format;
3009 by descending &id;
3010 run;
3011 %end;
3012 data _for_format;
3013 set _for_format;
3014 order=_n_;
3015 run;
3016 %end;
3017
3018 proc sql noprint;
3019 %do i=1 %to 2;
3020 %if &i. eq 1 %then %let i_type=char;
3021 %else %let i_type=num;
3022 %if %length(&&vars_&i_type.) gt 0 %then %do;
3023 select distinct
3024 %do j=1 %to 2;
3025 %if &j. eq 1 %then %let j_type=;
3026 %else %let j_type=format;
3027 %do k=1 %to %sysfunc(countw(&&vars_&i_type.));
3028 "&j_type. "||cats("&prefix.",
3029 %if %sysfunc(upcase("&var_first.")) eq "NO" %then %do;
3030 put(&id.,&format),"&delimiter."
3031 %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
3032 ,scan("&&vars_&i_type.",&k.);
3033 %end;
3034 %else %do;
3035 %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
3036 scan("&&vars_&i_type.",&k.),;
3037 "&delimiter.",put(&id.,&format)
3038 %end;
3039 )
3040 %if &j. eq 2 %then
3041 ||" "||cats(scan("&&formats_&i_type.",&k.,"~"),";");
3042 %if &k. lt %sysfunc(countw(&&vars_&i_type.)) %then ||;
3043 %else ,;
3044 %end;
3045 %end;
3046 %if "&tr_macro_type." eq "num " %then &id. format=best12.;
3047 %else &id.;
3048 ,order
3049 into :varlist_&i_type. separated by " ",
3050 :format_&i_type. separated by " ",
3051 :idlist separated by " ",
3052 :idorder separated by " "
3053 %if %length(&preloadfmt.) gt 0 %then from &preloadfmt.;
3054 %else from _for_format;
3055 order by order
3056 ;
3057 %let num_numlabels=&sqlobs.;
3058 %end;
3059 %end;
3060 quit;
3061
3062 proc sql noprint;
3063 select distinct
3064 %let j_type=;
3065 %do k=1 %to %sysfunc(countw(&&vars_all.));
3066 "&j_type. "||cats("&prefix.",
3067
3068 %if %sysfunc(upcase("&var_first.")) eq "NO" %then %do;
3069 put(&id.,&format),"&delimiter.",
3070 %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
3071 scan("&&vars_all.",&k.);
3072 )
3073 %end;
3074 %else %do;
3075 %if %sysfunc(upcase("&use_varname.")) ne "NO" %then
3076 scan("&&vars_all.",&k.),;
3077 "&delimiter.",put(&id.,&format))
3078 %end;
3079 %if &k. lt %sysfunc(countw(&&vars_all.)) %then ||;
3080 %else ,;
3081 %end;
3082 order
3083 into :varlist_all separated by " ",
3084 :idorder separated by " "
3085 %if %length(&preloadfmt.) gt 0 %then from &preloadfmt.;
3086 %else from _for_format;
3087 order by order
3088 ;
3089 quit;
3090
3091 /*Create a format that will be used to assign values to the transposed variables*/
3092 data _for_format;
3093 %if %length(&preloadfmt.) gt 0 %then set &preloadfmt. (rename=(&id.=start));
3094 %else set _for_format (rename=(&id.=start));
3095 ;
3096 %if "&tr_macro_type." eq "num " %then retain fmtname "labelfmt" type "N";
3097 %else retain fmtname "$labelfmt" type "C";
3098 ;
3099 label=
3100 %if %length(&preloadfmt.) eq 0 %then _n_-1;
3101 %else order-1;
3102 ;
3103 run;
3104
3105 proc format cntlin = _for_format;
3106 run ;
3107
3108 /*Create and run the datastep that does the transposition*/
3109 data &libname_out..&out.;
3110 set &libname_in..&data. (keep=&by. &id.
3111 %do i=1 %to %sysfunc(countw("&vars_char."));
3112 %scan(&vars_char.,&i.)
3113 %end;
3114 %do i=1 %to %sysfunc(countw("&vars_num."));
3115 %scan(&vars_num.,&i.)
3116 %end;
3117 %do i=1 %to %sysfunc(countw("&to_copy."));
3118 %scan(&to_copy.,&i.)
3119 %end;
3120 &dsoptions.
3121 );
3122 by &by. &notsorted.;
3123 &format_char. &format_num.
3124 %if %length(&vars_char.) gt 0 %then %do;
3125 array want_char(*) $
3126 %do i=1 %to %eval(&num_numlabels.*%sysfunc(countw("&vars_char.")));
3127 %scan(&varlist_char.,&i.)
3128 %end;
3129 ;
3130 array have_char(*) $ &vars_char.;
3131 retain want_char;
3132 if first.&lastby. then call missing(of want_char(*));
3133 ___nchar=put(&id.,labelfmt.)*dim(have_char);
3134 do ___i=1 to dim(have_char);
3135 want_char(___nchar+___i)=have_char(___i);
3136 end;
3137 %end;
3138 %if %length(&vars_num.) gt 0 %then %do;
3139 array want_num(*)
3140 %do i=1 %to %eval(&num_numlabels.*%sysfunc(countw("&vars_num.")));
3141 %scan(&varlist_num.,&i.)
3142 %end;
3143 ;
3144 array have_num(*) &vars_num.;
3145 retain want_num;
3146 if first.&lastby. then call missing(of want_num(*));
3147 ___nnum=put(&id.,labelfmt.)*dim(have_num);
3148 do ___i=1 to dim(have_num);
3149 want_num(___nnum+___i)=have_num(___i);
3150 end;
3151 %end;
3152 drop &id. ___: &var. &drop.;
3153 if last.&lastby. then output;
3154 run;
3155
3156 data &libname_out..&out.;
3157 retain &by. &to_copy. &varlist_all.;
3158 set &libname_out..&out.;
3159 run;
3160
3161 /*Delete all temporary files*/
3162 proc delete data=work.t_e_m_p work._for_format;
3163 run;
3164
3165 %mend transpose;
3166 options NOQUOTELENMAX;
3167 proc sort data=have out=need nodupkey;
3168 by time_m sym_root;
3169 run;

NOTE: There were 179219 observations read from the data set WORK.HAVE.
NOTE: 13934 observations with duplicate key values were deleted.
NOTE: The data set WORK.NEED has 165285 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.07 seconds
cpu time 0.12 seconds

3170
3171 %transpose(data=need, out=want, by=time_m, id=sym_root,
3172 delimiter=_,var=price size)

NOTE: There were 1 observations read from the data set WORK.NEED.
NOTE: The data set WORK.T_E_M_P has 1 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

NOTE: No rows were selected.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: There were 165285 observations read from the data set WORK.NEED.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 1 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.08 seconds
cpu time 0.06 seconds

NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.
NOTE: The data set WORK._FOR_FORMAT has 471 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

ERROR: These two ranges overlap: LOW-LOW and A-A (fuzz=0).

WARNING: RUN statement ignored due to previous errors. Submit QUIT; to terminate the procedure.
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 471 observations read from the data set WORK._FOR_FORMAT.

NOTE: Line generated by the invoked macro "TRANSPOSE".
1997 ; array have_num(*) &vars_num.; retain want_num; if first.&lastby. then
1997! call missing(of want_num(*)); ___nnum=put(&id.,labelfmt.)*dim(have_num); do
---------
48
1997! ___i=1 to dim(have_num); want_num(___nnum+___i)=have_num(___i); end;

ERROR 48-59: The format $LABELFMT was not found or could not be loaded.

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
1997:132
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.WANT may be incomplete. When this step was stopped there were 0
observations and 943 variables.
WARNING: Data set WORK.WANT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.68 seconds
cpu time 0.67 seconds

NOTE: Variable time_m is uninitialized.
NOTE: Variable SIZE_A is uninitialized.
NOTE: Variable PRICE_A is uninitialized.
NOTE: Variable SIZE_AA is uninitialized.
NOTE: Variable PRICE_AA is uninitialized.
NOTE: Variable SIZE_AAPL is uninitialized.
NOTE: Variable PRICE_AAPL is uninitialized.
NOTE: Variable SIZE_ABC is uninitialized.
NOTE: Variable PRICE_ABC is uninitialized.
NOTE: Variable SIZE_ABT is uninitialized.
NOTE: Variable PRICE_ABT is uninitialized.
NOTE: Variable SIZE_ADBE is uninitialized.
NOTE: Variable PRICE_ADBE is uninitialized.
NOTE: Variable SIZE_ADI is uninitialized.
NOTE: Variable PRICE_ADI is uninitialized.
NOTE: Variable SIZE_ADM is uninitialized.
NOTE: Variable PRICE_ADM is uninitialized.
NOTE: Variable SIZE_ADP is uninitialized.
NOTE: Variable PRICE_ADP is uninitialized.
NOTE: Variable SIZE_ADSK is uninitialized.
NOTE: Variable PRICE_ADSK is uninitialized.
NOTE: Variable SIZE_AEE is uninitialized.
NOTE: Variable PRICE_AEE is uninitialized.
NOTE: Variable SIZE_AEP is uninitialized.
NOTE: Variable PRICE_AEP is uninitialized.
NOTE: Variable SIZE_AES is uninitialized.
NOTE: Variable PRICE_AES is uninitialized.
NOTE: Variable SIZE_AET is uninitialized.
NOTE: Variable PRICE_AET is uninitialized.
NOTE: Variable SIZE_AFL is uninitialized.
NOTE: Variable PRICE_AFL is uninitialized.
NOTE: Variable SIZE_AGN is uninitialized.
NOTE: Variable PRICE_AGN is uninitialized.
NOTE: Variable SIZE_AIG is uninitialized.
NOTE: Variable PRICE_AIG is uninitialized.
NOTE: Variable SIZE_AIV is uninitialized.
NOTE: Variable PRICE_AIV is uninitialized.
NOTE: Variable SIZE_AIZ is uninitialized.
NOTE: Variable PRICE_AIZ is uninitialized.
NOTE: Variable SIZE_AKAM is uninitialized.
NOTE: Variable PRICE_AKAM is uninitialized.
NOTE: Variable SIZE_AKS is uninitialized.
NOTE: Variable PRICE_AKS is uninitialized.
NOTE: Variable SIZE_ALL is uninitialized.
NOTE: Variable PRICE_ALL is uninitialized.
NOTE: Variable SIZE_ALTR is uninitialized.
NOTE: Variable PRICE_ALTR is uninitialized.
NOTE: Variable SIZE_AMAT is uninitialized.
NOTE: Variable PRICE_AMAT is uninitialized.
NOTE: Variable SIZE_AMD is uninitialized.
NOTE: Variable PRICE_AMD is uninitialized.
NOTE: Variable SIZE_AMGN is uninitialized.
NOTE: Variable PRICE_AMGN is uninitialized.
NOTE: Variable SIZE_AMP is uninitialized.
NOTE: Variable PRICE_AMP is uninitialized.
NOTE: Variable SIZE_AMT is uninitialized.
NOTE: Variable PRICE_AMT is uninitialized.
NOTE: Variable SIZE_AMZN is uninitialized.
NOTE: Variable PRICE_AMZN is uninitialized.
NOTE: Variable SIZE_AN is uninitialized.
NOTE: Variable PRICE_AN is uninitialized.
NOTE: Variable SIZE_ANF is uninitialized.
NOTE: Variable PRICE_ANF is uninitialized.
NOTE: Variable SIZE_AON is uninitialized.
NOTE: Variable PRICE_AON is uninitialized.
NOTE: Variable SIZE_APA is uninitialized.
NOTE: Variable PRICE_APA is uninitialized.
NOTE: Variable SIZE_APC is uninitialized.
NOTE: Variable PRICE_APC is uninitialized.
NOTE: Variable SIZE_APD is uninitialized.
NOTE: Variable PRICE_APD is uninitialized.
NOTE: Variable SIZE_APH is uninitialized.
NOTE: Variable PRICE_APH is uninitialized.
NOTE: Variable SIZE_APOL is uninitialized.
NOTE: Variable PRICE_APOL is uninitialized.
NOTE: Variable SIZE_ARG is uninitialized.
NOTE: Variable PRICE_ARG is uninitialized.
NOTE: Variable SIZE_ATI is uninitialized.
NOTE: Variable PRICE_ATI is uninitialized.
NOTE: Variable SIZE_AVB is uninitialized.
NOTE: Variable PRICE_AVB is uninitialized.
NOTE: Variable SIZE_AVP is uninitialized.
NOTE: Variable PRICE_AVP is uninitialized.
NOTE: Variable SIZE_AVY is uninitialized.
NOTE: Variable PRICE_AVY is uninitialized.
NOTE: Variable SIZE_AXP is uninitialized.
NOTE: Variable PRICE_AXP is uninitialized.
NOTE: Variable SIZE_AYE is uninitialized.
NOTE: Variable PRICE_AYE is uninitialized.
NOTE: Variable SIZE_AZO is uninitialized.
NOTE: Variable PRICE_AZO is uninitialized.
NOTE: Variable SIZE_BA is uninitialized.
NOTE: Variable PRICE_BA is uninitialized.
NOTE: Variable SIZE_BAC is uninitialized.
NOTE: Variable PRICE_BAC is uninitialized.
NOTE: Variable SIZE_BAX is uninitialized.
NOTE: Variable PRICE_BAX is uninitialized.
NOTE: Variable SIZE_BBBY is uninitialized.
NOTE: Variable PRICE_BBBY is uninitialized.
NOTE: Variable SIZE_BBT is uninitialized.
NOTE: Variable PRICE_BBT is uninitialized.
NOTE: Variable SIZE_BBY is uninitialized.
NOTE: Variable PRICE_BBY is uninitialized.
NOTE: Variable SIZE_BCR is uninitialized.
NOTE: Variable PRICE_BCR is uninitialized.
NOTE: Variable SIZE_BDX is uninitialized.
NOTE: Variable PRICE_BDX is uninitialized.
NOTE: Variable SIZE_BEN is uninitialized.
NOTE: Variable PRICE_BEN is uninitialized.
NOTE: Variable SIZE_BHI is uninitialized.
NOTE: Variable PRICE_BHI is uninitialized.
NOTE: Variable SIZE_BIG is uninitialized.
NOTE: Variable PRICE_BIG is uninitialized.
NOTE: Variable SIZE_BIIB is uninitialized.
NOTE: Variable PRICE_BIIB is uninitialized.
NOTE: Variable SIZE_BK is uninitialized.
NOTE: Variable PRICE_BK is uninitialized.
NOTE: Variable SIZE_BLL is uninitialized.
NOTE: Variable PRICE_BLL is uninitialized.
NOTE: Variable SIZE_BMC is uninitialized.
NOTE: Variable PRICE_BMC is uninitialized.
NOTE: Variable SIZE_BMS is uninitialized.
NOTE: Variable PRICE_BMS is uninitialized.
NOTE: Variable SIZE_BMY is uninitialized.
NOTE: Variable PRICE_BMY is uninitialized.
NOTE: Variable SIZE_BRCM is uninitialized.
NOTE: Variable PRICE_BRCM is uninitialized.
NOTE: Variable SIZE_BSX is uninitialized.
NOTE: Variable PRICE_BSX is uninitialized.
NOTE: Variable SIZE_BTU is uninitialized.
NOTE: Variable PRICE_BTU is uninitialized.
NOTE: Variable SIZE_BXP is uninitialized.
NOTE: Variable PRICE_BXP is uninitialized.
NOTE: Variable SIZE_C is uninitialized.
NOTE: Variable PRICE_C is uninitialized.
NOTE: Variable SIZE_CA is uninitialized.
NOTE: Variable PRICE_CA is uninitialized.
NOTE: Variable SIZE_CAG is uninitialized.
NOTE: Variable PRICE_CAG is uninitialized.
NOTE: Variable SIZE_CAH is uninitialized.
NOTE: Variable PRICE_CAH is uninitialized.
NOTE: Variable SIZE_CAM is uninitialized.
NOTE: Variable PRICE_CAM is uninitialized.
NOTE: Variable SIZE_CAT is uninitialized.
NOTE: Variable PRICE_CAT is uninitialized.
NOTE: Variable SIZE_CB is uninitialized.
NOTE: Variable PRICE_CB is uninitialized.
NOTE: Variable SIZE_CBG is uninitialized.
NOTE: Variable PRICE_CBG is uninitialized.
NOTE: Variable SIZE_CBS is uninitialized.
NOTE: Variable PRICE_CBS is uninitialized.
NOTE: Variable SIZE_CCE is uninitialized.
NOTE: Variable PRICE_CCE is uninitialized.
NOTE: Variable SIZE_CCL is uninitialized.
NOTE: Variable PRICE_CCL is uninitialized.
NOTE: Variable SIZE_CEG is uninitialized.
NOTE: Variable PRICE_CEG is uninitialized.
NOTE: Variable SIZE_CELG is uninitialized.
NOTE: Variable PRICE_CELG is uninitialized.
NOTE: Variable SIZE_CEPH is uninitialized.
NOTE: Variable PRICE_CEPH is uninitialized.
NOTE: Variable SIZE_CF is uninitialized.
NOTE: Variable PRICE_CF is uninitialized.
NOTE: Variable SIZE_CFN is uninitialized.
NOTE: Variable PRICE_CFN is uninitialized.
NOTE: Variable SIZE_CHK is uninitialized.
NOTE: Variable PRICE_CHK is uninitialized.
NOTE: Variable SIZE_CHRW is uninitialized.
NOTE: Variable PRICE_CHRW is uninitialized.
NOTE: Variable SIZE_CI is uninitialized.
NOTE: Variable PRICE_CI is uninitialized.
NOTE: Variable SIZE_CINF is uninitialized.
NOTE: Variable PRICE_CINF is uninitialized.
NOTE: Variable SIZE_CL is uninitialized.
NOTE: Variable PRICE_CL is uninitialized.
NOTE: Variable SIZE_CLF is uninitialized.
NOTE: Variable PRICE_CLF is uninitialized.
NOTE: Variable SIZE_CLX is uninitialized.
NOTE: Variable PRICE_CLX is uninitialized.
NOTE: Variable SIZE_CMA is uninitialized.
NOTE: Variable PRICE_CMA is uninitialized.
NOTE: Variable SIZE_CME is uninitialized.
NOTE: Variable PRICE_CME is uninitialized.
NOTE: Variable SIZE_CMI is uninitialized.
NOTE: Variable PRICE_CMI is uninitialized.
NOTE: Variable SIZE_CMS is uninitialized.
NOTE: Variable PRICE_CMS is uninitialized.
NOTE: Variable SIZE_CNP is uninitialized.
NOTE: Variable PRICE_CNP is uninitialized.
NOTE: Variable SIZE_CNX is uninitialized.
NOTE: Variable PRICE_CNX is uninitialized.
NOTE: Variable SIZE_COF is uninitialized.
NOTE: Variable PRICE_COF is uninitialized.
NOTE: Variable SIZE_COG is uninitialized.
NOTE: Variable PRICE_COG is uninitialized.
NOTE: Variable SIZE_COH is uninitialized.
NOTE: Variable PRICE_COH is uninitialized.
NOTE: Variable SIZE_COL is uninitialized.
NOTE: Variable PRICE_COL is uninitialized.
NOTE: Variable SIZE_COP is uninitialized.
NOTE: Variable PRICE_COP is uninitialized.
NOTE: Variable SIZE_COST is uninitialized.
NOTE: Variable PRICE_COST is uninitialized.
NOTE: Variable SIZE_CPB is uninitialized.
NOTE: Variable PRICE_CPB is uninitialized.
NOTE: Variable SIZE_CPWR is uninitialized.
NOTE: Variable PRICE_CPWR is uninitialized.
NOTE: Variable SIZE_CRM is uninitialized.
NOTE: Variable PRICE_CRM is uninitialized.
NOTE: Variable SIZE_CSC is uninitialized.
NOTE: Variable PRICE_CSC is uninitialized.
NOTE: Variable SIZE_CSCO is uninitialized.
NOTE: Variable PRICE_CSCO is uninitialized.
NOTE: Variable SIZE_CSX is uninitialized.
NOTE: Variable PRICE_CSX is uninitialized.
NOTE: Variable SIZE_CTAS is uninitialized.
NOTE: Variable PRICE_CTAS is uninitialized.
NOTE: Variable SIZE_CTL is uninitialized.
NOTE: Variable PRICE_CTL is uninitialized.
NOTE: Variable SIZE_CTSH is uninitialized.
NOTE: Variable PRICE_CTSH is uninitialized.
NOTE: Variable SIZE_CTXS is uninitialized.
NOTE: Variable PRICE_CTXS is uninitialized.
NOTE: Variable SIZE_CVH is uninitialized.
NOTE: Variable PRICE_CVH is uninitialized.
NOTE: Variable SIZE_CVS is uninitialized.
NOTE: Variable PRICE_CVS is uninitialized.
NOTE: Variable SIZE_CVX is uninitialized.
NOTE: Variable PRICE_CVX is uninitialized.
NOTE: Variable SIZE_D is uninitialized.
NOTE: Variable PRICE_D is uninitialized.
NOTE: Variable SIZE_DD is uninitialized.
NOTE: Variable PRICE_DD is uninitialized.
NOTE: Variable SIZE_DE is uninitialized.
NOTE: Variable PRICE_DE is uninitialized.
NOTE: Variable SIZE_DELL is uninitialized.
NOTE: Variable PRICE_DELL is uninitialized.
NOTE: Variable SIZE_DF is uninitialized.
NOTE: Variable PRICE_DF is uninitialized.
NOTE: Variable SIZE_DFS is uninitialized.
NOTE: Variable PRICE_DFS is uninitialized.
NOTE: Variable SIZE_DGX is uninitialized.
NOTE: Variable PRICE_DGX is uninitialized.
NOTE: Variable SIZE_DHI is uninitialized.
NOTE: Variable PRICE_DHI is uninitialized.
NOTE: Variable SIZE_DHR is uninitialized.
NOTE: Variable PRICE_DHR is uninitialized.
NOTE: Variable SIZE_DIS is uninitialized.
NOTE: Variable PRICE_DIS is uninitialized.
NOTE: Variable SIZE_DNB is uninitialized.
NOTE: Variable PRICE_DNB is uninitialized.
NOTE: Variable SIZE_DNR is uninitialized.
NOTE: Variable PRICE_DNR is uninitialized.
NOTE: Variable SIZE_DO is uninitialized.
NOTE: Variable PRICE_DO is uninitialized.
NOTE: Variable SIZE_DOV is uninitialized.
NOTE: Variable PRICE_DOV is uninitialized.
NOTE: Variable SIZE_DOW is uninitialized.
NOTE: Variable PRICE_DOW is uninitialized.
NOTE: Variable SIZE_DPS is uninitialized.
NOTE: Variable PRICE_DPS is uninitialized.
NOTE: Variable SIZE_DRI is uninitialized.
NOTE: Variable PRICE_DRI is uninitialized.
NOTE: Variable SIZE_DTE is uninitialized.
NOTE: Variable PRICE_DTE is uninitialized.
NOTE: Variable SIZE_DTV is uninitialized.
NOTE: Variable PRICE_DTV is uninitialized.
NOTE: Variable SIZE_DUK is uninitialized.
NOTE: Variable PRICE_DUK is uninitialized.
NOTE: Variable SIZE_DV is uninitialized.
NOTE: Variable PRICE_DV is uninitialized.
NOTE: Variable SIZE_DVA is uninitialized.
NOTE: Variable PRICE_DVA is uninitialized.
NOTE: Variable SIZE_DVN is uninitialized.
NOTE: Variable PRICE_DVN is uninitialized.
NOTE: Variable SIZE_EBAY is uninitialized.
NOTE: Variable PRICE_EBAY is uninitialized.
NOTE: Variable SIZE_ECL is uninitialized.
NOTE: Variable PRICE_ECL is uninitialized.
NOTE: Variable SIZE_ED is uninitialized.
NOTE: Variable PRICE_ED is uninitialized.
NOTE: Variable SIZE_EFX is uninitialized.
NOTE: Variable PRICE_EFX is uninitialized.
NOTE: Variable SIZE_EIX is uninitialized.
NOTE: Variable PRICE_EIX is uninitialized.
NOTE: Variable SIZE_EL is uninitialized.
NOTE: Variable PRICE_EL is uninitialized.
NOTE: Variable SIZE_EMC is uninitialized.
NOTE: Variable PRICE_EMC is uninitialized.
NOTE: Variable SIZE_EMN is uninitialized.
NOTE: Variable PRICE_EMN is uninitialized.
NOTE: Variable SIZE_EMR is uninitialized.
NOTE: Variable PRICE_EMR is uninitialized.
NOTE: Variable SIZE_EOG is uninitialized.
NOTE: Variable PRICE_EOG is uninitialized.
NOTE: Variable SIZE_EP is uninitialized.
NOTE: Variable PRICE_EP is uninitialized.
NOTE: Variable SIZE_EQR is uninitialized.
NOTE: Variable PRICE_EQR is uninitialized.
NOTE: Variable SIZE_EQT is uninitialized.
NOTE: Variable PRICE_EQT is uninitialized.
NOTE: Variable SIZE_ES is uninitialized.
NOTE: Variable PRICE_ES is uninitialized.
NOTE: Variable SIZE_ESRX is uninitialized.
NOTE: Variable PRICE_ESRX is uninitialized.
NOTE: Variable SIZE_ETFC is uninitialized.
NOTE: Variable PRICE_ETFC is uninitialized.
NOTE: Variable SIZE_ETN is uninitialized.
NOTE: Variable PRICE_ETN is uninitialized.
NOTE: Variable SIZE_ETR is uninitialized.
NOTE: Variable PRICE_ETR is uninitialized.
NOTE: Variable SIZE_EXC is uninitialized.
NOTE: Variable PRICE_EXC is uninitialized.
NOTE: Variable SIZE_EXPD is uninitialized.
NOTE: Variable PRICE_EXPD is uninitialized.
NOTE: Variable SIZE_EXPE is uninitialized.
NOTE: Variable PRICE_EXPE is uninitialized.
NOTE: Variable SIZE_F is uninitialized.
NOTE: Variable PRICE_F is uninitialized.
NOTE: Variable SIZE_FAST is uninitialized.
NOTE: Variable PRICE_FAST is uninitialized.
NOTE: Variable SIZE_FCX is uninitialized.
NOTE: Variable PRICE_FCX is uninitialized.
NOTE: Variable SIZE_FDO is uninitialized.
NOTE: Variable PRICE_FDO is uninitialized.
NOTE: Variable SIZE_FDX is uninitialized.
NOTE: Variable PRICE_FDX is uninitialized.
NOTE: Variable SIZE_FE is uninitialized.
NOTE: Variable PRICE_FE is uninitialized.
NOTE: Variable SIZE_FHN is uninitialized.
NOTE: Variable PRICE_FHN is uninitialized.
NOTE: Variable SIZE_FII is uninitialized.
NOTE: Variable PRICE_FII is uninitialized.
NOTE: Variable SIZE_FIS is uninitialized.
NOTE: Variable PRICE_FIS is uninitialized.
NOTE: Variable SIZE_FISV is uninitialized.
NOTE: Variable PRICE_FISV is uninitialized.
NOTE: Variable SIZE_FITB is uninitialized.
NOTE: Variable PRICE_FITB is uninitialized.
NOTE: Variable SIZE_FLIR is uninitialized.
NOTE: Variable PRICE_FLIR is uninitialized.
NOTE: Variable SIZE_FLR is uninitialized.
NOTE: Variable PRICE_FLR is uninitialized.
NOTE: Variable SIZE_FLS is uninitialized.
NOTE: Variable PRICE_FLS is uninitialized.
NOTE: Variable SIZE_FMC is uninitialized.
NOTE: Variable PRICE_FMC is uninitialized.
NOTE: Variable SIZE_FRX is uninitialized.
NOTE: Variable PRICE_FRX is uninitialized.
NOTE: Variable SIZE_FSLR is uninitialized.
NOTE: Variable PRICE_FSLR is uninitialized.
NOTE: Variable SIZE_FTI is uninitialized.
NOTE: Variable PRICE_FTI is uninitialized.
NOTE: Variable SIZE_FTR is uninitialized.
NOTE: Variable PRICE_FTR is uninitialized.
NOTE: Variable SIZE_GAS is uninitialized.
NOTE: Variable PRICE_GAS is uninitialized.
NOTE: Variable SIZE_GD is uninitialized.
NOTE: Variable PRICE_GD is uninitialized.
NOTE: Variable SIZE_GE is uninitialized.
NOTE: Variable PRICE_GE is uninitialized.
NOTE: Variable SIZE_GENZ is uninitialized.
NOTE: Variable PRICE_GENZ is uninitialized.
NOTE: Variable SIZE_GILD is uninitialized.
NOTE: Variable PRICE_GILD is uninitialized.
NOTE: Variable SIZE_GIS is uninitialized.
NOTE: Variable PRICE_GIS is uninitialized.
NOTE: Variable SIZE_GLW is uninitialized.
NOTE: Variable PRICE_GLW is uninitialized.
NOTE: Variable SIZE_GME is uninitialized.
NOTE: Variable PRICE_GME is uninitialized.
NOTE: Variable SIZE_GNW is uninitialized.
NOTE: Variable PRICE_GNW is uninitialized.
NOTE: Variable SIZE_GPC is uninitialized.
NOTE: Variable PRICE_GPC is uninitialized.
NOTE: Variable SIZE_GPS is uninitialized.
NOTE: Variable PRICE_GPS is uninitialized.
NOTE: Variable SIZE_GR is uninitialized.
NOTE: Variable PRICE_GR is uninitialized.
NOTE: Variable SIZE_GS is uninitialized.
NOTE: Variable PRICE_GS is uninitialized.
NOTE: Variable SIZE_GT is uninitialized.
NOTE: Variable PRICE_GT is uninitialized.
NOTE: Variable SIZE_GWW is uninitialized.
NOTE: Variable PRICE_GWW is uninitialized.
NOTE: Variable SIZE_HAL is uninitialized.
NOTE: Variable PRICE_HAL is uninitialized.
NOTE: Variable SIZE_HAR is uninitialized.
NOTE: Variable PRICE_HAR is uninitialized.
NOTE: Variable SIZE_HAS is uninitialized.
NOTE: Variable PRICE_HAS is uninitialized.
NOTE: Variable SIZE_HBAN is uninitialized.
NOTE: Variable PRICE_HBAN is uninitialized.
NOTE: Variable SIZE_HCBK is uninitialized.
NOTE: Variable PRICE_HCBK is uninitialized.
NOTE: Variable SIZE_HCN is uninitialized.
NOTE: Variable PRICE_HCN is uninitialized.
NOTE: Variable SIZE_HCP is uninitialized.
NOTE: Variable PRICE_HCP is uninitialized.
NOTE: Variable SIZE_HD is uninitialized.
NOTE: Variable PRICE_HD is uninitialized.
NOTE: Variable SIZE_HES is uninitialized.
NOTE: Variable PRICE_HES is uninitialized.
NOTE: Variable SIZE_HIG is uninitialized.
NOTE: Variable PRICE_HIG is uninitialized.
NOTE: Variable SIZE_HOG is uninitialized.
NOTE: Variable PRICE_HOG is uninitialized.
NOTE: Variable SIZE_HON is uninitialized.
NOTE: Variable PRICE_HON is uninitialized.
NOTE: Variable SIZE_HOT is uninitialized.
NOTE: Variable PRICE_HOT is uninitialized.
NOTE: Variable SIZE_HP is uninitialized.
NOTE: Variable PRICE_HP is uninitialized.
NOTE: Variable SIZE_HPQ is uninitialized.
NOTE: Variable PRICE_HPQ is uninitialized.
NOTE: Variable SIZE_HRB is uninitialized.
NOTE: Variable PRICE_HRB is uninitialized.
NOTE: Variable SIZE_HRL is uninitialized.
NOTE: Variable PRICE_HRL is uninitialized.
NOTE: Variable SIZE_HRS is uninitialized.
NOTE: Variable PRICE_HRS is uninitialized.
NOTE: Variable SIZE_HS is uninitialized.
NOTE: Variable PRICE_HS is uninitialized.
NOTE: Variable SIZE_HSP is uninitialized.
NOTE: Variable PRICE_HSP is uninitialized.
NOTE: Variable SIZE_HST is uninitialized.
NOTE: Variable PRICE_HST is uninitialized.
NOTE: Variable SIZE_HUM is uninitialized.
NOTE: Variable PRICE_HUM is uninitialized.
NOTE: Variable SIZE_IBM is uninitialized.
NOTE: Variable PRICE_IBM is uninitialized.
NOTE: Variable SIZE_ICE is uninitialized.
NOTE: Variable PRICE_ICE is uninitialized.
NOTE: Variable SIZE_IFF is uninitialized.
NOTE: Variable PRICE_IFF is uninitialized.
NOTE: Variable SIZE_IGT is uninitialized.
NOTE: Variable PRICE_IGT is uninitialized.
NOTE: Variable SIZE_IMS is uninitialized.
NOTE: Variable PRICE_IMS is uninitialized.
NOTE: Variable SIZE_INTC is uninitialized.
NOTE: Variable PRICE_INTC is uninitialized.
NOTE: Variable SIZE_INTU is uninitialized.
NOTE: Variable PRICE_INTU is uninitialized.
NOTE: Variable SIZE_IP is uninitialized.
NOTE: Variable PRICE_IP is uninitialized.
NOTE: Variable SIZE_IPG is uninitialized.
NOTE: Variable PRICE_IPG is uninitialized.
NOTE: Variable SIZE_IRM is uninitialized.
NOTE: Variable PRICE_IRM is uninitialized.
NOTE: Variable SIZE_ISRG is uninitialized.
NOTE: Variable PRICE_ISRG is uninitialized.
NOTE: Variable SIZE_ITT is uninitialized.
NOTE: Variable PRICE_ITT is uninitialized.
NOTE: Variable SIZE_ITW is uninitialized.
NOTE: Variable PRICE_ITW is uninitialized.
NOTE: Variable SIZE_IVZ is uninitialized.
NOTE: Variable PRICE_IVZ is uninitialized.
NOTE: Variable SIZE_JBL is uninitialized.
NOTE: Variable PRICE_JBL is uninitialized.
NOTE: Variable SIZE_JCI is uninitialized.
NOTE: Variable PRICE_JCI is uninitialized.
NOTE: Variable SIZE_JCP is uninitialized.
NOTE: Variable PRICE_JCP is uninitialized.
NOTE: Variable SIZE_JEC is uninitialized.
NOTE: Variable PRICE_JEC is uninitialized.
NOTE: Variable SIZE_JNJ is uninitialized.
NOTE: Variable PRICE_JNJ is uninitialized.
NOTE: Variable SIZE_JNPR is uninitialized.
NOTE: Variable PRICE_JNPR is uninitialized.
NOTE: Variable SIZE_JNS is uninitialized.
NOTE: Variable PRICE_JNS is uninitialized.
NOTE: Variable SIZE_JPM is uninitialized.
NOTE: Variable PRICE_JPM is uninitialized.
NOTE: Variable SIZE_JWN is uninitialized.
NOTE: Variable PRICE_JWN is uninitialized.
NOTE: Variable SIZE_K is uninitialized.
NOTE: Variable PRICE_K is uninitialized.
NOTE: Variable SIZE_KEY is uninitialized.
NOTE: Variable PRICE_KEY is uninitialized.
NOTE: Variable SIZE_KG is uninitialized.
NOTE: Variable PRICE_KG is uninitialized.
NOTE: Variable SIZE_KIM is uninitialized.
NOTE: Variable PRICE_KIM is uninitialized.
NOTE: Variable SIZE_KLAC is uninitialized.
NOTE: Variable PRICE_KLAC is uninitialized.
NOTE: Variable SIZE_KMB is uninitialized.
NOTE: Variable PRICE_KMB is uninitialized.
NOTE: Variable SIZE_KO is uninitialized.
NOTE: Variable PRICE_KO is uninitialized.
NOTE: Variable SIZE_KR is uninitialized.
NOTE: Variable PRICE_KR is uninitialized.
NOTE: Variable SIZE_KSS is uninitialized.
NOTE: Variable PRICE_KSS is uninitialized.
NOTE: Variable SIZE_L is uninitialized.
NOTE: Variable PRICE_L is uninitialized.
NOTE: Variable SIZE_LB is uninitialized.
NOTE: Variable PRICE_LB is uninitialized.
NOTE: Variable SIZE_LEG is uninitialized.
NOTE: Variable PRICE_LEG is uninitialized.
NOTE: Variable SIZE_LEN is uninitialized.
NOTE: Variable PRICE_LEN is uninitialized.
NOTE: Variable SIZE_LH is uninitialized.
NOTE: Variable PRICE_LH is uninitialized.
NOTE: Variable SIZE_LIFE is uninitialized.
NOTE: Variable PRICE_LIFE is uninitialized.
NOTE: Variable SIZE_LLL is uninitialized.
NOTE: Variable PRICE_LLL is uninitialized.
NOTE: Variable SIZE_LLTC is uninitialized.
NOTE: Variable PRICE_LLTC is uninitialized.
NOTE: Variable SIZE_LLY is uninitialized.
NOTE: Variable PRICE_LLY is uninitialized.
NOTE: Variable SIZE_LM is uninitialized.
NOTE: Variable PRICE_LM is uninitialized.
NOTE: Variable SIZE_LMT is uninitialized.
NOTE: Variable PRICE_LMT is uninitialized.
NOTE: Variable SIZE_LNC is uninitialized.
NOTE: Variable PRICE_LNC is uninitialized.
NOTE: Variable SIZE_LO is uninitialized.
NOTE: Variable PRICE_LO is uninitialized.
NOTE: Variable SIZE_LOW is uninitialized.
NOTE: Variable PRICE_LOW is uninitialized.
NOTE: Variable SIZE_LSI is uninitialized.
NOTE: Variable PRICE_LSI is uninitialized.
NOTE: Variable SIZE_LUK is uninitialized.
NOTE: Variable PRICE_LUK is uninitialized.
NOTE: Variable SIZE_LUV is uninitialized.
NOTE: Variable PRICE_LUV is uninitialized.
NOTE: Variable SIZE_LXK is uninitialized.
NOTE: Variable PRICE_LXK is uninitialized.
NOTE: Variable SIZE_M is uninitialized.
NOTE: Variable PRICE_M is uninitialized.
NOTE: Variable SIZE_MA is uninitialized.
NOTE: Variable PRICE_MA is uninitialized.
NOTE: Variable SIZE_MAR is uninitialized.
NOTE: Variable PRICE_MAR is uninitialized.
NOTE: Variable SIZE_MAS is uninitialized.
NOTE: Variable PRICE_MAS is uninitialized.
NOTE: Variable SIZE_MAT is uninitialized.
NOTE: Variable PRICE_MAT is uninitialized.
NOTE: Variable SIZE_MCD is uninitialized.
NOTE: Variable PRICE_MCD is uninitialized.
NOTE: Variable SIZE_MCHP is uninitialized.
NOTE: Variable PRICE_MCHP is uninitialized.
NOTE: Variable SIZE_MCK is uninitialized.
NOTE: Variable PRICE_MCK is uninitialized.
NOTE: Variable SIZE_MCO is uninitialized.
NOTE: Variable PRICE_MCO is uninitialized.
NOTE: Variable SIZE_MDP is uninitialized.
NOTE: Variable PRICE_MDP is uninitialized.
NOTE: Variable SIZE_MDT is uninitialized.
NOTE: Variable PRICE_MDT is uninitialized.
NOTE: Variable SIZE_MEE is uninitialized.
NOTE: Variable PRICE_MEE is uninitialized.
NOTE: Variable SIZE_MET is uninitialized.
NOTE: Variable PRICE_MET is uninitialized.
NOTE: Variable SIZE_MFE is uninitialized.
NOTE: Variable PRICE_MFE is uninitialized.
NOTE: Variable SIZE_MHS is uninitialized.
NOTE: Variable PRICE_MHS is uninitialized.
NOTE: Variable SIZE_MI is uninitialized.
NOTE: Variable PRICE_MI is uninitialized.
NOTE: Variable SIZE_MIL is uninitialized.
NOTE: Variable PRICE_MIL is uninitialized.
NOTE: Variable SIZE_MJN is uninitialized.
NOTE: Variable PRICE_MJN is uninitialized.
NOTE: Variable SIZE_MKC is uninitialized.
NOTE: Variable PRICE_MKC is uninitialized.
NOTE: Variable SIZE_MMC is uninitialized.
NOTE: Variable PRICE_MMC is uninitialized.
NOTE: Variable SIZE_MMM is uninitialized.
NOTE: Variable PRICE_MMM is uninitialized.
NOTE: Variable SIZE_MO is uninitialized.
NOTE: Variable PRICE_MO is uninitialized.
NOTE: Variable SIZE_MOLX is uninitialized.
NOTE: Variable PRICE_MOLX is uninitialized.
NOTE: Variable SIZE_MON is uninitialized.
NOTE: Variable PRICE_MON is uninitialized.
NOTE: Variable SIZE_MRK is uninitialized.
NOTE: Variable PRICE_MRK is uninitialized.
NOTE: Variable SIZE_MRO is uninitialized.
NOTE: Variable PRICE_MRO is uninitialized.
NOTE: Variable SIZE_MS is uninitialized.
NOTE: Variable PRICE_MS is uninitialized.
NOTE: Variable SIZE_MSFT is uninitialized.
NOTE: Variable PRICE_MSFT is uninitialized.
NOTE: Variable SIZE_MTB is uninitialized.
NOTE: Variable PRICE_MTB is uninitialized.
NOTE: Variable SIZE_MU is uninitialized.
NOTE: Variable PRICE_MU is uninitialized.
NOTE: Variable SIZE_MUR is uninitialized.
NOTE: Variable PRICE_MUR is uninitialized.
NOTE: Variable SIZE_MWV is uninitialized.
NOTE: Variable PRICE_MWV is uninitialized.
NOTE: Variable SIZE_MWW is uninitialized.
NOTE: Variable PRICE_MWW is uninitialized.
NOTE: Variable SIZE_MYL is uninitialized.
NOTE: Variable PRICE_MYL is uninitialized.
NOTE: Variable SIZE_NAVI is uninitialized.
NOTE: Variable PRICE_NAVI is uninitialized.
NOTE: Variable SIZE_NBL is uninitialized.
NOTE: Variable PRICE_NBL is uninitialized.
NOTE: Variable SIZE_NBR is uninitialized.
NOTE: Variable PRICE_NBR is uninitialized.
NOTE: Variable SIZE_NDAQ is uninitialized.
NOTE: Variable PRICE_NDAQ is uninitialized.
NOTE: Variable SIZE_NEM is uninitialized.
NOTE: Variable PRICE_NEM is uninitialized.
NOTE: Variable SIZE_NI is uninitialized.
NOTE: Variable PRICE_NI is uninitialized.
NOTE: Variable SIZE_NKE is uninitialized.
NOTE: Variable PRICE_NKE is uninitialized.
NOTE: Variable SIZE_NOC is uninitialized.
NOTE: Variable PRICE_NOC is uninitialized.
NOTE: Variable SIZE_NOV is uninitialized.
NOTE: Variable PRICE_NOV is uninitialized.
NOTE: Variable SIZE_NOVL is uninitialized.
NOTE: Variable PRICE_NOVL is uninitialized.
NOTE: Variable SIZE_NRG is uninitialized.
NOTE: Variable PRICE_NRG is uninitialized.
NOTE: Variable SIZE_NSC is uninitialized.
NOTE: Variable PRICE_NSC is uninitialized.
NOTE: Variable SIZE_NSM is uninitialized.
NOTE: Variable PRICE_NSM is uninitialized.
NOTE: Variable SIZE_NTAP is uninitialized.
NOTE: Variable PRICE_NTAP is uninitialized.
NOTE: Variable SIZE_NTRS is uninitialized.
NOTE: Variable PRICE_NTRS is uninitialized.
NOTE: Variable SIZE_NUE is uninitialized.
NOTE: Variable PRICE_NUE is uninitialized.
NOTE: Variable SIZE_NVDA is uninitialized.
NOTE: Variable PRICE_NVDA is uninitialized.
NOTE: Variable SIZE_NVLS is uninitialized.
NOTE: Variable PRICE_NVLS is uninitialized.
NOTE: Variable SIZE_NWL is uninitialized.
NOTE: Variable PRICE_NWL is uninitialized.
NOTE: Variable SIZE_NYT is uninitialized.
NOTE: Variable PRICE_NYT is uninitialized.
NOTE: Variable SIZE_NYX is uninitialized.
NOTE: Variable PRICE_NYX is uninitialized.
NOTE: Variable SIZE_ODP is uninitialized.
NOTE: Variable PRICE_ODP is uninitialized.
NOTE: Variable SIZE_OI is uninitialized.
NOTE: Variable PRICE_OI is uninitialized.
NOTE: Variable SIZE_OKE is uninitialized.
NOTE: Variable PRICE_OKE is uninitialized.
NOTE: Variable SIZE_OMC is uninitialized.
NOTE: Variable PRICE_OMC is uninitialized.
NOTE: Variable SIZE_ORCL is uninitialized.
NOTE: Variable PRICE_ORCL is uninitialized.
NOTE: Variable SIZE_ORLY is uninitialized.
NOTE: Variable PRICE_ORLY is uninitialized.
NOTE: Variable SIZE_OXY is uninitialized.
NOTE: Variable PRICE_OXY is uninitialized.
NOTE: Variable SIZE_PAYX is uninitialized.
NOTE: Variable PRICE_PAYX is uninitialized.
NOTE: Variable SIZE_PBCT is uninitialized.
NOTE: Variable PRICE_PBCT is uninitialized.
NOTE: Variable SIZE_PBI is uninitialized.
NOTE: Variable PRICE_PBI is uninitialized.
NOTE: Variable SIZE_PCAR is uninitialized.
NOTE: Variable PRICE_PCAR is uninitialized.
NOTE: Variable SIZE_PCG is uninitialized.
NOTE: Variable PRICE_PCG is uninitialized.
NOTE: Variable SIZE_PCL is uninitialized.
NOTE: Variable PRICE_PCL is uninitialized.
NOTE: Variable SIZE_PCLN is uninitialized.
NOTE: Variable PRICE_PCLN is uninitialized.
NOTE: Variable SIZE_PCP is uninitialized.
NOTE: Variable PRICE_PCP is uninitialized.
NOTE: Variable SIZE_PCS is uninitialized.
NOTE: Variable PRICE_PCS is uninitialized.
NOTE: Variable SIZE_PDCO is uninitialized.
NOTE: Variable PRICE_PDCO is uninitialized.
NOTE: Variable SIZE_PEG is uninitialized.
NOTE: Variable PRICE_PEG is uninitialized.
NOTE: Variable SIZE_PEP is uninitialized.
NOTE: Variable PRICE_PEP is uninitialized.
NOTE: Variable SIZE_PFE is uninitialized.
NOTE: Variable PRICE_PFE is uninitialized.
NOTE: Variable SIZE_PFG is uninitialized.
NOTE: Variable PRICE_PFG is uninitialized.
NOTE: Variable SIZE_PG is uninitialized.
NOTE: Variable PRICE_PG is uninitialized.
NOTE: Variable SIZE_PGR is uninitialized.
NOTE: Variable PRICE_PGR is uninitialized.
NOTE: Variable SIZE_PH is uninitialized.
NOTE: Variable PRICE_PH is uninitialized.
NOTE: Variable SIZE_PHM is uninitialized.
NOTE: Variable PRICE_PHM is uninitialized.
NOTE: Variable SIZE_PKI is uninitialized.
NOTE: Variable PRICE_PKI is uninitialized.
NOTE: Variable SIZE_PLD is uninitialized.
NOTE: Variable PRICE_PLD is uninitialized.
NOTE: Variable SIZE_PLL is uninitialized.
NOTE: Variable PRICE_PLL is uninitialized.
NOTE: Variable SIZE_PM is uninitialized.
NOTE: Variable PRICE_PM is uninitialized.
NOTE: Variable SIZE_PNC is uninitialized.
NOTE: Variable PRICE_PNC is uninitialized.
NOTE: Variable SIZE_PNW is uninitialized.
NOTE: Variable PRICE_PNW is uninitialized.
NOTE: Variable SIZE_POM is uninitialized.
NOTE: Variable PRICE_POM is uninitialized.
NOTE: Variable SIZE_PPG is uninitialized.
NOTE: Variable PRICE_PPG is uninitialized.
NOTE: Variable SIZE_PPL is uninitialized.
NOTE: Variable PRICE_PPL is uninitialized.
NOTE: Variable SIZE_PRU is uninitialized.
NOTE: Variable PRICE_PRU is uninitialized.
NOTE: Variable SIZE_PSA is uninitialized.
NOTE: Variable PRICE_PSA is uninitialized.
NOTE: Variable SIZE_PTV is uninitialized.
NOTE: Variable PRICE_PTV is uninitialized.
NOTE: Variable SIZE_PWR is uninitialized.
NOTE: Variable PRICE_PWR is uninitialized.
NOTE: Variable SIZE_PX is uninitialized.
NOTE: Variable PRICE_PX is uninitialized.
NOTE: Variable SIZE_PXD is uninitialized.
NOTE: Variable PRICE_PXD is uninitialized.
NOTE: Variable SIZE_Q is uninitialized.
NOTE: Variable PRICE_Q is uninitialized.
NOTE: Variable SIZE_QCOM is uninitialized.
NOTE: Variable PRICE_QCOM is uninitialized.
NOTE: Variable SIZE_QLGC is uninitialized.
NOTE: Variable PRICE_QLGC is uninitialized.
NOTE: Variable SIZE_R is uninitialized.
NOTE: Variable PRICE_R is uninitialized.
NOTE: Variable SIZE_RAI is uninitialized.
NOTE: Variable PRICE_RAI is uninitialized.
NOTE: Variable SIZE_RDC is uninitialized.
NOTE: Variable PRICE_RDC is uninitialized.
NOTE: Variable SIZE_RF is uninitialized.
NOTE: Variable PRICE_RF is uninitialized.
NOTE: Variable SIZE_RHI is uninitialized.
NOTE: Variable PRICE_RHI is uninitialized.
NOTE: Variable SIZE_RHT is uninitialized.
NOTE: Variable PRICE_RHT is uninitialized.
NOTE: Variable SIZE_RL is uninitialized.
NOTE: Variable PRICE_RL is uninitialized.
NOTE: Variable SIZE_ROK is uninitialized.
NOTE: Variable PRICE_ROK is uninitialized.
NOTE: Variable SIZE_ROP is uninitialized.
NOTE: Variable PRICE_ROP is uninitialized.
NOTE: Variable SIZE_ROST is uninitialized.
NOTE: Variable PRICE_ROST is uninitialized.
NOTE: Variable SIZE_RRC is uninitialized.
NOTE: Variable PRICE_RRC is uninitialized.
NOTE: Variable SIZE_RRD is uninitialized.
NOTE: Variable PRICE_RRD is uninitialized.
NOTE: Variable SIZE_RSG is uninitialized.
NOTE: Variable PRICE_RSG is uninitialized.
NOTE: Variable SIZE_RTN is uninitialized.
NOTE: Variable PRICE_RTN is uninitialized.
NOTE: Variable SIZE_S is uninitialized.
NOTE: Variable PRICE_S is uninitialized.
NOTE: Variable SIZE_SBUX is uninitialized.
NOTE: Variable PRICE_SBUX is uninitialized.
NOTE: Variable SIZE_SCG is uninitialized.
NOTE: Variable PRICE_SCG is uninitialized.
NOTE: Variable SIZE_SCHW is uninitialized.
NOTE: Variable PRICE_SCHW is uninitialized.
NOTE: Variable SIZE_SE is uninitialized.
NOTE: Variable PRICE_SE is uninitialized.
NOTE: Variable SIZE_SEE is uninitialized.
NOTE: Variable PRICE_SEE is uninitialized.
NOTE: Variable SIZE_SHLD is uninitialized.
NOTE: Variable PRICE_SHLD is uninitialized.
NOTE: Variable SIZE_SHW is uninitialized.
NOTE: Variable PRICE_SHW is uninitialized.
NOTE: Variable SIZE_SIAL is uninitialized.
NOTE: Variable PRICE_SIAL is uninitialized.
NOTE: Variable SIZE_SII is uninitialized.
NOTE: Variable PRICE_SII is uninitialized.
NOTE: Variable SIZE_SJM is uninitialized.
NOTE: Variable PRICE_SJM is uninitialized.
NOTE: Variable SIZE_SLB is uninitialized.
NOTE: Variable PRICE_SLB is uninitialized.
NOTE: Variable SIZE_SNA is uninitialized.
NOTE: Variable PRICE_SNA is uninitialized.
NOTE: Variable SIZE_SNDK is uninitialized.
NOTE: Variable PRICE_SNDK is uninitialized.
NOTE: Variable SIZE_SNI is uninitialized.
NOTE: Variable PRICE_SNI is uninitialized.
NOTE: Variable SIZE_SO is uninitialized.
NOTE: Variable PRICE_SO is uninitialized.
NOTE: Variable SIZE_SPG is uninitialized.
NOTE: Variable PRICE_SPG is uninitialized.
NOTE: Variable SIZE_SRCL is uninitialized.
NOTE: Variable PRICE_SRCL is uninitialized.
NOTE: Variable SIZE_SRE is uninitialized.
NOTE: Variable PRICE_SRE is uninitialized.
NOTE: Variable SIZE_STI is uninitialized.
NOTE: Variable PRICE_STI is uninitialized.
NOTE: Variable SIZE_STJ is uninitialized.
NOTE: Variable PRICE_STJ is uninitialized.
NOTE: Variable SIZE_STR is uninitialized.
NOTE: Variable PRICE_STR is uninitialized.
NOTE: Variable SIZE_STT is uninitialized.
NOTE: Variable PRICE_STT is uninitialized.
NOTE: Variable SIZE_STZ is uninitialized.
NOTE: Variable PRICE_STZ is uninitialized.
NOTE: Variable SIZE_SUN is uninitialized.
NOTE: Variable PRICE_SUN is uninitialized.
NOTE: Variable SIZE_SVU is uninitialized.
NOTE: Variable PRICE_SVU is uninitialized.
NOTE: Variable SIZE_SWK is uninitialized.
NOTE: Variable PRICE_SWK is uninitialized.
NOTE: Variable SIZE_SWN is uninitialized.
NOTE: Variable PRICE_SWN is uninitialized.
NOTE: Variable SIZE_SWY is uninitialized.
NOTE: Variable PRICE_SWY is uninitialized.
NOTE: Variable SIZE_SYK is uninitialized.
NOTE: Variable PRICE_SYK is uninitialized.
NOTE: Variable SIZE_SYMC is uninitialized.
NOTE: Variable PRICE_SYMC is uninitialized.
NOTE: Variable SIZE_SYY is uninitialized.
NOTE: Variable PRICE_SYY is uninitialized.
NOTE: Variable SIZE_T is uninitialized.
NOTE: Variable PRICE_T is uninitialized.
NOTE: Variable SIZE_TAP is uninitialized.
NOTE: Variable PRICE_TAP is uninitialized.
NOTE: Variable SIZE_TDC is uninitialized.
NOTE: Variable PRICE_TDC is uninitialized.
NOTE: Variable SIZE_TE is uninitialized.
NOTE: Variable PRICE_TE is uninitialized.
NOTE: Variable SIZE_TER is uninitialized.
NOTE: Variable PRICE_TER is uninitialized.
NOTE: Variable SIZE_TGT is uninitialized.
NOTE: Variable PRICE_TGT is uninitialized.
NOTE: Variable SIZE_THC is uninitialized.
NOTE: Variable PRICE_THC is uninitialized.
NOTE: Variable SIZE_TIE is uninitialized.
NOTE: Variable PRICE_TIE is uninitialized.
NOTE: Variable SIZE_TIF is uninitialized.
NOTE: Variable PRICE_TIF is uninitialized.
NOTE: Variable SIZE_TJX is uninitialized.
NOTE: Variable PRICE_TJX is uninitialized.
NOTE: Variable SIZE_TLAB is uninitialized.
NOTE: Variable PRICE_TLAB is uninitialized.
NOTE: Variable SIZE_TMK is uninitialized.
NOTE: Variable PRICE_TMK is uninitialized.
NOTE: Variable SIZE_TMO is uninitialized.
NOTE: Variable PRICE_TMO is uninitialized.
NOTE: Variable SIZE_TROW is uninitialized.
NOTE: Variable PRICE_TROW is uninitialized.
NOTE: Variable SIZE_TRV is uninitialized.
NOTE: Variable PRICE_TRV is uninitialized.
NOTE: Variable SIZE_TSN is uninitialized.
NOTE: Variable PRICE_TSN is uninitialized.
NOTE: Variable SIZE_TSO is uninitialized.
NOTE: Variable PRICE_TSO is uninitialized.
NOTE: Variable SIZE_TSS is uninitialized.
NOTE: Variable PRICE_TSS is uninitialized.
NOTE: Variable SIZE_TWC is uninitialized.
NOTE: Variable PRICE_TWC is uninitialized.
NOTE: Variable SIZE_TWX is uninitialized.
NOTE: Variable PRICE_TWX is uninitialized.
NOTE: Variable SIZE_TXN is uninitialized.
NOTE: Variable PRICE_TXN is uninitialized.
NOTE: Variable SIZE_TXT is uninitialized.
NOTE: Variable PRICE_TXT is uninitialized.
NOTE: Variable SIZE_UNH is uninitialized.
NOTE: Variable PRICE_UNH is uninitialized.
NOTE: Variable SIZE_UNM is uninitialized.
NOTE: Variable PRICE_UNM is uninitialized.
NOTE: Variable SIZE_UNP is uninitialized.
NOTE: Variable PRICE_UNP is uninitialized.
NOTE: Variable SIZE_UPS is uninitialized.
NOTE: Variable PRICE_UPS is uninitialized.
NOTE: Variable SIZE_URBN is uninitialized.
NOTE: Variable PRICE_URBN is uninitialized.
NOTE: Variable SIZE_USB is uninitialized.
NOTE: Variable PRICE_USB is uninitialized.
NOTE: Variable SIZE_UTX is uninitialized.
NOTE: Variable PRICE_UTX is uninitialized.
NOTE: Variable SIZE_V is uninitialized.
NOTE: Variable PRICE_V is uninitialized.
NOTE: Variable SIZE_VAR is uninitialized.
NOTE: Variable PRICE_VAR is uninitialized.
NOTE: Variable SIZE_VFC is uninitialized.
NOTE: Variable PRICE_VFC is uninitialized.
NOTE: Variable SIZE_VLO is uninitialized.
NOTE: Variable PRICE_VLO is uninitialized.
NOTE: Variable SIZE_VMC is uninitialized.
NOTE: Variable PRICE_VMC is uninitialized.
NOTE: Variable SIZE_VNO is uninitialized.
NOTE: Variable PRICE_VNO is uninitialized.
NOTE: Variable SIZE_VRSN is uninitialized.
NOTE: Variable PRICE_VRSN is uninitialized.
NOTE: Variable SIZE_VTR is uninitialized.
NOTE: Variable PRICE_VTR is uninitialized.
NOTE: Variable SIZE_VZ is uninitialized.
NOTE: Variable PRICE_VZ is uninitialized.
NOTE: Variable SIZE_WAT is uninitialized.
NOTE: Variable PRICE_WAT is uninitialized.
NOTE: Variable SIZE_WDC is uninitialized.
NOTE: Variable PRICE_WDC is uninitialized.
NOTE: Variable SIZE_WEC is uninitialized.
NOTE: Variable PRICE_WEC is uninitialized.
NOTE: Variable SIZE_WFC is uninitialized.
NOTE: Variable PRICE_WFC is uninitialized.
NOTE: Variable SIZE_WHR is uninitialized.
NOTE: Variable PRICE_WHR is uninitialized.
NOTE: Variable SIZE_WIN is uninitialized.
NOTE: Variable PRICE_WIN is uninitialized.
NOTE: Variable SIZE_WM is uninitialized.
NOTE: Variable PRICE_WM is uninitialized.
NOTE: Variable SIZE_WMB is uninitialized.
NOTE: Variable PRICE_WMB is uninitialized.
NOTE: Variable SIZE_WMT is uninitialized.
NOTE: Variable PRICE_WMT is uninitialized.
NOTE: Variable SIZE_WU is uninitialized.
NOTE: Variable PRICE_WU is uninitialized.
NOTE: Variable SIZE_WY is uninitialized.
NOTE: Variable PRICE_WY is uninitialized.
NOTE: Variable SIZE_WYN is uninitialized.
NOTE: Variable PRICE_WYN is uninitialized.
NOTE: Variable SIZE_WYNN is uninitialized.
NOTE: Variable PRICE_WYNN is uninitialized.
NOTE: Variable SIZE_X is uninitialized.
NOTE: Variable PRICE_X is uninitialized.
NOTE: Variable SIZE_XEL is uninitialized.
NOTE: Variable PRICE_XEL is uninitialized.
NOTE: Variable SIZE_XL is uninitialized.
NOTE: Variable PRICE_XL is uninitialized.
NOTE: Variable SIZE_XLNX is uninitialized.
NOTE: Variable PRICE_XLNX is uninitialized.
NOTE: Variable SIZE_XOM is uninitialized.
NOTE: Variable PRICE_XOM is uninitialized.
NOTE: Variable SIZE_XRAY is uninitialized.
NOTE: Variable PRICE_XRAY is uninitialized.
NOTE: Variable SIZE_XRX is uninitialized.
NOTE: Variable PRICE_XRX is uninitialized.
NOTE: Variable SIZE_XTO is uninitialized.
NOTE: Variable PRICE_XTO is uninitialized.
NOTE: Variable SIZE_Y is uninitialized.
NOTE: Variable PRICE_Y is uninitialized.
NOTE: Variable SIZE_YHOO is uninitialized.
NOTE: Variable PRICE_YHOO is uninitialized.
NOTE: Variable SIZE_YUM is uninitialized.
NOTE: Variable PRICE_YUM is uninitialized.
NOTE: Variable SIZE_ZION is uninitialized.
NOTE: Variable PRICE_ZION is uninitialized.
NOTE: There were 0 observations read from the data set WORK.WANT.
NOTE: The data set WORK.WANT has 0 observations and 0 variables.
NOTE: DATA statement used (Total process time):
real time 1.35 seconds
cpu time 1.26 seconds

NOTE: Deleting WORK.T_E_M_P (memtype=DATA).
NOTE: Deleting WORK._FOR_FORMAT (memtype=DATA).
NOTE: PROCEDURE DELETE used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

art297 · Posted 05-27-2017 11:31 PM

For anyone who has been following this thread, obviously, the error log was not the solution to the problem .. but it definitely did help to identify why the macro was failing.

The problem, as it turned out, was a transposition of a file that had approximately 186,000 records, one by field (approximately 500 levels), one id field (approximately 450 levels) and two fields that needed to be transposed. In short, the resulting file needed to have about 500 records, with each record containing about 900 transposed variables.

We had problems with the macro I suggested because: (1) there were duplicate entries for some of the id fields and (2) one of the id levels contained the value LOW. Since the macro works by creating a format, and didn't contain an HLO " " option, it generated the error log. The good news was that the error log identified the two problems and the solution was found fairly quickly.

Art, CEO, AnalystFinder.com

Classroom Training Available!