any way to remove this warning?! ... View more

Thanks a huge. But I have to say my SAS/computer  has problem NOW.    1) I run you code, the put line does not show up the value[see below], as seen in your log.  2) run a simple code below, it complains. 3) The code I am running on giganttttic data does not change any. It used to be ok! _______________________________________________________________________ proc sql; select case when horsepower>210 then 1 else 0 end as is_big, "big flag" as flag_note, count(*) as cttot from sashelp.cars group by 1，2; quit;___________________________________________________ 9121 proc sql; 9122 select case when horsepower>210 then 1 else 0 end as is_big, "big flag" as flag_note, count(*) - 22 200 9122! as cttot ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, (, *, +, -, BTRIM, CALCULATED, CASE, EXISTS, INPUT, NOT, PUT, SUBSTRING, TRANSLATE, USER, ^, ~. ERROR 200-322: The symbol is not recognized and will be ignored. 9123 from sashelp.cars 9124 group by 1,2; 9125 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds   ———————————————————————— 9092 options mprint symbolgen; 9093 9094 %macro pctvar(ds, var, note); 9095 proc univariate data=&ds. noprint; 9096 var &var.; 9097 output out=a pctlpre=&note._p_ pctlpts= 5 to 95 by 5; 9098 run; 9099 9100 data _null_; 9101 set a; 9102 array &note._p_ &note._p_:; 9103 do over &note._p_; 9104 call symputx(vname(&note._p_), &note._p_, 'g'); 9105 end; 9106 run; 9107 9108 proc sql; 9109 drop table a; 9110 quit; 9111 9112 %put "p_5=&&&note._p_5. p_50=&&&note._p_50. p_95=&&&note._p_95."; 9113 %mend; 9114 9115 %pctvar(sashelp.cars, horsepower, hp); MLOGIC(PCTVAR): Beginning execution. MLOGIC(PCTVAR): Parameter DS has value sashelp.cars MLOGIC(PCTVAR): Parameter VAR has value horsepower MLOGIC(PCTVAR): Parameter NOTE has value hp SYMBOLGEN: Macro variable DS resolves to sashelp.cars MPRINT(PCTVAR): proc univariate data=sashelp.cars noprint; SYMBOLGEN: Macro variable VAR resolves to horsepower MPRINT(PCTVAR): var horsepower; SYMBOLGEN: Macro variable NOTE resolves to hp MPRINT(PCTVAR): output out=a pctlpre=hp_p_ pctlpts= 5 to 95 by 5; MPRINT(PCTVAR): run; NOTE: The data set WORK.A has 1 observations and 19 variables. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.02 seconds cpu time 0.01 seconds MPRINT(PCTVAR): data _null_; MPRINT(PCTVAR): set a; SYMBOLGEN: Macro variable NOTE resolves to hp SYMBOLGEN: Macro variable NOTE resolves to hp MPRINT(PCTVAR): array hp_p_ hp_p_:; SYMBOLGEN: Macro variable NOTE resolves to hp MPRINT(PCTVAR): do over hp_p_; SYMBOLGEN: Macro variable NOTE resolves to hp SYMBOLGEN: Macro variable NOTE resolves to hp MPRINT(PCTVAR): call symputx(vname(hp_p_), hp_p_, 'g'); MPRINT(PCTVAR): end; MPRINT(PCTVAR): run; NOTE: There were 1 observations read from the data set WORK.A. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds MPRINT(PCTVAR): proc sql; MPRINT(PCTVAR): drop table a; NOTE: Table WORK.A has been dropped. MPRINT(PCTVAR): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MLOGIC(PCTVAR): %PUT "p_5=&&&note._p_5. p_50=&&&note._p_50. p_95=&&&note._p_95." SYMBOLGEN: Macro variable NOTE resolves to hp SYMBOLGEN: Macro variable NOTE resolves to hp SYMBOLGEN: Macro variable NOTE resolves to hp "p_5=&&hp_p_5. p_50=&&hp_p_50. p_95=&&hp_p_95." ... View more

Thanks. Yes, it is what I want. But I run you code. I did not get the value, wondering whether my computer has problem.    8837 %macro pctvar(ds, var, note); 8838 proc univariate data=&ds. noprint; 8839 var &var.; 8840 output pctlpre=&note._p_ pctlpts= 5 to 95 by 5 out=a; 8841 run; 8842 data _null_; 8843 set a; 8844 array &note._p_ &note._p_:; 8845 do i=1 to dim(&note._p_); 8846 call symputx(vname(&note._p_(i)),&note._p_(i)); 8847 end; 8848 run; 8849 %put p_5=&&&note._p_5 p_50=&&&note._p_50 p_95=&&&note._p_95; 8850 %mend; 8851 8852 %pctvar(sashelp.cars, horsepower, hp) MLOGIC(PCTVAR): Beginning execution. MLOGIC(PCTVAR): Parameter DS has value sashelp.cars MLOGIC(PCTVAR): Parameter VAR has value horsepower MLOGIC(PCTVAR): Parameter NOTE has value hp MPRINT(PCTVAR): proc univariate data=sashelp.cars noprint; MPRINT(PCTVAR): var horsepower; MPRINT(PCTVAR): output pctlpre=hp_p_ pctlpts= 5 to 95 by 5 out=a; MPRINT(PCTVAR): run; NOTE: The data set WORK.A has 1 observations and 19 variables. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.04 seconds cpu time 0.03 seconds MPRINT(PCTVAR): data _null_; MPRINT(PCTVAR): set a; MPRINT(PCTVAR): array hp_p_ hp_p_:; MPRINT(PCTVAR): do i=1 to dim(hp_p_); MPRINT(PCTVAR): call symputx(vname(hp_p_(i)),hp_p_(i)); MPRINT(PCTVAR): end; MPRINT(PCTVAR): run; NOTE: There were 1 observations read from the data set WORK.A. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds MLOGIC(PCTVAR): %PUT p_5=&&&note._p_5 p_50=&&&note._p_50 p_95=&&&note._p_95 p_5=&&hp_p_5 p_50=&&hp_p_50 p_95=&&hp_p_95 MLOGIC(PCTVAR): Ending execution.   ... View more

Can I bother you correct the macro below?!  Let the line, %put "p_5=&&p_&note._5. p_50=&&p_&note._50. p_95=&&p_&note._95.";,  print out the 5/50/95 percentile of horsepower/sashelp.cars ?!  %macro pctvar(ds, var, note); proc univariate data=&ds. noprint; var &var.; output pctlpre=p_&note._ pctlpts= 5 to 95 by 5; run; proc print; run; data _null_; set; array p_&note._ p_&note._:; do over p_&note._; call symputx(vname(p_&note._),p_&note._,'G');/*G=global?*/ end; stop; run;quit; %put "p_5=&&p_&note._5. p_50=&&p_&note._50. p_95=&&p_&note._95."; %mend;   %pctvar(sashelp.cars, horsepower, hp); ... View more

Thanks,  But I run you code and get the below(does not show up the percentile value at the end). I assign the percentile values to macro variables and use them down the stream.    MLOGIC(PCTVAR): Beginning execution. MLOGIC(PCTVAR): Parameter DS has value sashelp.cars MLOGIC(PCTVAR): Parameter VAR has value horsepower MLOGIC(PCTVAR): Parameter NOTE has value hp MPRINT(PCTVAR): proc univariate data=sashelp.cars noprint; MPRINT(PCTVAR): var horsepower; MPRINT(PCTVAR): output pctlpre=hp_p_ pctlpts= 5 to 95 by 5 out=a; MPRINT(PCTVAR): run; NOTE: The data set WORK.A has 1 observations and 19 variables. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(PCTVAR): data _null_; MPRINT(PCTVAR): set a; MPRINT(PCTVAR): array hp_p_ hp_p_:; MPRINT(PCTVAR): do i=1 to dim(hp_p_); MPRINT(PCTVAR): call symputx(vname(hp_p_(i)),hp_p_(i)); MPRINT(PCTVAR): end; MPRINT(PCTVAR): run; NOTE: There were 1 observations read from the data set WORK.A. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds MLOGIC(PCTVAR): %PUT p_5=&&&note._p_5 p_50=&&&note._p_50 p_95=&&&note._p_95 p_5=&&hp_p_5 p_50=&&hp_p_50 p_95=&&hp_p_95 MLOGIC(PCTVAR): Ending execution. ... View more

The according percentile in the dataset from SAS   Obs p_hp_5 p_hp_10 p_hp_15 p_hp_20 p_hp_25 p_hp_30 p_hp_35 p_hp_40 p_hp_45 p_hp_50 p_hp_55 p_hp_60 p_hp_65 p_hp_70 p_hp_75 p_hp_80 p_hp_85 p_hp_90 p_hp_951 115 130 140 155 165 172 184 193 200 210 215 224 230 240 255 275 295 302 340 ... View more

Not Sure what is going on?!   0) How to a macro variable with another macro variable in it?!  1) Why cannot delete the macro variable(below)? Is my computer having problem?! GLOBAL P_VOL_B_10 867976 GLOBAL P_VOL_B_15 1205259 GLOBAL P_VOL_B_20 1683118 GLOBAL P_VOL_B_25 2128543 GLOBAL P_VOL_B_30 2660988 GLOBAL P_VOL_B_35 2895309 GLOBAL P_VOL_B_40 3496028 GLOBAL P_VOL_B_45 4244589 GLOBAL P_VOL_B_5 582102 GLOBAL P_VOL_B_50 4632714 GLOBAL P_VOL_B_55 5190511 GLOBAL P_VOL_B_60 6235967 GLOBAL P_VOL_B_65 7352003 GLOBAL P_VOL_B_70 8194236 GLOBAL P_VOL_B_75 10235694 GLOBAL P_VOL_B_80 14296730 GLOBAL P_VOL_B_85 17937992 GLOBAL P_VOL_B_90 23802025 GLOBAL P_VOL_B_95 43347092 GLOBAL START_DT_I 31 GLOBAL TS 1100 WARNING: Attempt to delete macro variable P_VOL_B_10 failed. Variable not found. 8709 %SYMDEL p_vol_B_10; WARNING: Attempt to delete macro variable P_VOL_B_10 failed. Variable not found. 8710 %SYMDEL P_VOL_B_10; WARNING: Attempt to delete macro variable P_VOL_B_50 failed. Variable not found. 8711 %SYMDEL P_VOL_B_50; ... View more

