Sorry. There’s a mistake in the question. Lets take a longer word. Say DONALD. There are 6 letters. SAS should count the 6th letter in DONALD in each iteration and delete the 6th letter. DONALD -delete D DONAL - delete D ONAL - delete N OAL - delete L OA - delete A Print the result as O
... View more
I have a string JOHN that contains 4 characters. I want to delete the 4th letter every time. example: JOHN- 4th letter is N. N is deleted. Now the string is reduced to JOH JOH- count 3 letters and go back to the beginning and count J as 4th letter. J is deleted. JO- 4th letter is O. O is deleted. last remaining letter is J which should be printed as the result. how do I do this with sas? Thanks in Advance
... View more
Hello Im creating. xlsx spreadsheets of 11 datasets using ods excel. i got all the datasets except for one which was an empty dataset. How do i get the empty dataset into the spreadsheet using ods excel? The code i used is ods excel file='c:..............\report.xlsx' options(sheet_interval='proc's heet_name='sheet1'); Proc print data=one; Run; ods excel options(sheet_name='sheet2'); Proc print data=empty; Run; . . . . . ods excel close; The dataset empty has no observations. I want a sheet that has only variable names.. But when i run the code, the sheet related to dataset empty is missing. Is there a way to get that sheet using ods excel?
... View more
My task to create a dataset that contains observations with different advevent value for the same patid and visitdate. Im creating an outliers dataset. A single patient cannot have two different adverse events at the same visit date.
... View more
I need to find overlapping advevent value for the same patid and date. This is the dataset i have: Patid advevent date 1 vomiting 01jan09 1 vomiting 01jan09 1 vomiting 01jan09 2 delirium 06jan09 2 nausea 06jan09 2 delirium 06jan09 2 delirium 06jan09 My outpout should be 2 delirium 06jan09 2 nausea 06jan09
... View more
I have a dataset with variables site,subjid,race,ethinicity,sex. How do i get them all in one column using proc report. My output should contain site\subjid\race\ethnicity\sex in one column
... View more
