I have an input data like this   Column1 Column2 Column3 1 AB 14/03/2018 2 DC 23/07/2002 3 NP 13/11/1910 1 LP 25/09/1901 2 JP 06/12/1925 3 QR 03/04/1974     i am looking for an output like   Column1 Column2 Column3 1 AB-LP 14/03/2018-25/09/1901 2 DC-JP 23/07/2002 -06/12/1925 3 NP-QR 13/11/1910-03/04/1974 ... View more

Is there any way I can import a table from MS-Access 2013 to SAS 9.4. What will be the code... ... View more

I have two table which I am trying to UNION, however, I am facing an issue where data from one fo the table get missed out. I am working on SAS DI 4.9.   Table 1   Untitled1 Untitled2 Untitled3 Untitled4 Untitled5 Untitled6 Untitled7 Untitled8 Untitled9 LWI93262167 F Change 26.9 09-Dec-12 A T;T;F;F;F;T;F;T;T;F;T;F;F;F;T     VE98710787 F Change 32.9 09-Dec-12 B T;F;F;T;T;F;T; ;T;F; ;F;F;F;T     SDG13502113 F No change 25.02 09-Dec-12 C F;F;F;T;F;F;F;T;F;F; ;F;T;F;T     SDG38203520 F No change 20.02 09-Dec-12 D T;T;F;T;F;T;T; ;F;F;T;F;T;F;T     LW93262167 F No change 27.02 09-Dec-12 E T;T;F;F;F;T;F;T;F;F;T;F;T;F;T       Properties of table Column Type length Informat Format Untitled1 Character 23 $CHAR23. $CHAR23. Untitled2 Character 8 $8. $8. Untitled3 Character 15 $CHAR15. $CHAR15. Untitled4 Character 8 (None) (None) Untitled5 Numeric 8 date. date. Untitled6 Character 500 $CHAR500. $CHAR500. Untitled7 Character 50 $CHAR50. $CHAR50. Untitled8 Character 10 $CHAR10. $CHAR10. Untitled9 Character 1000 $CHAR1000. $CHAR1000. Table 2 Untitled1 Untitled2 Untitled3 Untitled4 Untitled5 Untitled6 Untitled7 Untitled8 Untitled9 20170805_EAP_Account_Req_New_20180112_073647   1 4 32 05-Aug-17                                        properties of table       Column Type length Informat Format Untitled1 Character 46 $46. $46. Untitled2 Character 8 (None) (None) Untitled3 Character 8 (None) (None) Untitled4 Character 8 (None) (None) Untitled5 Numeric 8 date. date. Untitled6 Character 8 (None) (None) Untitled7 Character 8 (None) (None) Untitled8 Character 8 (None) (None) Untitled9 Character 8 (None) (None)   My output has missing values   Untitled1 Untitled2 Untitled3 Untitled4 Untitled5 Untitled6 Untitled7 Untitled8 Untitled9                                                         4            . .                                     LWI93262167                                    F                   . 26.9 12-Sep-12                                     VE98710787                                     F                   . 32.9 12-Sep-12                                     SDG13502113                                    F                   . 25.02 12-Sep-12                                     SDG38203520                                    F                   . 20.02 12-Sep-12                                     LW93262167                                     F                   . 27.02 12-Sep-12                                       can someone please explain or give me alternative ... View more

I am working on SAS 9.4 and it is on Unix server now when I want to export a SAS dataset in CSV on my local machine, I get an error. I know it is because I am trying to transfer it fromUnix... but do we have an alternative to transfer it to window(by code not by file export option)   code: proc export data=ABC dbms=csv outfile="\\homedrivestmp\homedisk1\emar646\Desktop\Forecast\New folder\NEW_ENROLLMENT.csv" replace; run;   error:  ERROR: Insufficient authorization to access /sas/common/config/Lev1/SASApp/\\homedrivestmp\homedisk1\emar646\Desktop\Forecast\New folder\NEW_ENROLLMENT.csv.   I also tried  %ds2csv (data=abc, runmode=b, csvfile=\\homedrivestmp\homedisk1\emar646\Desktop\Forecast\New folder\retail.csv);   its not working and just opening the sas dateset and not transferring anything ... View more