About dapenDaniel

dapenDaniel · ‎12-02-2018

Hello. I have a data set with more than 10000 observations. I would like to split it into several data sets with 50 observations for each. I know I can use the group = mod(_n_, 250) function to create a variable and later use if then output function to finish this task but It means that I need to create 250 groups. Is there any more convenient way to split this data set? Thanks.

dapenDaniel · ‎11-30-2018

if substr(id, 3, 4) = RE then delete; Is it correct?

dapenDaniel · ‎11-30-2018

Hello! My data set has an ID number (character variable) and I want to filter some of observations. The criteria is if the 3rd and the 4th digits are "RE", then delete. For example, if the ID is ABRE5550, this observation should be deleted. What code do I need to use? Thanks.

dapenDaniel · ‎11-23-2018

Thank you so much! Have a great thanksgiving day!

dapenDaniel · ‎11-23-2018

If I have 4 variables and want to retain the first one for those that are same for the three variables (ID, Year and Var1), what code do I need? I have not used SQL before and am still learning it. Thanks for your patience. original Data set: ID Year Var1 Var2 1 1999 aa ba 2 1998 ab bb 2 1998 ac bc 2 1998 ab bd 2 1998 ac be 3 1998 ad bf Expected Data set: ID Year Var1 Var2 1 1999 aa ba 2 1998 ab bb 2 1998 ac bc 3 1998 ad bf

dapenDaniel · ‎11-22-2018

Thank you.It works well!

dapenDaniel · ‎11-22-2018

Hello. I have a data set as following below. ID Year Var1 1 1999 aa 2 1998 ab 2 1998 ac 2 1998 ab 2 1998 ac 3 1998 ad The red lines are the same and the blue line are the same. If all three variables (ID, year and Var1) are the same, then retain the first one and delete the duplicated one. The data set following below is what I expect ID Year Var1 1 1999 aa 2 1998 ab 2 1998 ac 3 1998 ad What code do I need? Thanks!

dapenDaniel · ‎11-20-2018

I checked the output. The code works well. Thanks.

dapenDaniel · ‎11-20-2018

there is no error message so I think it works.

dapenDaniel · ‎11-19-2018

if year=substr(id, 3, 4) then delete; Is it correct?

dapenDaniel · ‎11-19-2018

Year is also character variable.

dapenDaniel · ‎11-19-2018

Hi. I have two variables as following below. ID Year US2007025948 2007 What I want to do is that if year (2007) equals to the third to the sixth digit of ID (US2007025948), delete this observation. What code do I need to use? Thanks.

dapenDaniel · ‎11-19-2018

Hello. I have a data set with more than 1 million observations. I would like to split this data set and submit them in a job array. However, the computer is using Linux system. If I submit the single order, The code is module load sas sas /work/sas/code.sas If I submit the job array, the code is module load sas sas /work/sas/code $SLURM_ARRAY_TASK_ID.sas However, how can I add a parameter to tell sas that I want sas to read the observation from #1 to #5000, #5001 to #10000 respectively? Thanks. https://hcc-docs.unl.edu/display/HCCDOC/Submitting+a+Job+Array

dapenDaniel · ‎11-16-2018

Thank you for your help!

dapenDaniel · ‎11-14-2018

I need to open that file in excel. Even though I export as csv file, it still cannot be shown completely if I open it in excel. Is it correct?

Online Status	Offline
Date Last Visited	‎07-13-2020 02:30 AM

Re: Proc genmod qic

Re: Proc genmod qic

Re: Proc genmod qic

Proc genmod qic

Re: Conditional sum

Conditional sum

Re: Delete first two years in a panel

Re: Add extra year rows in panel data

Delete first two years in a panel

Add extra year rows in panel data

Re: Cutting digit

Split dataset

Re: filter data

filter data

Re: Delete Duplicate data

Re: Delete Duplicate data

Re: Delete Duplicate data

Delete Duplicate data

Re: Cutting digit

Re: Cutting digit

Re: Cutting digit

Re: Cutting digit

Cutting digit

Running SAS in parallel using SLUMR job arrays

Re: Split dataset

Re: Split dataset