Hi All,   I have a file with customerid, code1 and code2 varialbes.    Input file: Customerid Code1 Code2 10001 101 201 10002 101 201 10002 101 301 10002 102 202 10003 101 201 10003 101 301 10003 102 201 10003 102 301 10004 101 201 10004 101 201    Desired Output file:   10001 101 201 10002 101 201 10002 101 301 10002 102 202 10003 101 201 10003 102 301 10004 101 201   Could you please let me know how can get the desired output file?   Thanks in advance! ... View more

Hi All,   I am creating a .csv file in mainframe using SAS and email the file as an attachment. When I open the file the numeric data, for example, customer id 1234567898 is converted into 123E.11 something like that.   Could you please let me know how I can retain the format of the numeric variable in .CSV file( I know when I open the .csv file in Excel this weird conversion happens).    Please help.   Thanks ... View more

Hi All, Input file: is an excel file read into SAS. Mother_dob is a numeric variable with the value 20130123 in the file Test. Wanted output file: I want mother_dob with the format yymmddn8 Result I got with the following code: the output file is still showing mother_dob with the yymmdd8. format. I noticed that in my following code after I do the formating of the date variable the values are still showing as in SAS date values. Could you please help me understand why the format yymmddn8 is not getting assigned in the below code. DATA final; SET test(keep=mother_dob obs=1);          MOTHER_DOB1     = input(put(left(MOTHER_DOB),8.),YYMMDD8.);       drop MOTHER_DOB ;       rename MOTHER_DOB1     = MOTHER_DOB;       format MOTHER_DOB yymmddn8.; RUN; I was able to assign mother_dob with yymmddn8. format with the following code but still did not understand why the above code did not work. Modified code: DATA final; SET test(keep=mother_dob obs=1);          MOTHER_DOB1     = input(put(left(MOTHER_DOB),8.),YYMMDD8.);        format MOTHER_DOB1 yymmddn8.;       drop MOTHER_DOB ;       rename MOTHER_DOB1     = MOTHER_DOB;   RUN; Please share your thoughts. Thank you all in advance!   ... View more

   Hi All, Could you please help me with this problem. My file has the following fields: ID    rgn_cd   dx1   dx2  dx3....dxn 100  01          200   300  400 ... 110 I want to create an output file like this: ID         rgn_cd  dx1   dx2     dx3 .....    dxn 100        01       200   100        01                300 100        01                        400 ...          ---                                  ------        100(n)    01(n)                                         110 Please share your thoughts ... View more

Hi, I have the following values in two files : File 1 : 201301 201302 the values are in best32. format. File 2: 201301 201302 the values are numeric values(8 bytes) I would like to convert the date values in two files to date format i.e 201301 (date format). Kindly help. Thanks ... View more

Hi, I have the following two tables and I want to get the rows from both tables where the key does not match using PROC SQL. Data Company; input Deptid name$10. ; datalines; 101 ram 102 dam 103 fff 104 ggg 105 sss 106 aaa ; run; proc print data=company;run; Data Dept;   input Deptid noe;   datalines;   101 100   103 30   201 200   301 20   ; run; Desired output: Deptid Name Noe 102 dam 104 ggg 105 sss 106 aaa 201              200 301               20 Please share your thoughts. ... View more

Hi, I have a requirement where I need to combine two datasets, but here is what is causing me trouble. For example: master dataset Emp_loc       Emp_sal USA             100000.00 Newyork        25000.00 California       25000.00 Texas            25000.00 Nevada          25000.00 Transaction dataset: Emp_loc Emp_sal Texas     30000.00 USA       105000.00 I want to update the master dataset, but need to keep the values of the EMP_Loc in the same order ie, after my change the dataset should look like this: Updated Master dataset: Emp_loc       Emp_sal USA             105000.00 Newyork        25000.00 California       25000.00 Texas            30000.00 Nevada          25000.00 Please share your ideas. Thanks ... View more