About sasnewbie5

sasnewbie5 · ‎12-11-2018

I adjusted the code so now it doesn't show blanks, but it lists the dates as 4 digit numbers with some being positive and others negative. Any advice?

sasnewbie5 · ‎12-11-2018

Can someone help me adjust the below code so that values show for both the "salary" and "hdate" variables? filename sales1 "/folders/myfolders/sascode/sales1.txt"; data US_trainees AU_trainees; infile sales1; input ID 1-6 LName $ 21-39 Title $ 43-63 Salary 64-72 Country $ 73-75 Hdate:mmddyy10 87-97; informat Hdate mmddyy10; if country = "US" then output US_trainees; else output AU_trainees; keep ID Lname Title Salary Hdate; run;

sasnewbie5 · ‎12-11-2018

Thank you @ballardw. I'm not familiar with the informat function. Could you help me with applying that to the below code? filename sales1 "/folders/myfolders/sascode/sales1.txt"; data US_trainees AU_trainees; infile sales1; input ID 1-6 LName $ 21-39 Title $ 43-63 Salary 64-72 Country $ 73-75 Hdate 87-97; format Hdate mmddyy10; if country = "US" then output US_trainees; else output AU_trainees; keep ID Lname Title Salary Hdate; run;

sasnewbie5 · ‎12-11-2018

I have a .txt file that I need to use to create two data sets with one data step: one dataset contains people from the US and the other contains people from AU - the country variable should not be kept in the output datasets. *Only people with the title sales rep are to be included. *Each dataset should only contain the fields with arrows by them. The code I have below has many notes in the log and doesn't list dates (I tried formatting), and I'm not sure how I'd separate it into two datasets based on country. Any help is welcomed and appreciated! filename sales1 "/folders/myfolders/sascode/sales1.txt"; data US_trainees; infile sales1; input ID 1-6 LName $ 21-39 Title $ 43-63 Salary 64-72 Country $ 73-75 Hdate 87-97; format Bdate mmddyy10; run;

sasnewbie5 · ‎12-11-2018

I have a .txt file that I need to use to create two data sets with one data step: one dataset contains people from the US and the other contains people from AU - the country variable should not be kept in the output datasets. *Only people with the title sales rep are to be included. *Each dataset should only contain the fields with arrows by them. The code I have below has many notes in the log and doesn't list dates (I tried formatting), and I'm not sure how I'd separate it into two datasets based on country. Any help is welcomed and appreciated! filename sales1 "/folders/myfolders/hw9/sales1.txt"; data US_trainees; infile sales1; input ID 1-6 LName $ 21-39 Title $ 43-63 Salary 64-72 Country $ 73-75 Hdate 87-97; format Bdate mmddyy10; run;

sasnewbie5 · ‎12-11-2018

That's good to know! I'm still learning about SAS but I definitely want to ensure I work smarter and not harder in regards to writing SAS code. Thanks for the tip!

sasnewbie5 · ‎12-11-2018

Thank you very much.

sasnewbie5 · ‎12-11-2018

Thank you for the reply @ballardw. I can't say that I know what to do with the information you provided (I'm really new to SAS and don't know all of the processes and terminologies, etc.), but I do thank you for taking the time to provide additional information.

sasnewbie5 · ‎12-11-2018

I'm not sure what you meant by not getting the data to read properly - not sure how I'd know that it didn't. I've done all I could do with providing sample data for you and don't know how to move forward in getting you additional information you say you need. So, I suppose I will keep trying to adjust my code to obtain the desired results. Thanks.

sasnewbie5 · ‎12-11-2018

As a new user of SAS, I'm trying to learn the best I can. I did test all code and interpreted the results based on my limited knowledge. With that being said, there's absolutely no need for you to be nasty nor rude about having "more important" things to do. Perhaps if you don't have the time to provide proper guidance/answers, you should not reply to any requests for real help. Thanks you, next.

sasnewbie5 · ‎12-11-2018

@ Paige, I hope this is what you mean. Please see below. data WORK.BONUS; infile datalines dsd truncover; input name:$8. salary:32. basedate:MMDDYY10. advanceddate:MMDDYY10. bonus:32.; format basedate MMDDYY10. advanceddate MMDDYY10.; datalines; CAMPBELL 104600 12/01/2012 01/01/2008 1046 EDWARDS 72300 02/01/2013 06/01/2010 723 MORRIS 87200 02/04/2013 11/01/2012 872 ROGERS 70700 07/01/2012 10/01/2008 707 SANCHEZ 103300 09/01/2012 11/01/2009 1033 ;;;;

sasnewbie5 · ‎12-11-2018

Thank you PaigeMiller. After adding that to the code, it only deletes the base dates that are less than 7 years. It doesn't appear to do it for the advanced dates. Do you perhaps have any input as to why? Thanks!

sasnewbie5 · ‎12-11-2018

Using the above screenshot of data, I am trying to determine the employees that are eligible for a 1% bonus. The certifications are only valid for seven years. Any certification tests passed over seven years ago from today’s date are expired. I need to eliminate those employees that have expired certifications in either Base or Advanced tests. Then output the remaining employees’ names, certification dates, and their bonuses to the output window using appropriate date and dollar formats. I can tell that only 2 employees are eligible for the bonus (Morris and Stewart), but I have no idea as to how write the code to output the desired results. Please help if you can!

sasnewbie5 · ‎12-11-2018

I know that only 2 of the employees (Morris and Steward) should get the bonus, but I'm not getting how to write a code to execute this.

sasnewbie5 · ‎12-11-2018

Perfect! Perhaps you can help me with this last part that pertains to this dataset. Based on the newly created dataset "Both", I need to determine which employees are eligible for a 1% bonus. SAS certifications are only valid for seven years. Any certification tests passed over seven years ago from today’s date are expired. I need to eliminate employees that have expired certifications in either the Base or Advanced tests. Then I need to output the remaining employees’ names, certification dates, and their bonuses to the output window using appropriate date and dollar formats. Could you assist with this?

Online Status	Offline
Date Last Visited	‎12-13-2018 11:42 AM

Re: Format variables in dataset

Format variables in dataset

Re: Create multiple datasets using one datastep

Create multiple datasets using one datastep

How to create dataset from raw data file?

Re: How to format date when creating a dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to create a character and numeric value with provided code?

Re: Format variables in dataset

Format variables in dataset

Re: Create multiple datasets using one datastep

Create multiple datasets using one datastep

How to create dataset from raw data file?

Re: How to format date when creating a dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

Re: How to delete/drop and add new variable to dataset?

How to delete/drop and add new variable to dataset?

Re: How to format date when creating a dataset?

Re: How to format date when creating a dataset?