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
This entry was posted in General. Bookmark the permalink. Post a comment or leave
What does PROC print, and PROC contents do?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
what is SAS OPTIMIZATION?
Describe the function and untility of the most difficult SAS macro that you have written.
What is the difference between INPUT and INFILE ?
how will you location sas platform applications available from web browser? : Sas-bi
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
Difference between informat and format?
What is program data vector (pdv)?
Describe a time when you were really stuck on a problem and how you solved it?
what is sas business intelligence? : Sas-bi
What are the data types does SAS contain?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
it will become easy if uuu provide website linkssss and list of consultanciessssss