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 is Linear Regression?
How do dates work in sas?
Describe the function and untility of the most difficult SAS macro that you have written.
what is the use of sas management console? : Sas-di
Intern stastical programmer written test
what is the effect of the options statement errors=1? : Sas programming
What are the statements in proc sql?
What are the different servers in sas? : sas-grid-administration
what are the benefits of data integration? : Sas-di
explain about sas business intelligence? : Sas-bi
Enlist the functions performed by sas.
How do you control the number of observations and/or variables read or written?
How would you define the end of a macro?
Briefly explain input and put function?
how does sas handle missing values in procs? : Sas programming