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

How do you specify the number of iterations and specific condition within a single do loop?

615


Describe the ways in which you can create macro variables?

625


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

630


How necessary is it to be creative in your work?

2014


Did you used proc test? when?

1569






What are the advantages of using sas?

601


What is the good sas programming practices for processing large data sets?

621


Given an unsorted data set, how to read the last observation to a new data set?

827


explain what is factor analysis? : Sas-administrator

594


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

600


Mention some common errors that are usually committed in sas programming.

584


What are the default statistics for means procedure?

634


What is SAS informats?

627


What are the applications primarily used by business analyst? : Sas-bi

548


what is study design in while working with SAS? what are screening variables in SAS?

1675