Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6947 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
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
What do you know about symput and symget?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
List out some key concept of SAS
Can you explain the process of calendar?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
what other sas products have you used and consider yourself proficient in using? : Sas programming
What are SAS/ACCESS and SAS/CONNECT?
how many types prompting framework can be broken down to? : Sas-bi
what is the use of proc sql? : Sas programming
What is SAS? What are the functions does it performs?
what is the effect of the options statement errors=1? : Sas programming
what is the use of proc contents and proc print in sas? : Sas-administrator
To what type of programms have you used scratch macros?
What does PROC print, and PROC contents do?
