Hi, I just want to know the difference between following codes and its results: *get code from external file.; DATA TEST; INFILE 'C:\OVERTEST.TXT' (*)OVER; INPUT TEST_NUM 5.; RUN; PS:(*)over means the options we mentioned above. (FLOWOVER/MISSOVER/TRUNCOVER/SCANOVER/STOPOVER) Results: OBS FLOWOVER MISSOVER TRUNCOVER STOPOVER 1 55555 55555 55555 55555 2 22 . 1 3 4444 . 22 4 55555 . 33 5 . 4444 6 55555 55555 *Second code: DATA TEST; INFILE datalines (*)OVER; INPUT TESTNUM 5.; datalines; 55555 1 22 333 4444 55555 ; RUN; its results for all options(flowover missover,truncover,stopover). Testnum: 55555 1 22 33 4444 55555; /*Can any one please what is the difference between these?Thank you.;*/ ... View more

Hi, It might be simple solution. unfortunately, I coudn't get proper answer anywhere in google. I know other methods to send file to external location. But specifically I am looking for following method.   I am trying to send file in excel using file statement using the following code. data _null_; set sashelp.class; file "/r00/home/rkava001/test.xls"; put name age sex; run;   *text file; data _null_; set sashelp.class; file "/r00/home/rkava001/test.dat"; put name age sex; run;   The issue is, the output file is showing name age sex columns as one column in excel. But I want name age sex in separate columns. can any any one please help?   In text file it showiing all observations are coming in one row. I need them in seperate lines   Cheers, Ramu ... View more

Hi,   I have following dataset with label names:   data class; set sashelp.class; label name="NAme" sex="GEndeR" age="Age" height="HeiGht" weight="kilograms"; run;   I need to change all label names to upcase/lowcase/propcase for all variables in one step. Can anyone please help? ... View more

Hi,     Can anyone help me out please?     I have following data set:     data have;     id    name country     100   abc   ind    just for understanding clearly, 4th column is comments, I am adding below comments: "SWIFTT LIST BRUPI ACTION REQUIRED: REASSESS ASUP TO PICKUP INCM Refer to note dated 21/07/2016 entered by TDEMP003. ACTION TAKEN:  I have reassessed Asupp based on the income from 25/07/2016. Asupp rate is now $69.00 ($34.50 each). Outcome of call to client No Letter sent: Yes Client Number                                                                       357-208-501 Entitlement Date                                                                25/07/2016  Gross SA                                                             $-   Gross Wages                                                          $823.31 Extra Income from Assets                                         $-   TOTAL GROSS INCOME                                               $823.31 so there are 4 columns. i want the result in word like this;              id       100        name       abc     country        ind comments    "SWIFTT LIST BRUPI                      ACTION REQUIRED: REASSESS ASUP TO PICKUP INCM                     Refer to note dated 21/07/2016 entered by TDEMP003.                    ACTION TAKEN:  I have reassessed Asupp based on the income                     25/07/2016. Asupp rate is now $69.00 ($34.50 each).                    Outcome of call to client No                     Letter sent: Yes                     Client number 12345                    Entitlement                     Date 25/07/2016                                                                    Gross SA                                                                           Gross Wages                                                             $823.31               Extra Income from Assets                                            $-                TOTAL GROSS INCOME                                            $823.31   I tried with following code: data null; set client_details; file " &WORK_DIR_PATH/&filename..doc" noprint lrecl=1200 print; put 'ID' @ 30 id /; put 'Client name' @30 Name /; put 'country' @30 country /; put 'comments' @30 comments ; ; run; I am looking here for 'comments' field (4th column). i could not arrange them in order exactly that shows in the field. my reuslts are looking ugly. I mean the words and numbers are not showing in same order as in the table. so can anyone please tell how to write that big observation into multiple lines or exctly how it is showing the row.   ... View more