About duanzongran

duanzongran · ‎11-11-2022

THANK YOU TOM! Yes,you point out my long time confusions. I will try hard to understand "informat" vs "format","length" and "input".

duanzongran · ‎11-11-2022

Hi PaigeMiller ,Thank you for fixing my mistakes and I will recheck my code in future.I will learn more about %nrstr() document you mentioned,Thanks again!

duanzongran · ‎11-11-2022

Quentin ! Thank YOU for your kindness! You inspired me. I made some elementary mistakes including : misunderstanding character string and the wrong if - then sencense.Now I fix it in the reply.

duanzongran · ‎11-11-2022

Thanks @PaigeMiller ， the data step should be fixed as data cust_info; informat application_no $5. city $8. grade $2. payment_proportion best18. pp_grp $18.; input application_no $ city $ grade $ payment_proportion ; if payment_proportion<=0.3 then pp_grp='(LOW,30%]'; else if payment_proportion<=0.6 then pp_grp='(30%,60%]'; else pp_grp='(60%,HIGH)'; datalines ; N0001 city4 G3 0.954791131 N0002 city2 G2 0.384459679 N0003 city3 G3 0.924944204 N0004 city4 G1 0.890577525 N0005 city4 G2 0.167083544 N0006 city1 G3 0.552686255 N0007 city4 G1 0.616079916 N0008 city2 G3 0.721666748 N0009 city3 G3 0.219522284 N0010 city1 G2 0.736888981 N0011 city1 G3 0.52245841 N0012 city4 G1 0.808448548 N0013 city4 G3 0.737899701 N0014 city4 G2 0.037866378 N0015 city2 G3 0.196772325 N0016 city4 G2 0.248803462 N0017 city2 G2 0.117926269 N0018 city3 G3 0.145969656 N0019 city2 G2 0.554093061 N0020 city2 G3 0.09314399 N0021 city1 G3 0.043598302 N0022 city3 G2 0.743726176 N0023 city3 G2 0.475828188 N0024 city4 G3 0.219011228 N0025 city1 G3 0.230165184 N0026 city3 G2 0.883160772 N0027 city1 G2 0.033940403 N0028 city2 G2 0.248249667 N0029 city4 G1 0.742306159 N0030 city4 G3 0.271939134 N0031 city2 G2 0.531722203 N0032 city1 G1 0.274051488 N0033 city4 G1 0.95289881 N0034 city4 G1 0.42693408 N0035 city2 G3 0.955515343 N0036 city3 G1 0.143521235 N0037 city3 G3 0.936618931 N0038 city4 G3 0.86678435 N0039 city3 G2 0.367460855 N0040 city4 G3 0.681624734 N0041 city3 G1 0.056459049 N0042 city3 G2 0.206450467 N0043 city3 G3 0.982449115 N0044 city1 G3 0.852173721 N0045 city2 G1 0.082348749 N0046 city1 G3 0.643541203 N0047 city3 G3 0.555692983 N0048 city2 G3 0.765327052 N0049 city3 G3 0.443996454 N0050 city4 G1 0.283174744 ; run;

duanzongran · ‎11-11-2022

dear ALL: I want to write a conditional select macro to select something from a dataset with a conditional statement,here is the code; data cust_info; informat application_no $5. city $8. grade $2. payment_proportion best18. pp_grp $18.; input application_no $ city $ grade $ payment_proportion ; if payment_proportion<0.3 then pp_grp='(LOW,30%]'; else if payment_proportion<0.3 then pp_grp='(30%,60%]'; else pp_grp='(60%,HIGH)'; datalines ; N0001 city4 G3 0.954791131 N0002 city2 G2 0.384459679 N0003 city3 G3 0.924944204 N0004 city4 G1 0.890577525 N0005 city4 G2 0.167083544 N0006 city1 G3 0.552686255 N0007 city4 G1 0.616079916 N0008 city2 G3 0.721666748 N0009 city3 G3 0.219522284 N0010 city1 G2 0.736888981 N0011 city1 G3 0.52245841 N0012 city4 G1 0.808448548 N0013 city4 G3 0.737899701 N0014 city4 G2 0.037866378 N0015 city2 G3 0.196772325 N0016 city4 G2 0.248803462 N0017 city2 G2 0.117926269 N0018 city3 G3 0.145969656 N0019 city2 G2 0.554093061 N0020 city2 G3 0.09314399 N0021 city1 G3 0.043598302 N0022 city3 G2 0.743726176 N0023 city3 G2 0.475828188 N0024 city4 G3 0.219011228 N0025 city1 G3 0.230165184 N0026 city3 G2 0.883160772 N0027 city1 G2 0.033940403 N0028 city2 G2 0.248249667 N0029 city4 G1 0.742306159 N0030 city4 G3 0.271939134 N0031 city2 G2 0.531722203 N0032 city1 G1 0.274051488 N0033 city4 G1 0.95289881 N0034 city4 G1 0.42693408 N0035 city2 G3 0.955515343 N0036 city3 G1 0.143521235 N0037 city3 G3 0.936618931 N0038 city4 G3 0.86678435 N0039 city3 G2 0.367460855 N0040 city4 G3 0.681624734 N0041 city3 G1 0.056459049 N0042 city3 G2 0.206450467 N0043 city3 G3 0.982449115 N0044 city1 G3 0.852173721 N0045 city2 G1 0.082348749 N0046 city1 G3 0.643541203 N0047 city3 G3 0.555692983 N0048 city2 G3 0.765327052 N0049 city3 G3 0.443996454 N0050 city4 G1 0.283174744 ; run; %macro conditional_select(condition_statement=,label=); proc sql; create table result as select city,count(1) as cnt label="&label." from Cust_info(where=(&condition_statement.)) group by city; quit; %mend; *now I want to make a summary from cust_info where grade=G3 and pp_grp=(30%,60%],and give label a value. "(30%,60%]&G3",here "&" just represent "and" ,not to be resolved to &G3 as a macro variable ; %conditional_select(condition_statement=%nrstr(grade=G3 and pp_grp=(30%,60%]),label=%nrstr((30%,60%]&G3)); But it failed and SAS has no response . Meanwhile，SAS can't run other command code.I have to restart it. I have two questions : 1. Why this happen? When sas has no response ,what should I do to get back to normal? 2. How to make my code work ? In fact I am very confused with quote function in sas macro. Thank you for your patience !ANY suggestion is welcomed！

