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 are the joins,types of joins and thier functions?
For what purpose(s) would use the RETURN statement?
data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.
What are symget and symput? : sas-macro
What is data _null_?
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
Difference between sum function and using “+” operator?
Differentiate between format and informat? : sas-grid-administration
What is slibref?
Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.
What is the use of divide function?
What is the general format of function in sas? : sas-grid-administration