Hi.Recommend you to post up some dummy data and what data do you need. Not origin data structure ,it is hard to code. As what you write .Consider use proc sql 's 'except' operation . [pre] data temp; set sashelp.class; where sex eq 'F'; run; proc sql feedback; select * from sashelp.class except select * from temp; quit; [/pre] Ksharp ... View more

Yes.I also get it.But Patrick's code is more clever about rename origin variable. [pre] data test; input age $ surmos survival; datalines; G1 0 0.1 G1 1 0.2 G1 3 0.6 G1 6 0.12 G2 0 0.01 G2 1 0.6 G2 5 0.12 G2 6 0.33 G2 10 0.88 ; run; data temp; set test; retain _surmos _survival; if age ne lag(age) then _surmos = surmos; _surmos+1; if _surmos lt surmos then do; do while(_surmos lt surmos); output; _surmos+1; end; end; _survival=survival; _surmos=surmos; drop survival surmos; output; run; proc print noobs; run; [/pre] Ksharp ... View more

Hi. Maybe you need the proper format. Such as Zw.d. [pre] data peter; input num; char=compress(put(num,z5.3),'.'); datalines; 1.234 0.235 0.543 0.760 2.658 ;run; proc print;run; [/pre] Ksharp Message was edited by: Ksharp ... View more

Emmm.Yes. If you have more than two blanks, you can use formatted input method. [pre] data temp; infile datalines truncover; input d1 $ string1 $ comment $50.; _comment=substr(comment,1,anydigit(comment)-1); string2=scan(comment,-1); drop comment; datalines; 001 001 qwer asd 5 002 002 asdfyuiop 6 003 003 zxcv sdit 5 ; run; proc print noobs; run; [/pre] P.S : The company is the one I worked for , not mine. 🙂 Ksharp Message was edited by: Ksharp ... View more

Hi. You can input 'comment' and 'string2' as one variable firstly, then parse this variable into two variables you need. try it. [pre] data temp; input d1 $ string1 $ comment & $50.; _comment=substr(comment,1,length(comment)-2); string2=substr(comment,length(comment)-1); drop comment; datalines; 001 001 qwer asd 5 002 002 asdfyuiop 6 003 003 zxcv 5 ; run; proc print noobs; run; [/pre] Ksharp ... View more

Under most situation, it can not be except for sas code. If you want interchange between Windows and Linux , it would be better choice to use proc cport / proc copy to make a transported file. Ksharp ... View more

Hi.Peter My company has a Spd server under AIX os. and in the AIX there is a file named libnames.parm(i.e. /sas/spds44/site/libnames.parm) which contains the information you need,you can use vi/txt open it and distil the pathe. But before use it, recommend to backup it for the sake of importance. Ksharp ... View more

There is only an example of details report. I am not sure it is what you need. Cynthia's second code is great. You can use it. [pre] data test; input Region $ Sales AgentID; cards; E 12 1 E 14 1 E 17 2 E 12 1 E 14 3 E 12 2 E 18 3 N 18 4 N 16 4 N 12 5 N 17 4 N 25 4 S 12 7 S 12 8 S 13 7 S 12 8 W 27 9 ; run; proc report data = test nowd out=temp; column Region AgentID sales agent; define region / group; define AgentID / group; define sales / analysis sum; define agent /computed "Number of Agents"; compute before region; count=-1; endcomp; compute agent; if agentid ne lag(agentid) then count+1; agent=count; endcomp; break after region/ summarize skip ol ; run; [/pre] Ksharp Message was edited by: Ksharp ... View more

Function : strip(ZORTNAME) would be helpful... Ksharp ... View more

🙂 ... View more

Hi. You can use 'ods exclude' statement to exclude the sup-report you want. Using 'ods trace on' to view the name of "Observations summury" sub-report. You can find some 'ods' example at this forum. Ksharp ... View more

Hi. From your data structure ,I guess your data is matched data,right? if it is so, then first calculate the difference of these two variables ( i.e. dif=var1-var1), then for this dif using proc ttest or using proc n1parway Wilcoxon-rank-sum-test(strongly reference to, for the sake of nonparameter method). Ksharp ... View more

Hi. tjeller is right.Your data is ordinal categorical data ,better to use proc freq' measure options. and what is your meaning at the first question?Does say the frequencies of each group of the satisfoed and informed? then use list option. [pre] proc freq data=sashelp.class; tables sex*name /list; run; [/pre] Ksharp ... View more

Hi. proc report 's computed statement can do . Cynthia@sas has ability to do it. You need to post some data sample and the result which you wanted. Ksharp ... View more

Hi. I meet the same problem before. You can click 'break' button to cancel the code you submited,then SAS can work. ... View more