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 / chandrakanth

please do not post complex answers if it can be done in very very simple.

data=dataset name;
set source dataset name;
if productA="Malambo Shiraz Malbec 750ML(0388)" then productA='Red Wine';
proc print data=dataset name;
run;

let me know if i am wrong

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different versions of sas that you have used until now? : sas-grid-administration

1031


Explain what is the use of proc gplot?

911


Are you involved in writing the inferential analysis plan? Tables specifications?

3696


Give some examples where proc report’s defaults are different than proc print’s defaults?

807


What is the difference between order and group variable in proc report?

1120


Explain the difference between using drop = data set option in set and data statement?

915


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

845


Briefly explain input and put function?

829


what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

825


Explain by-group processing?

784


What is a method to debug and test your SAS program?

979


Can you execute a macro within a macro? Describe. : sas-macro

858


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2290


how to remove duplicates using proc sql?

866


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1425