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
What are the different versions of sas that you have used until now? : sas-grid-administration
Explain what is the use of proc gplot?
Are you involved in writing the inferential analysis plan? Tables specifications?
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is the difference between order and group variable in proc report?
Explain the difference between using drop = data set option in set and data statement?
what is the difference between infile and input? : Sas-administrator
Briefly explain input and put function?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Explain by-group processing?
What is a method to debug and test your SAS program?
Can you execute a macro within a macro? Describe. : sas-macro
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
how to remove duplicates using proc sql?
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?