Code a PROC SORT on a data set containing State, District
and County as the primary variables, along with several
numeric variables.
Answers were Sorted based on User's Feedback
Answer / lakshmi
proc sort data=data1 out=data2;
by district state country;
run;
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / chiranjeevi
data code;
infile'C:\Documents and Settings\admin\Desktop\country.txt';
input state$ district$ county$ population total;
proc sort data=code out=count;
by state district county;
run;
proc print data=count;
run;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / radhika rakesh
here some step has syntax errors lik in input statement its
mentioned as $ state and so but correct form is state $...
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pallavi
data abc;
infile 'c:\country.txt';
input &state &district &country population total:
proc sort data=abc:
by state district country;
proc print data=abc;
run;
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / prakash
data info;
infile 'C:\country.txt';
input $state $district $country population total;
proc sort data=info;
by state district country;
proc print data= info ;
run;
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / daya
data daya;
infile 'c:\country.txt';
input &state &district &country population total:
proc sort data=daya:
by state;
proc print data=daya;
run;
| Is This Answer Correct ? | 0 Yes | 3 No |
What is proc sort?
What are the default statistics for means procedure?
What are the data types in sas?
What is the difference between class statement and by statement in proc means?
what is the use of proc sql?
How would you identify a macro variable? : sas-macro
how do the in= variables improve the capability of a merge? : Sas programming
libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
if x=round(26.3,10)-1 then x= how much and how explain?
What do you know about symput and symget?
what is the Population you used in your project, is it ITT or PP?
0 Answers Accenture, Quintiles,