About JibJam221

JibJam221 · ‎05-19-2022

thank you! Do you know how I can extract these records into a separate SAS dataset?

JibJam221 · ‎05-19-2022

Hi all, im trying to create a code that can clean my database. Basically, I am trying to clean the database from invalid record entries (i.e. therefore removing records containing responses using special characters such as $, #, % and pasting them into a separate SAS table). The column name with special containing responses needing cleaning is "ID_Response". I dont have a code to share because im not sure where to start. Any recommendations?

JibJam221 · ‎05-16-2022

I also tried this and it worked as well! Thank you so much

JibJam221 · ‎05-16-2022

it worked! Thank you!!!

JibJam221 · ‎05-16-2022

Hi all, im having some issues changing one of my variables from Character ($CHAR1.) to numeric (BEST12.) so that I can append it to another table. The variable's format that im trying to change is a pre-existing variable within the dataset. Here is my current code: data work.test2; set work.test; SYD=input(SYD,BEST12.); run; when I run this code, I dont get any errors or warnings however the variable doesn't change formats. Any suggestions on what I can do? Thanks!

JibJam221 · ‎10-31-2021

Sorry I meant to say that test_date didnt change to a NUM variable. Any suggestions on how to make test_date a NUM var?

JibJam221 · ‎10-31-2021

Hi everyone, I am having issues changing my DATE column from a CHAR to a NUM so that I can do a join with another table. The code runs, however when I check the properties, the "accurate_episode_date"'s property is still CHAR. Here is the code: data main2; set covid.covid; format test_date mmddyy10.; test_date = input(Accurate_Episode_Date,date9.); run; Thanks

JibJam221 · ‎10-29-2021

hello, quick question. I updated my code to categorize the entire dataset. Here is my code: data work.tester4; set work.tester4; if province="ON" and city="Toronto" then Region="Toronto"; else if province= "ON" and city^="Toronto" then Region="Outside of Toronto"; else if province="AB" and city="Calgary" then Region="Calgary"; else if province="AB" and city^="Calgary" then Region="Outside of Calgary"; else Region="N/A"; run; I am recieving the following error: WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. is this a reason for concern? The warning is highlighted as the 'run;' statement. thanks

JibJam221 · ‎10-29-2021

WOW good catch! Its always the little things. I appreciate your help!

JibJam221 · ‎10-29-2021

thanks for your help, when I remove the END, all columns delete and I am left with three blank columns: Province, City, and Region. I'm not sure what is going wrong, but there is no errors or notes in the log

JibJam221 · ‎10-29-2021

Hello, I am trying to make a code that can help me recategorize my tables. The variables that will be conditioned are: Province and City. Basically, if Province is = to Toronto and the Province is Ontario, i'd like the region to be categorized as "Toronto". If province is = to Ontario and city is NOT equal to toronto, id like region to be categorized as "outside of toronto". Here is the code I have: data work.tester2; if province="ON" and city="torontp" then Region="Toronto"; else if province= "ON" and city^="toronto" then Region="outside of toronto"; end; run; when I run this code, all fields go blank. Thanks

JibJam221 · ‎10-28-2021

Hi everyone, I am trying to use the UPCASE function to make values in column "Login" from lowercase to uppercase, pasting it into column "USERID. my issue is im gettting blanks in return. The layout of the Logins are 3 characters and 3 numbers, for example: aaa222, aaa333, aaa444, etc. I would like these to be: AAA222, AAA333, AAA444, etc. Here is my code: data work.people; set work.people; Login=upcase(USERID); run; This is what my output looks like:

JibJam221 · ‎02-08-2021

thank you!

JibJam221 · ‎02-08-2021

it works! Thank you x a million!

JibJam221 · ‎02-07-2021

thank you for this! Question - do you know if there is a way to do this for character variables as well?

Online Status	Offline
Date Last Visited	‎11-24-2023 12:56 AM

Re: Struggling with left join - records from table B appearing

Struggling with left join - records from table B appearing

Re: INDSNAME from Temporary to Permanent

Re: INDSNAME from Temporary to Permanent

Re: INDSNAME from Temporary to Permanent

Re: INDSNAME from Temporary to Permanent

Re: INDSNAME from Temporary to Permanent

INDSNAME from Temporary to Permanent

INDSNAME from Temporary to Permanent

Re: How to concatenate 2 columns and have the output read into an exis...

Re: PROC REPORT

Re: PROC SQL: Sum

Filling empty cells with another column`s variable

Re: If-Then Statement help

Re: Cleaning database from invalid entries

Cleaning database from invalid entries

Re: Changing pre-existing character variable to numeric variable

Re: Changing pre-existing character variable to numeric variable

Changing pre-existing character variable to numeric variable

Re: Changing date column from CHAR to NUM

Changing date column from CHAR to NUM

Re: If-Then Statement help

Re: If-Then Statement help

Re: If-Then Statement help

If-Then Statement help

Upcase function not working

Re: Filling empty cells with another column`s variable

Re: Filling empty cells with another column`s variable

Re: Filling empty cells with another column`s variable