Interested to Buy Any Domain ? << Click Here >> for more details...
Code a PROC SORT on a data set containing State, District
and County as the primary variables, along with several
numeric variables.
- 7 Answers
- 16123 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Differentiate between ceil and floor functions.
Tell me about % include and % eval? : sas-macro
I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;
Where do you use proc means over proc freq?
What are the five ways to do a table lookup in sas? : sas-grid-administration
explain the use of % includes a statement in sas? : Sas-administrator
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
what is the difference between infile and input? : Sas-administrator
what is the use of proc contents and proc print in sas? : Sas-administrator
What will calendar procedure do?
Explain input and put function?
Teradata 
