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.
- 4 Answers
- 6226 Views
- Symphony, I also Faced
- E-Mail Answers
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
Tell me more about the parameters in macro? : sas-macro
Explain the difference between using drop = data set option in set and data statement?
How do you define proc in sas? : sas-grid-administration
for report generation which one you used proc report or data_null_?
How do you control the number of observations and/or variables read or written?
Of all your work, where have you been the most successful?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
what is the difference between nodup and nodupkey options? : Sas programming
Explain the main difference between the sas procedures and functions? : Sas-administrator
Differences between where and if statement?
What are the special input delimiters used in SAS?
How do dates work in sas?
Differentiate between ceil and floor functions.
What will calendar procedure do?