%pctvar(sashelp.cars, horsepower, hp);   %macro pctvar(ds, var, note); proc univariate data=&ds. noprint; var &var.; output pctlpre=p_&note._ pctlpts= 5 to 95 by 5; run; proc print; run; data _null_; set; array p_&note._ p_&note._:; do over p_&note._; call symputx(vname(p_&note._),p_&note._,'G');/*G=global?*/ end; stop; run;quit; %put "p_5=&&p_&note._5. p_50=&&p_&note._50. p_95=&&p_&note._95."; %mend; ... View more

It has lots of macros. Days ago, it is all fine.  Now I run step by step. It says the one below is not fine.  %put "p_5=&&note._p_5. p_50=&&note._p_50. p_95=&&note._p_95."; The line above does not print the expected values[the macro supposes to assign percentiles to macro variables].    Thanks,    %pctvar(sashelp.cars, horsepower, hp); %macro pctvar(ds, var, note); proc univariate data=&ds. noprint; var &var.; output pctlpre=&note._p_ pctlpts= 5 to 95 by 5; run; proc print; run; data _null_; set; array &note._p_ &note._p_:; do over &note._p_; call symputx(vname(&note._p_),&note._p_); end; stop; run;quit; %put "p_5=&&note._p_5. p_50=&&note._p_50. p_95=&&note._p_95."; %mend; ... View more

Thanks a huge. It is. I verify with puppy Sovler/Excel, though hard to digest in SAS yet.  ... View more