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
Name and describe few sas character functions that are used for data cleaning in brief.
What is the difference between reading data from an external file and reading data from an existing data set?
explain the function of substr in sas? : Sas-administrator
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
Describe the ways in which you can create macro variables?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What is a put statement?
Give an example where SAS fails to convert character value to numeric value automatically?
Mention sas system options to debug sas macros.
explain the proc in sas? : Sas-administrator
What do you know about sas data set?
Can you explain the process of calendar?
What is the difference between %put and symbolgen? : sas-macro
To what type of programms have you used scratch macros?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com