data one; infile datalines missover; input age; if age is missing then age=9999; else age=age; cards; 8 01 20 0 1 2 ; proc print; run; ... View more

Q1.  How can we order the population in Ascending order in the following proc report step? Q2.  Why the format option is not working in the following define statement in proc report step? data one;   input Name $1-19    Capital    $21-35 Population    Area    Continent $57-71 UNDate;   cards; Afghanistan            Kabul            17070323    251825    Asia            1946 Albania                Tirane            3407400        11100    Europe            1955 Algeria                Algiers            28171132    919595    Africa            1962 Andorra                Andorra la Vell    64634        200        Europe            1993 Angola                Luanda            9901050        481300    Africa            1976 Antigua and Barbuda    St. John’s        65644        171        Central America    1981 Argentina            Buenos Aires    34248705    1073518    South America    1945 Armenia                Yerevan            3556864        11500    Asia            1992 Australia            Canberra        18255944    2966200    Australia        1945 Austria                Vienna            8033746        32400    Europe            1955 Azerbaijan            Baku            7760064        33400    Asia            1992 Bahamas                Nassau            275703        5400    Central America    1973 Bahrain                Manama            591800        300        Asia            1971 Bangladesh            Dhaka            1.26E+08    57300    Asia            1974 Barbados            Bridgetown        258534        200        Central America    1966 proc print; run; proc report data=one nowd headline ;   column continent population, sum;   define continent / group;   define population / 'TotPop' format=comma15.;   where Population gt 1000000; run; ... View more

7 DATA test; 8 LENGTH a $6 ; 9 a="11345";  x=INPUT(a,10.2); xy=INPUT(a,10.); output; 10   a="11.345"; x=INPUT(a,10.2); xy=INPUT(a,10.); output; 11   put _all_; a=11.345 x=11.345 xy=11.345 _ERROR_=0 _N_=1 ... View more

data two; input Name $20. Number $22-34; Last=scan(name, -1); cards; Jeff W. Snoker          (908)782-4382 Raymond Albert          (732)235-4444 Alfred Edward Newman (800)123-4321 Steven J. Foster      (201)567-9876 Jose Romerez          (516)593-2377 ; proc report data=two nowd; column name Number last; define last / order noprint; define number/ 'Phone Number' ; run; This is the code for report in Ascending order of last variable. But I want the Names and Phone Numbers in descending Alphabetical Order by Last Name. Can any one help? ... View more

77 78   data _null_; 79   x=intck('weekday17w', '01jan12'd, '31dec12'd); 80   y=intnx('weekday17w', '01jan12'd, 1); 81   put x= +1 y date.; 82   run; x=261  02JAN12 NOTE: DATA statement used (Total process time):       real time           0.12 seconds       cpu time            0.00 seconds ... View more

data best;     input patient 1-2 arm $ 4-5 bestres $ 6-7 delay 9-10;   datalines; 01 A CR 0 02 A PD 1 03 B PR 1 04 B CR 2 05 C SD 1 06 C SD 3 07 C PD 2 01 A CR 0 03 B PD 1   ; run; proc sort data=best nodup out=ex2;   by arm patient; run; ... View more

data two; input Id $    No   Variety $18-26      Quantity   ; cards; 240W    15743    Protea          120     240W    15743    Protea          180     356W    15744    Heliconia         .     356W    15744    Anthurium       300     188R    15747    Ginger           24     188R    15747    Anthurium        24     240W    15748    Heliconia        48     240W    15748    Protea           48     356W    15748                      . data one; set two; do i=id until (variety='Ginger'); newid=6||id; end; proc print; run; ... View more

data _null_;    string1='*' || tranwrd('abcxabc', 'abc', trimn('')) || '*';    put string1=;    string2='*' || tranwrd('abcxabc', 'abc', '') || '*';    put string2=; run; string1=* x * string2=* x * ... View more