About sks521

sks521 · ‎06-24-2019

Here is the syntax; data study cont1 cont2; *controls2; set demo; if practice= "Saltaire medical practice" and status = "interventionGroup" then output STUDY; else if practice = "Saltaire medical practice" and status = "Eligible" then output cont1; else output cont2; RUN; and log; 75 data study cont1 cont2; *controls2; 76 set demo; 77 if practice='Saltaire medical practice' and status= 'interventionGroup' then output STUDY; 78 else if practice='Saltaire medical practice' and status= 'Eligible' then output cont1; 79 else output cont2; 80 RUN; NOTE: There were 409 observations read from the data set WORK.DEMO. NOTE: The data set WORK.STUDY has 0 observations and 16 variables. NOTE: The data set WORK.CONT1 has 0 observations and 16 variables. NOTE: The data set WORK.CONT2 has 409 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds

sks521 · ‎06-24-2019

Sorry I should've been more precise; the actual values in the data set are 'Saltaire medical practice' and 'Bingley medical practice' and for variable 'status' are 'Eligible' and 'InterventioGroup', I just made them up in my first post to make it look short. But I am assuming something else is wrong with my syntax which I can' figure out. Thanks S

sks521 · ‎06-24-2019

Yes, absolutely right! its 'intervention' but even correcting that doesn't correct the problem. posted the log in the previous post, posting again; 88 data study cont1 cont2; *controls2; 89 set demo; 90 if practice= "Saltaire medical practice" and status = "intervention" then output STUDY; 91 else if practice = "Saltaire medical practice" and status = "Eligible" then output cont1; 92 else output cont2; 93 RUN; NOTE: There were 409 observations read from the data set WORK.DEMO. NOTE: The data set WORK.STUDY has 0 observations and 16 variables. NOTE: The data set WORK.CONT1 has 0 observations and 16 variables. NOTE: The data set WORK.CONT2 has 409 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds Thanks S

sks521 · ‎06-24-2019

And when I run this syntax to create separate case and control data sets; data study cont1 cont2; *controls2; set demo; if practice= "Saltaire medical practice" and status = "interventionGroup" then output STUDY; else if practice = "Saltaire medical practice" and status = "Eligible" then output cont1; else output cont2; RUN; I get this log; NOTE: There were 409 observations read from the data set WORK.DEMO. NOTE: The data set WORK.STUDY has 0 observations and 16 variables. NOTE: The data set WORK.CONT1 has 0 observations and 16 variables. NOTE: The data set WORK.CONT2 has 409 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds while I expect 106 observations in study, 119 in cont1 and 180 in cont2. Can someone cast their beady eye and tell me where I am wrong please. Thanks S

sks521 · ‎06-24-2019

Hi, I have a data set in the following form; ID Practice Age Status Sex 1 Bingley 77 Eligible Female 2 Saltaire 74 Intervention Male 3 Saltaire 73 Eligible Male 4 Saltaire 75 Intervention Female 5 Bingley 72 Eligible female Saltaire practice has both 'intervention' and 'eligible' group while 'Bingley' has only 'eligible' group. My cases are 'intervention' group under 'status' variable within 'Saltaire' practice. I want to create two different groups of controls; one that has 'eligible' status within 'Saltaire' practice, and second with 'eligible' status within 'Bingley' practice, matching on age and sex and creating 1:1 match. there are other variable in the data set which I am not using for matching. I will appreciate help with the syntax please? Ta

sks521 · ‎06-18-2019

Very helpful indeed! thanks for all your help S

sks521 · ‎06-18-2019

Thanks for helping but I couldn't get 'Before you expand this if/then/else chain, take a look at the data step select statement (not the SQL one).'. Can you elaborate further please? BW S

sks521 · ‎06-18-2019

And here is snapshot of the the new variable 'visit' created from existing variable 'professionalcontact' PKid ProfessionalContact visit . . 1 GP . 1 Nurse . 1 Nurse . 1 Admin . 1 GP . 1 Admin . 1 Admin . 1 GP . 1 GP .

sks521 · ‎06-18-2019

Sorry it changed the format a little bit; Each value in the left column represent number for each of the following categories; AHP Admin GP HCA Nurse Unkno

sks521 · ‎06-18-2019

Hi Thanks, here is the freq proc; The FREQ Procedure ProfessionalContact Frequency Percent CumulativeFrequency CumulativePercentAHPAdminGPHCANurseUnknoFrequency Missing = 1 660 3.58 660 3.58 6923 37.54 7583 41.12 8147 44.18 15730 85.29 68 0.37 15798 85.66 1925 10.44 17723 96.10 719 3.90 18442 100.00

sks521 · ‎06-18-2019

Sorry forgot to post the syntax; if professionalcontact=. then visit=.; else if professionalcontact in ('Admin', 'unkno') then delete;*this gives 11520 observations/visits; else if professionalcontact in ('GP', 'AHP', 'HCA', 'Nurse') then visit=1;

sks521 · ‎06-18-2019

I want to create a new variable from an existing variable. The existing variable has following values- GP, AHP, HCA, Nurse, admin I want to create a new variable which does not include 'admin' and missing values, and coded '1' for all other values (GP, AHP, HCA, Nurse). I have written the following syntax but it's giving '.' for all values in the new variable. Can someone help please? Thanks S

sks521 · ‎06-17-2019

Fabulous! it worked Thanks

sks521 · ‎06-17-2019

Hi, I am trying to create a dummy variable as follows; before 1st September 2016 as pre-intervention; from 01/09/2016 to 28/02/2017 as intervention After 28/02/2017 as post-intervention If I run proc contents, the log says its in 'yymmdd10' format; in proc print output log the dates look like for e.g.; 2018-06-18. When I write the following syntax; data dummy; set combined; format EventDate YYMMDD10.; if EventDate<'20160901'd then group=0;*intervention; else if '20160901'd =<EventDate>= '20170228'd then group=1;*pre-intervention; else group=2;*post-intervention; run; it gives me an error message. Can someone help please? Thanks Shah

sks521 · ‎06-17-2019

So now I have created separate csv for each excel worksheet, imported them into SAS and merging went fine with one date variable having both var and char formats in one. I hope I am on the right track! Thanks for all your help.

Online Status	Offline
Date Last Visited	‎02-21-2020 01:05 PM

Re: Creating new variables

Re: Creating new variables

Re: Creating new variables

Re: Creating new variables

Re: Creating new variables

Re: Creating new variables

Re: Creating new variables

Creating new variables

Re: ICD-10 grouping

Re: ICD-10 grouping

Re: Grouping ICD-10 codes

Re: Bringing data into SAS using Datalines option

Re: Finding duplicates

Re: Finding duplicates

Re: SAS macro

Re: Matching (one-to-one) cases and controls from a cross-sectional da...

Re: Matching (one-to-one) cases and controls from a cross-sectional da...

Re: Matching (one-to-one) cases and controls from a cross-sectional da...

Re: Matching (one-to-one) cases and controls from a cross-sectional da...

Matching (one-to-one) cases and controls from a cross-sectional data

Re: Creating new variable

Re: Creating new variable

Re: Creating new variable

Re: Creating new variable

Re: Creating new variable

Re: Creating new variable

Creating new variable

Re: creating dummy variable from dates

creating dummy variable from dates

Re: Dealing with a variable with two different formats in one (date an...