I am looking for edit the data GiftOriginal.   In the column Toy where a observation appear less then 3  times(Bicycle and Plane) I want to rename "diverse".   The data ManuallyFormated is what I am looking for as a result.   Any idea how I can do that?   data GiftOriginal; input ID$ toy$ town$; cards; Jensen Doodle Columbus Tom Car Dayton Mathew Truck Columbus Zhin Doodle Columbus Gylbert Car Columbus Luke Bicycle Columbus Barbara Doodle Columbus Judy Doodle Dayton Dennis Truck Dayton Anthony Car Dayton Ian Plane Dayton Ruan Car Dayton Santiago Truck Dayton Uin Doodle Columbus Josh Car Columbus run; data ManuallyFormated; input ID$ toy$ town$; cards; Jensen Doodle Columbus Tom Car Dayton Mathew Truck Columbus Zhin Doodle Columbus Gylbert Car Columbus Luke DIVERSE Columbus Barbara Doodle Columbus Judy Doodle Dayton Dennis Truck Dayton Anthony Car Dayton Ian DIVERSE Dayton Ruan Car Dayton Santiago Truck Dayton Uin Doodle Columbus Josh Car Columbus run;   ... View more

In a specific column I have many repeated informations like:   red blue yellow white red blue yellow red blue yellow   Any thought how could proceed to rename a cell when it has a low frequency?  In the sample above I would like to rename  white as other since it has frequency 1.   Thanks,   ... View more

I have a column with multiple lines.   Many contents are similar with the word "export" present in the column "Reason", example:   at line 1 there is = Export to Canada at line 2 there is = export Mexico at line 3 there is  = export Japan at line 3 there is  = export    many other lines don't have the export.   Is there a single way to make SAS delete the lines where the word "export" is present in the column"Reason"? ... View more

I have a table with multiple ID`s(city) I want to create a new one with one line per ID. Some ID's have more than one information in other columns like for Type and K value, For type, I want to create 2 new columns in the final table. One counting how many different types was inside the original data(example: for city G I would like to have a value of and another; column calling that Type as multiple. For K value I just want to have in the final table a value as sum. City Type k value A House 130 B Building 405 C Apartment 155 D Building 1110 D House 300 E Apartment 230 F Apartment 165 G Building 2500 G House 250 G House 220 H Apartment 185 H House 250 H House 580 H Apartment 570 ... View more

I am pretty new on SAS and I am not getting to create a new variable in SAS based on a date variable with the format  monname9.  I want to add the year season for each month in the monname9. date, for example, I want to create a variable called Year Season for December, January and February I want to put "winter" March, April and May I want to call "spring" June, July and August call "summer" and the other 3 months "fall" this should repeat for some years in my data.   Any thoughts how I could do that? Thanks ... View more