duanzongran · ‎06-15-2022

Yes,quite so !!!!!!!!!!!!!!!!!!!!!!!! After checking my computer ,i found the anti-virus software installed by my IT workmate very frequently scan every file I make from sas. When I run then code on a computer without the anti-virus software , it seems everything is OK.

duanzongran · ‎04-02-2022

dear all: Recently,I was confused about "A lock is not available for <dataset>".Indeed ,it's an error,but when I restart SAS and run the code again ,the error disappeared.How to avoid the error? When I review my code,I guess 5 possibilities may cause this error， right or wrong？ *1.set options compress=yes; options compress=yes; *2.in data step,input dataset and the output dataset have the same name; data X;set X ;run; *3. when using proc sort ,without out= option; proc sort data=x;by id;run; Any suggestion is welcome!

duanzongran · ‎04-02-2022

dear all: I want to put the macro variable just it seems like without resoving % or &. here's the code: data test; length a $255.; input a $; datalines; xx&xx yy%yy ; run; proc sql; select a into:a_list separated by " " from test; quit; %put &a_list.; data _null_; file "c:\test.txt"; put "&a_list."; run; when %put &a_list.; xx&xx yy%yy is expected; when put "&a_list."; in data step xx&xx yy%yy is expected in the txt file; but，there's always two warnings : WARNING: Apparent symbolic reference XX not resolved. WARNING: Apparent invocation of macro YY not resolved. What should i do to make it without warnings? Thanks in advance !

duanzongran · ‎02-08-2020

dear all: i wanna refer a macro variable in a macro like this: %let a=%nrstr(%do i= 1 %to 3;); %let b=%nrstr(%end;); %macro linshi(); &a.; %put &i.; &b.; %mend; %linshi(); but the log shows : NOTE: Line generated by the macro variable "A". 1 %do i= 1 %to 3; - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. WARNING: Apparent symbolic reference I not resolved. &i. NOTE: Line generated by the macro variable "B". 1 %end; - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. What should i do to make it work? Thanks in advance !

duanzongran · ‎10-28-2019

DEAR ALL: HERE ,I have a dataset: data lin; input x; datalines; 1 2 3 4 . . . ; run; the missing value should be updated like this the 5th obs=(1+2+3+4)=10 the 6th obs=1+2+3+4+The5thObs=(1+2+3+4+10)=20; the 7th obs=1+2+3+4+The5thObs+The6thObs=(1+2+3+4+10+20)=40; ........ the expected result is a sequence like a sequence 1 2 3 4 10 20 40

duanzongran · ‎10-23-2019

Thank U ! variable_list is a good method!

duanzongran · ‎10-21-2019

