Learning R by redoing all the work I’ve done in SAS lately. Is it me being slow or is SAS much quicker in data prep/cleaning? Manually recoding 35 ordinal variables and setting levels is 10x as long

Posting as :
works at
You are currently posting as works at

In any given language there are usually many ways to do something like this, some faster than others. My guess is you’ve learned to be fairly efficient in SAS but while you are learning the basics of R you haven’t learned to do things efficiently in it.

like

R is a different beast. A ton of useful packages are available to do data prep - learn the crap out of tidy and dplyr if you want to save your sanity

like

Learn the R Tidyverse that Hadley Wickham created. I did my masters doing a lot of SAS and it is trash compared to other data science languges. Trying to stop thinking in SAS helps a lot, R is a language people can be experts in a package without knowing a different library/package.

like

Thanks all- I’m still on the basic basics so I’m probably doing things the long way anyway Dplyr is about 1 chapter away though!

like

Damn! You will get there. There’s a simple function you can write to recode the ordinal variables. Infact, there are packages which do that for you. Rock chalk is one. Same with setting levels.

One of the tips I’ll give you is that after you do this one, save this script because I bet, you would have to use this on multiple projects. Infact, even in your current project in case the reqt changes later. I have learnt it the hard way :-)

like

SAS is better for data monkey work for many reasons. Automation with macro language, pull data natively with pass through sql, can multithread jobs if on multicore sever...and so on. And you can still run R from SAS, so why not just keep SAS and run R from it?

like

If you're manually doing something, write a function to do it faster.

KPMG 1 the good news is I wasn’t coding in SAS I was using their drag and drop platform lol

What ZS said x100. The beauty of R is reusability. I have about a dozen core pieces of code that get mixed and matched like utensils in a kitchen

If you use functions repeatedly make yourself a package that you can load. It is easier than it sounds.

Related Posts

How many GPS Manager Bands are there at Deloitte

Joining BCG as a Project Leader soon and am curious what onboarding is like. Is it just at your home office or somewhere else?

like

Entry level employees: How much did you get paid upon joining Slalom?

like

Hiring manager advice . I have a business leader with very unrealistic expectations . My team are performing well but they keep asking for more. How do I set realistic expectations while building trust. My team is delivering good results, but he’s never happy!

like

Hi, I'm a new member and I need help. I have 31 likes from my posts and replies but I'm still not able to DM others. I suspect it's the first love icon that needs to be 11. What is this love icon with a count of 10, and how can I earn 1 more?

Post Photo
likesmartupliftinghelpful

How do you get over casing nerves? Have a phone case coming up soon and feeling nervous.

like

How many times would you your boss/managing attorney scream/berate you (not just frustration) before you quit? Some context: Yesterday morning managing attorney comes in legitimate screaming at me because I forgot (for the first time in over a year of employment) to lock the door when I arrived, he then brings up something that happened earlier in the week where I didn’t get clients payment info, instead emailed assistant to run payment since I’ve never been taught how to accept payment.

like

Can anyone provide job referral to Informatica. I am an immediate joiner

like

genuinely haven’t accomplished a single task today & can’t focus

likeupliftinghelpful

I feel myself slipping into a deep depression. I hate this job but I don’t know what other skills I have to leave it. Not really a question more of just a confession I guess.

like
like

For transactional attorneys, when did you finally start to feel like your draft documents were less redlined? Cant help but feel like my documents are heavily redlined but I really am trying my best.

like

Making the fall schedule
is crazy!!

like

How many of y'all are on CCPA projects and how are you staying sane?

Thoughts on specialty life insurance? I don’t have my LLQP. This is based in canada. They are offering paid training

like

How do you keep all of your notes-to-self organized? Not actual work product or drafts, but the kinds of things you jot down in meetings or as you’re working (e.g., “client prefers DE choice of law over NY” or “x agreement is best example of negotiated MSA”). I’m using OneNote, but I’m curious how others do it.

Bonus points if you have ADHD and you use this type of thing as a lifeline 🙃

like

My LWD was on 8/08/22 but still Capgemini has not updated the same in EPFO portal because of which I am not able to transfer my PF. Any idea whom should I contact for this?

I am looking to buy a quality laptop for programming and video editing. Speed, security and memory are important to me. What laptop would you recommend and why? I was thinking of getting the Apple MacBook Pro but a friend said there are better ones out there and that Apple is just overhyped because of the strong brand. Should I listen to this advice or not?

like

Can anyone comment on the VCA guilloche 5 motif bracelet durability? I’m treating myself to a promotion gift and am looking for a piece from VCA I can wear everyday. Open to suggestions! And would love to see pictures of your pieces ☺️

like

Any senior level writers looking for a job in LA? have a lead on a gig that requires a team. Message me with your book if so.

like

Additional Posts in Data & Analytics Consultants

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

What’s the best company for machine learning projects?

like

Does anyone know of any companies that have programming assessments as a barrier to entry? Would love to give it a shot as I’m a strong programmer but don’t have any formal schooling/experience

likehelpful

Analytics 💵 transparency thread!


Format:
Title level (standardized title/job level)
Economic area (Bay Area, Midwest, etc)
Salary + bonus + liquid equity
Anything else you think would help

likesmarthelpful

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

Hi All,
I have a question about replicating an Alteryx model in python. Basically the Alteryx model used to clean, combine, prep, run some business rules and spit out a formatted file ready for running further analysis/viz. Can this same process be automated using a python script? I’m new to python and would like to know what packages to learn to do this.
Thanks!

like

I studied for 2 months with a friend and doubled my income to 200k+ the consulting game is a a racket and to that extent big tech is too BUT big but tech and large streaming companies actually pay top dollar for good talent that can code . These suits have been lying to you ALL. Wake up in the morning and studying my friends you do not need these consulting firms they need you! Do not feed into there bs…studying for interviews and get you fare share of this tech wave… I am making more than my Ms

likefunny

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

Data engineering or data science as your starting career for job security and ease of moving around to different jobs?

like

Hey all. Question regarding Presto SQL and Arrays.

I’m working within a Presto DB and the column contains a nested array. I need to pull out the 3rd item of each array. Does anyone got any info on how to approach this?

like

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

like

DC folks: how’s Clarabridge (company)? Thanks

I’m interested in going back to school for an analytics degree. I have a math & stat undergraduate degree and have been doing data science in my projects. Does anyone have recommendations for...

like

I need a new laptop. Not sure what to look for other than a SSD, 16 GB Ram, and an i7 processor. Fine with Apple or Windows. What else should I look for if I want to do a lot of my own kaggle and

If you’re hiring for sr analyst roles , what tradeoff would you be comfortable ? Business acumen and prior knowledge of industry/ function or core data analytics skills ? Need both at end of day but candidates are strong in only one of the two areas. Assume candidates are coachable and willing to learn.

like

I am finishing up a project and I’m trying to document what I’ve done for my resume. What are some good metrics for someone who mainly created user stories, created dashboards, interacted with the client and developed statistical models? One of my dashboards got deployed to production but it’s to early to see the impact. My other dashboards are almost done but I’m moving on to something else.

like

Any highly recommended videos or resources that give a comprehensive approach to sales forecasting?

like

Is it possible to switch from data analytics to strategy? If so, what kind of strategy? I’m still thinking about career possibility. Thank you

like

Can someone tell me how log loss values can be used to compare two classification models? I understand the concept of log loss value but I don't quite get how two models can be compared using this metric. Is it as easy as saying, all things equal, one that has a lower log loss value is a better model?

like

Does anyone work for a company that is paying for them to get an MS in Data Science or Business Analytics? If so, where?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal