topic Re: Help me to get the Job. in SAS Studio

Help me to get the Job.

seamoh — Wed, 20 May 2020 18:32:51 GMT

Hello all members in the community. For getting job in a pharmaceutical company, I am told to learn SASS programming to make the tables and list( nothing more. I don't need to learn statistical analysis) and I will be tested on that. Please introduce me right to the points resources ( books, tutorials and ...) to learn and get experience in making tables and lists in SAS.( I should mention I have relatively background in computer programming and database but I have been in SAS area for about 8 days).

Thank you again for your help. Deeply appreciated.

Re: Help me to get the Job.

Reeza — Wed, 20 May 2020 19:09:21 GMT

1. Complete the free SAS programming 1 course (2/3 days)

2. Go through the code in this paper, you should be able to write those programs from scratch in the type of job you're applying for, specifically Example 8 https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/173-2008.pdf

3. Read the documentation for and play around with PROC MEANS, FREQ, REPORT and TABULATE. Go through each of the examples for each of those procedures.

Re: Help me to get the Job.

Ksharp — Thu, 21 May 2020 11:10:59 GMT

Calling @data_null__ @Tom

Re: Help me to get the Job.

seamoh — Fri, 22 May 2020 17:41:10 GMT

Hello and thank you very much for the reply. If you give me some resource to practice making tables and lists( reports) from an excel file . it would help me a lot..

Thank you again.

Re: Help me to get the Job.

Reeza — Fri, 22 May 2020 18:17:43 GMT

Once the data has been imported into SAS the process is the same regardless of the original source of data, Excel, CSV or a DB.

Here's an additional example of a macro I wrote when I worked on clinical trials that I found made my life easier. This is likely the type of work they're expecting you to be able to do.

https://gist.github.com/statgeek/2f27939fd72d1dd7d8c8669cd39d7e67

Re: Help me to get the Job.

Reeza — Sun, 24 May 2020 19:56:47 GMT

https://communities.sas.com/t5/SAS-Communities-Library/Demographic-Table-and-Subgroup-Summary-Macro-TABLEN/ta-p/634030

Re: Help me to get the Job.

seamoh — Wed, 10 Jun 2020 20:36:01 GMT

Hi Reeza and thank you very much for your helps. Reeza recently the hiring manager asked me this question?

"Can you think of a data set and generate a table that you as a clinician wants to see"

Honestly I couldn't understand his question because I think there are lots of different tables may a clinician want to see? what is your idea about his question, if you clarify me about his question, I will step right to the point.

Thank you again.

and I am looking forward your answer.

Re: Help me to get the Job.

seamoh — Mon, 15 Jun 2020 18:21:48 GMT

Reeza, would you please describe more the macro for me and tell me how to use it?

Thank you very much and deeply appreciated.