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
What do the SAS log messages "numeric values have been converted to character" mean?
what is sas olap server? : Sas-di
How do you define proc in sas? : sas-grid-administration
where are dashboard components are created and maintained? : Sas-bi
Explain the use of proc gplot? : sas-grid-administration
What versions of SAS have you used (on which platforms)?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
Mention what is PROC in SAS?
What is the difference between match merge and one to one merge?
What is connection profile? : sas-grid-administration
What are the implications?
what is sas database server? : Sas-di
What is the difference between order and group variable in proc report?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
what is hash files in sas and why we are using this one in sas?