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 |
Which is the best training Institute for SAS Business Intelligence course?
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
what is factor analysis? : Sas-administrator
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
How would you remove a format that has been permanently associated with a variable? ________________
Mention what is the difference between nodupkey and nodup options?
explain the concepts and capabilities of business object? : Sas-bi
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Explain what is data step?
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...