Hello exRhodesian, This is a solution: [pre] data X; input name $ score; datalines; A 1 A 3 A 7 B 2 F 2 F 9 K 1 K 8 P 2 P 8 P 9 run; proc sort data=X; by name; run; proc transpose data=X out=Z (drop=_:) prefix=s_; var score; by name; run; [/pre] Sincerely, SPR ... View more

Could you please give an example of your data. I printed freq from my code: [pre] proc print data=freq label; var Count; run; [/pre] Variable Count has label "Frequency Count" and it is printed without truncation. ... View more

Hello Veblen, You can output a frequency table into a dataset and then print it with any desired format: [pre] proc freq data=sashelp.class noprint; tables age /out=freq; run; [/pre] Sincerely, SPR ... View more

Hello Edie, Your question is more appropriate for a special EG forum: http://support.sas.com/forums/forum.jspa?forumID=10 Sincerely, SPR ... View more

Hello SSS, It is more like this: [pre] data Shoes (KEEP =REGION TOT_SALES rank); set sashelp.shoes; if FIRST.region then do; TOT_SALES=0; Rank+1; end; TOT_SALES+SALES; if LAST.region then output; by region; run; [/pre] Sincerely, SPR Message was edited by: SPR ... View more

Hello Jdub, Look at nway description in SAS help it explains the use of nway in detail. "I am guessing you used nway b.c. you have two classes, yes?" it does not matter how many classes do you have. For example, in your code you have only one class but Meanvalue contains means for total dataset (not divided in classes for _type_=0 ) and for each value of the class (_type_=1). If you add nway option then only means for different values of class variable are calculated. If you have several classes then with nway option proc means calculates means for all combinations of class values. Sincerely, SPR ... View more

Hello Statadm, This is a possible solution: [pre] data i; E4CONT=1; E4_AGE=2; E4_DATE=3; run; %macro a (in=E4, out=E1); proc SQL; select COUNT(distinct name) as n into :n from sashelp.vcolumn where libname="WORK" and memname="I" and SUBSTR(UPCASE(name),1,2)="&in"; %let n=%TRIM(&n); select distinct name as names into:n1-:n&n from sashelp.vcolumn where libname="WORK" and memname="I" and SUBSTR(UPCASE(name),1,2)="&in"; quit; data i; set i; rename %do i=1 %to 3; &&n&i=&out.%SUBSTR(&&n&i,3) %end; ; run; %mend a; %a(in=E1, out=E5); [/pre] Sincerely, SPR ... View more

Hello Jdub, This is a solution: [pre] data i; input year month quarter value; datalines; 1992 1 2 10 1992 2 2 11 1992 3 2 12 1992 4 3 21 1992 5 3 22 1992 6 3 23 run; proc means data=i nway noprint; output out=Mean(drop=_:) Mean=Mean; var value; class Year Quarter; run; [/pre] Sincerely, SPR ... View more

Hello Sreeram, If I understand you correctly then E9/L=E9/1000 cubic centimeters = E9/E6 cubic millimeters = 1000/cubic millimeters g/L = g/E6 cubic millimeters=E-6 g/cubic millimeter. Sincerely, SPR ... View more

Hello Valentin, One of the possible solutions is to loop of this macro making a slight change in its code, namely output testpos as a macro variable, and loop untill testpos=0 like this: [pre] %macro replace (dataset = , chkvar = , search = , replace =, newvar = ); %global tp; data &dataset (drop = textpos) newvars; length &newvar $ 200; set &dataset; textpos = index(upcase(&chkvar), upcase("&search")); CALL SYMPUTX('tp',textpos); oldvar = &chkvar; if textpos ne 0 then do; if textpos ne 1 then &newvar = substr(&chkvar, 1, (textpos - 1)) ||"&replace"||substr(&chkvar, (textpos+length("&search"))); else &newvar = "&replace"|| substr(&chkvar, (textpos + length("&search"))); output newvars; end; else &newvar = &chkvar; output &dataset; run; proc print data = newvars; title “SEARCH FOR ‘&search’ AND REPLACE WITH ‘&replace’”; var oldvar &newvar; run; %mend replace; %macro a; %global tp; %do %until (&tp = 0); %replace (dataset = a, chkvar = a, search = dg, replace = yy, newvar =a ); %end; %mend a; data a; a="asdgdfgdg"; b="dg"; run; %a [/pre] Sincerely, SPR ... View more

Hello PHK, What do you want to achieve? If you want to simply renumber you accounts after deleting it is very easy to achieve using n+1 statement. Or you need something else? Sincerely, SPR ... View more

Hello Ncsthbell, As far as I know promts are related to programs only. If you code something and run it then prompts will appear. Sincerely, SPR ... View more

Hello Nithin, Is it correct to have a semicolon in the parameters of grdsvc_enable or is it a typo? Sincerely, SPR ... View more

Hello Vlange, SAS has a bootstrap macro: http://support.sas.com/kb/24/982.html However, I agree it is not so simple to use it. Sincerely, SPR ... View more

Look at the File menu. It contains the list of recent projects. ... View more