am using 9.4 version. proc export data=d_outi.variable outfile='C\newfolder\pricesheet.xls' label dbms=xls replace; sheet='variable label'; run; this is the code i used to export the excel file
... View more
Hi , In proc export for excel I have given sheet name as sheet='Value Level Terminology'; But am getting the output in excel sheet as 'Value_Level_Terminology'; I dont want this '_ ' between the sheet names.Does anyone know how to get the output as 'variable mapping'. thanks in advance.
... View more
RFXSTDTC & RFXENDTC are the new variable added in SDTM IGv3.2. Earlier RFSTDTC or RFENDTC are used for the start date/time of exposure and end date/time of exposure, but now there are specific variable introduced RFXSTDTC and RFXENDTC for the same
... View more
Hi all , I know this is a basic thing but am not able to get the required output . i wanted to create a table using proc report like this am not able to get the dosage above the 40 and 20 mg .Please help me to solve this . Thanks in advance . Placebo (N=XX) n(%) | Dosage | 40mg (N=XX) n(%) 20 mg (N=XX) n(%) Overall (N=XX) n(%)
... View more
Hi all here am writing d code to check missing day month year from the input below & display the correct format according to the given values below. my input dates are YYYY-MM- YYYY YYYY- - DD MM-DD the values to display according to the corresponding input value in the output should be in sas numeric date format since these dates values are missing how to display them as output ? thanks in advance
... View more
Hi all, i've a dataset like given bellow N_ 36 36 36 Mt_ 9581.1728 9791.5262 1366.1106 S_D 2965.8626 2982.0749 398.3543 Now i need to give decimal places for the variables what if other variables contain more decimal places how to find out that .i had tried many things like format, length and etc. but it didn't work well. is it really possible? if so, can anyone tell me how? Thanks in advance
... View more
if a= 1 b = 2 c= 3 then if i make a table it for a and b it should be a multiple of both a and b the value for d will be 4 and e will be 5
... View more
