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 / saurabh
Hi.
I don t know any specific reason why yu dont wan to use
proc format. It would be better if you use that as there
would be probably some more wines in the market where u can
apply this format of red wine....
Anyways I think you can try this.
* the content in brackets have to come from your program
proc sql;
update [dataset_name];
set [wine_name_field] = "Red Wine" where [wine_name_field]
="Malambo Shiraz Malbec 750ML(0388)";
exit;
let me know in case u require something else.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is factor analysis?
What is proc sort?
what is intially documentation in sas?
How to convert a numeric variable to a character variable?
how would you create multiple observations from a single observation? : Sas programming
How would you determine the number of missing or nonmissing values in computations?
What are the automatic variables for macro? : sas-macro
What do you know about sas data set?
What are types of transport files?
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?
Explain what Proc glm does?
Describe the function and untility of the most difficult SAS macro that you have written.
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Explain the difference between informat and format with an example.
How do dates work in sas?