About oadeyemi

oadeyemi · ‎09-24-2019

I agree with you. Thank you for your explanation. The goal is to be as parsimonious as possible.

oadeyemi · ‎09-24-2019

I agree with you. Thanks for your explanation. Thanks for sharing the link too.

oadeyemi · ‎09-24-2019

Thank you for the response. Yes, that can work too. But x1 to x16 are long variable names. I am thinking of pooling them in a local macro and use the macro for the step. Do you understand my thought? Would it be more parsimonious? Something like this....(note: this is not SAS format) local a x1 x2 x3 x4 x5...x16 For each `var' in a.... ....and I plug in a at tables y*`a'

oadeyemi · ‎09-24-2019

Good day everyone. I am new to loops and macros. So I have the task of running chi-square statistics on a series of sixteen variables I feel I can get a more parsimonious SAS code by using loops and/or macros. I have a series of variable X1 to X16 to run against y. Please kindly assist. Thanks proc surveyfreq data=xx; weight = wt; strata = strata; cluster = cluster; tables y*x1 / chisq; run;

oadeyemi · ‎09-07-2019

Good day everyone. I have been searching online for guidance on how to perform a G estimation for healthy workers effect in SAS? Any guidance? Any link? Any set of codes that can guide me? I appreciate every help I get. Seun

oadeyemi · ‎08-22-2019

Thank you for the link. Very helpful. Thanks for the information.

oadeyemi · ‎08-22-2019

Thank you. This worked. And I generated unique ID. Thank you

oadeyemi · ‎08-22-2019

Thank you. I understand why I keep seeing the syntax error. Although I did not get a unique ID though. Thank you

oadeyemi · ‎08-22-2019

Good day everyone. I am trying to run proc sql command and I am facing some difficulties Background: fatal represent numbers per case countycode represent counties for each fatal. I intend to generate a table that has unique countycodes and average fatal counts per county. Below is my code proc sql; select fatals, countycode from county group by countycode mean (fatals) as fatalcount; quit; I keep getting syntax errors. I will appreciate help with this. Thank you

oadeyemi · ‎08-22-2019

Thank you so much. The extension of the document was the problem. I kept assuming it was a CSV but it was saved as an excel document (converted from dbf to excel) Thank you for the steps you suggested. It is resolved. Thank you

oadeyemi · ‎08-21-2019

Thank you for your input. I am not using GUI or coding. I am using SAS Studio from a SAS package that has all the gamut of SAS tools (9.4, Enterprise, Studio etc.) It is installed on my hard drive. Yes I imported using the "point and click" and the proc import codes. No information in the library. I guess it is a technical issue. Thanks

oadeyemi · ‎08-21-2019

Thanks for replying. You are right. I imported by clicking on the Import File. Yes, I can see the codes. However, I cannot see the dataset imported. In SAS Studio, I should be able to see the imported table. However, I cannot see that. And when I use Proc Import using the code generated, there is an error. I hope you understand my explanation. I guess there might be a technical issue because I just installed SAS on the computer. Thanks

oadeyemi · ‎08-21-2019

Thank you for the help. I found the "import" tab and I selected the excel file from the folders. There was no error but I cannot see the sheet I imported. How can I view this sheet?

oadeyemi · ‎08-21-2019

Good day. I am having difficulty importing file into SAS Studio (full deployment) Below is the code I used. 73 PROC IMPORT OUT= WORK.am 74 DATAFILE= "G:\My Drive\rush_cleaning\2012\accident.dbf.csv" 75 DBMS=CSV REPLACE; 76 RUN; The error I get is as follows: NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. ERROR: Physical file does not exist, G:\My Drive\rush_cleaning\2012\accident.dbf.csv. ERROR: Import unsuccessful. See SAS Log for details. Kindly assist

oadeyemi · ‎08-02-2019

Thank you for your comment. The if statement also works. But I will prefer excluding the missing variables entirely across board. Thank you so much for the explanation.

Online Status	Offline
Date Last Visited	‎10-15-2019 07:31 PM

Re: Creating a loop for chisquare analysis

Re: Creating a loop for chisquare analysis

Re: Creating a loop for chisquare analysis

Creating a loop for chisquare analysis

Healthy Workers Effect in SAS

Re: Proc SQL syntax errors

Re: Proc SQL syntax errors

Re: Proc SQL syntax errors

Proc SQL syntax errors

Re: Importing CSV into SAS Studio (Full Deployment)

Re: Creating a loop for chisquare analysis

Re: Creating a loop for chisquare analysis

Re: Creating a loop for chisquare analysis

Creating a loop for chisquare analysis

Healthy Workers Effect in SAS

Re: Proc SQL syntax errors

Re: Proc SQL syntax errors

Re: Proc SQL syntax errors

Proc SQL syntax errors

Re: Importing CSV into SAS Studio (Full Deployment)

Re: Importing CSV into SAS Studio (Full Deployment)

Re: Importing CSV into SAS Studio (Full Deployment)

Re: Importing CSV into SAS Studio (Full Deployment)

Importing CSV into SAS Studio (Full Deployment)

Re: WHERE syntax: How to appropriately use it in excluding mutiple var...