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...

Hi I have list of products in a dataset,
which are classified by other name for eg:- there is a
product A> Malambo Shiraz Malbec 750ML(0388) which is a Red
wine.Now i need to generate a report where it shows if this
product appears then it should b displayed as red
wine,similarly for other products and other classification.
I dont wan use proc format.

Answer Posted / sheetal

above answer is correct. Just need to correct syntax
errors. Following is the corrected code,

proc sql;
update [dataset_name]
set [wine_name_field] = "Red Wine" where [wine_name_field]
="Malambo Shiraz Malbec 750ML(0388)";
quit;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4529


What does PROC print, and PROC contents do?

1172


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 ...

1354


what is SAS OPTIMIZATION?

2239


Describe the function and untility of the most difficult SAS macro that you have written.

2156


What is the difference between INPUT and INFILE ?

1242


how will you location sas platform applications available from web browser? : Sas-bi

1019


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1279


Difference between informat and format?

1045


What is program data vector (pdv)?

1195


Describe a time when you were really stuck on a problem and how you solved it?

2485


what is sas business intelligence? : Sas-bi

1102


What are the data types does SAS contain?

1055


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2063


it will become easy if uuu provide website linkssss and list of consultanciessssss

1926