Have you brought the data into SAS? I suspect not.   If Nilu and Saksham are names it is likely that for some forms of analysis or summary you will want to have the data in SAS such that it looks like   Class Identity Hindi Eng Total 1 Nilu 10 12 22 2 Nilu 9 13 22 3 Nilu 8 12 20   For thing like: If I want to know which student class top on 7th class.? You may need to explicitly point to a row(s) of data and tell us what the rule for "top" would be. For instance would you be defining top as the Hindi score, the Eng score or the Total score?   ... View more

With proc means or summary the data need not be sorted first if using a CLASS statement to group your data.   proc summary data = data=auto21 nway; /* NWAY says to only output the full combinations when using class variables, don't use if you want to examine all of the combinations of class variables*/   /* where is also a valid statement in some procs*/    where COMPANY_STATUS='ACTIVE' AND COMPANY_CLASS='Public';    /* grouping variables*/    class COMPANY_STATUS;    /* analysis variables*/    var _PAIDUP_CAPITAL_;    output out= act12(drop=_type_ _freq_) max=; run;   _type_ is a special variable that describes which combination of class variables the output record belongs to, _freq_ is how many records were examined to get the statistics. ... View more

Dear Linush   First please allow me thank you for the answer ..!! And I would like to tell you that I m not crying for the ans. its just that i am new to sas supprt communities ..!!   So I am learning the thinks ..!! how to make it better..   Again thank you for your kind supprt & help..!!         ... View more

You do not provide enough information.  Is SAS installed locally on the machine?  If so you should just be able to point to a file on the network e.g: proc import datafile="\\somewhere\inthisdirectory\isthefile.xlsx" out=want replace; run;   If you use server based SAS, get your IT team to map any necessary drives in the startup, and assign correct access rights. ... View more