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

Name and describe few sas character functions that are used for data cleaning in brief.

1184


What is the difference between reading data from an external file and reading data from an existing data set?

1232


explain the function of substr in sas? : Sas-administrator

1069


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1929


Describe the ways in which you can create macro variables?

1254


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1193


What is a put statement?

1274


Give an example where SAS fails to convert character value to numeric value automatically?

1135


Mention sas system options to debug sas macros.

1241


explain the proc in sas? : Sas-administrator

1133


What do you know about sas data set?

1194


Can you explain the process of calendar?

1159


What is the difference between %put and symbolgen? : sas-macro

1301


To what type of programms have you used scratch macros?

2611


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2088