Home

SASuserlot

I am using proc template to generate this kind of graph. What is the option available to auto move the text inside the bars so that it wont collide with error bar graph line. Thank you.

v307086

Hi all, I have a test data with missing values and I want to fill the table by taking previous month's value. Test data ID response date 1 CR 02Jan2020 2 PR . 3 NE 04Jan2020 4 SD . 5 PR 05Jan2020 6 CR . data I want to have ID response date 1 CR 02Jan2020 2 PR 02Jan2020 3 NE 04Jan2020 4 SD 02Jan2020 5 PR 05Jan2020 6 CR 05Jan2020 So, if the response NE, then I don't want to retain the NE date but the date before NE. But if the response is not NE, then I wanna retain the previous date. I tried multiple ways, but couldn't figure it out. Please help.

sasphd

Hello I want to change date format from $10. to yymmn6. thanks

RichardAD

Is there a place that documents when (year or release) a function or routine was added to SAS, and when it may have been bug fixed, altered, extended or deprecated?

trevand

I would like to have a variable that tells me which observations have merged and which have not. I would like to create this in the merge step. I can do it when I use merge within the data step. I can't however figure out how I would do it with a proc sql merge. Could anyone help me please? Here is the code that creates this variable in the data step. data data_merged; merge data_1 (in=a) data_2 (in=b); by merge_id; data1=a; data2=b; if data1=1 & data2=1 then merge=3; else if data1=0 & data2=1 then merge=2; else if data1=1 & data2=0 then merge=1; run;