THANK YOU @Tom ; here i do a further describtion and hope to get your Valuable advice ; HERE IS WHAT I HAVE I have three macros ,macro3 refers to macro2 and macro2 refers to macro1, and They share the same input parameters (name1=,name2=,name3=,name4=,name5=); %macro macro1(name1=,name2=,name3=,name4=,name5=); *codes......; %mend; %macro macro2(x1=,x2=,name1=,name2=,name3=,name4=,name5=); *other codes.......; %macro1(name1=&name1.,name2=&name2.,name3=&name3.,name4=&name4.,name5=&name5.); *other codes.......; %mend; %macro macro3(y1=,y2=,x1=,x2=,name1=,name2=,name3=,name4=,name5=); *other codes.......; %macro2(x1=&x1.,x2=&x2.,name1=&name1.,name2=&name2.,name3=&name3.,name4=&name4.,name5=&name5.); *other codes.......; %mend; HERE IS WHAT I WANT CONTROL THE INPUT parameters OF EVERY MACRO BY MACRO VARIABLE ; the number of input parameters of macro1 may be changed to (name1=,name2=,name3=,name4=,name5=,name6=,name7=) or more,just like %macro macro1(name1=,name2=,name3=,name4=,name5=,name6=,name7=); *codes......; %mend; and i wish macro2 could be changed as %macro macro2 (x1=,x2=,name1=,name2=,name3=,name4=,name5=,name6=,name7=); *other codes.......; %macro1(name1=&name1.,name2=&name2.,name3=&name3.,name4=&name4.,name5=&name5.,name6=&name6.,name7=&name7); *other codes.......; %mend; and i wish macro3 could be changed as %macro macro3(y1=,y2=,x1=,x2=,name1=,name2=,name3=,name4=,name5=,name6=,name7=); *other codes.......; %macro2(x1=&x1.,x2=x2.,name1=&name1.,name2=&name2.,name3=&name3.,name4=&name4.,name5=&name5.,name6=&name6.,name7=&name7); *other codes.......; %mend;

duanzongran · ‎10-12-2019

Dear ALL: I want to make a Variable macro that the Input parameters can be changed (here i want to control the default value of every parameter) ,so that the macro can be changed: I try like this : %let name=%str(name1=zs,name2=ls,name3=,name4=,name5=hh); %macro test(&name.); %put &name1. is a good man; %put &name2. is a good man; %put &name3. is a good man; %put &name4. is a good man; %put &name5. is a good man; %mend; but failed; ANY suggestion is welcome ！Thanks in advance！

duanzongran · ‎09-26-2019

THANKS A LOT!

duanzongran · ‎09-26-2019

proc arbor data=work.step01 Leafsize=1 Splitsize=2 Mincatsize = 5 Maxbranch=10 Maxdepth=6 Criterion=PROBCHISQ alpha = 0.05 Padjust= CHAIDAFTER DEPTH MAXRULES=5 MAXSURRS=0 Missing=USEINSEARCH Exhaustive=0 /* event='malignant'*/ ; input &varN./ level=interval; input &varC./ level=nominal; target NGOOD/level=binary; Performance DISK NodeSize=20000; Assess NoValidata measure=MISC; SUBTREE LARGEST; MAKEMACRO NLEAVES=nleaves; save MODEL=Tree_EMTREE SEQUENCE=Tree_OUTSEQ IMPORTANCE=Tree_OUTIMPORT NODESTAT=Tree_OUTNODES SUMMARY=Tree_OUTSUMMARY STATSBYNODE=Tree_OUTSTATS Topology=Tree_OUTTOPOLOGY Path = Tree_OUTPATH Rules=Tree_OUTRules ; code file="&pth.\sas_rule&i..XML" PMML ; quit; when the code statement changed as code file="&pth.\sas_rule&i..sas"; IT works ,but when become PMML ,it doesn't work. I have search for help a very long time . Thanks in advance!

Online Status	Offline
Date Last Visited	‎08-30-2024 09:18 AM

Re: How to make a summary for many columns and name the summary variab...

How to make a summary for many columns and name the summary variables ...

Re: how to do a one-hot encoding process by using proc transpose?

how to do a one-hot encoding process by using proc transpose?

when using libname jdbc to connect to hive an error appears

Re: A confusion about macro variable

Re: A confusion about macro variable

Re: A confusion about macro variable

A confusion about macro variable

Re: how can get help about "proc split" online ?

Re: A confusion about macro variable

Re: A confusion about macro variable

Re: A confusion about macro variable

Re: about filename and ods ： ERROR: At least one file associated with...

Re: A confusion with quote function in sas macro

confusion about "A lock is not available for <dataset>"

Re: A confusion with quote function in sas macro

Re: A confusion with quote function in sas macro

Re: A confusion with quote function in sas macro

Re: A confusion with quote function in sas macro

A confusion with quote function in sas macro

Re: confusion about "A lock is not available for <dataset>"

confusion about "A lock is not available for <dataset>"

macro variable resolve

refer a macro variable in a macro

update data in data step

Re: make a Variable macro that the Input parameters can be changed

Re: make a Variable macro that the Input parameters can be changed

make a Variable macro that the Input parameters can be changed

Re: proc arbor can not output PMML file , the code statment option has...

proc arbor can not output PMML file , the code statment option has bec...