Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can we use where and having clauses in a single SAS program.

ex: proc sql;
    select a,b,c from test
     where state in 'KA'
     and having <some condition>.

Is the above program run correctly, if not why ?
    

Answer Posted / santhosh

worng

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do you debug and test your sas programs? : Sas programming

1170


What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1251


how does sas handle missing values in functions? : Sas programming

1282


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4592


Why and when do you use proc sql?

1286


What is the difference between the proc sql and data step?

1222


In ARRAY processing, what does the DIM function do?

1231


What is the role of unrestrictive users? : sas-grid-administration

1075


what are validation tools that are used in sas? : Sas-administrator

1115


Explain input and put function?

1186


Enlist the syntax rules followed in sas statements.

1128


Explain how merging helps to combine data sets.

1110


what are the categories that sas informats are used to the place the data? : Sas-administrator

1095


what is the difference between infile and input? : Sas-administrator

1194


how to remove duplicates using proc sql?

1198