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
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?
How to include or exclude specific variables in a data set?
Explain the purpose of substr functions in sas programming.
what are input dataset and output dataset options? : Sas programming
How you can read the variables that you need?
What is the basic structure of a sas program?
If you could design your ideal job, what would it look like?
If a variable contains letters or special characters, can it be numeric data type?
what is null hypothesis? why do you consider that?
What is the difference between %put and symbolgen? : sas-macro
what is the use of proc contents and proc print in sas? : Sas-administrator
how many types prompting framework can be broken down to? : Sas-bi
how the sas basic syntax style described? : Sas-administrator
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what is hash files in sas and why we are using this one in sas?