Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by noway320

  1. noway320

    Crystal report question

    Hello SAS gurus I am just wondering that, is there any way to read crystal report RPT files into a sas data set?
  2. noway320

    How to change date format

    options missing=''; DATA Test; infile datalines; input sab yymmdd10. DOB yymmdd10.; datalines; 19901225 19661225 19960906 19960605 19960305 19970804 99999999 00000000 ; run; options missing=.; options missing=''; data _NULL_; set test; file "C:\Documents and...
  3. noway320

    How to change date format

    Hello Guys, I need help for changing my date format. cards; 19901225 19960906 19960305 ; These date are in yyyymmdd format, I want to just flip that dates into mmddyyyy format. So, my output will be 12251990 09061996 03051996 Please help me out. Thanks!!
  4. noway320

    comma delimited

    here is total code- data a1; set a; row = compress (row, '" " '); fdate= compress (fdate, '" " '); nav_pn= compress (nav_pn, '" "'); pdc= compress (pdc, '" "'); oldfcst= compress (oldfcst, '" "'); curfcst= compress (curfcst, '" "'); rcrdtype= compress (rcrdtype, '" "'); run; data a1; set a1...
  5. noway320

    comma delimited

    And for periods you can use same method, instead of " " you should put .
  6. noway320

    comma delimited

    Here is code, try this- data a1; set a; row = compress (row, '" " '); fdate= compress (fdate, '" " '); nav_pn= compress (nav_pn, '" "'); pdc= compress (pdc, '" "'); oldfcst= compress (oldfcst, '" "'); curfcst= compress (curfcst, '" "'); rcrdtype= compress (rcrdtype, '" "'); run;
  7. noway320

    how to choose Specific variables while importing

    Hello everyone, I am stuck in importing some .dbf files, can anyone please tell me that "if i want to choose some specific variables from .dbf file, like in .dbf file has 100 var and I want only 15 var and I want to select that 15 var while importing file into SAS ", How can i do that? Thanks...
  8. noway320

    how to combine 2 different variables

    We can use CATX function.
  9. noway320

    how to combine 2 different variables

    Hello all, I need some help about combining two variables like, zipcode will be P_zip+P_zip4 (Here P_zip and P_zip4 are 2 different variables containing null values too.) So, zipcode will be P_zip+P_zip4 and separated by hyphen. e.g. 1)P_zip = 1233 P_zip4= 1563 zipcode = 1233-1563...
  10. noway320

    Remove Commas

    It works, awesome!! Many many thanks for your help. Thanks again. :)
  11. noway320

    Remove Commas

    Hey klaz, thanks for helping, but I could not able to find the whole syntax for compress statement. Actually I am very new for this SAS programming. If possible to you then can you please send me whole syntax.... like Data "data name"... Thanks again
  12. noway320

    Remove Commas

    Can anyone help me? I stuck in removing commas from my sas dataset. Well, I wants to generate .csv file from my sas dataset but due to some commas are already existed in original dataset; it generates extra variable. Thanks in advance.
  13. noway320

    Creating new variables without any data

    We can use proc SQL, like Alter table statement, because i got the answer but let me try the code of yours.
  14. noway320

    Creating new variables without any data

    Well, I have already a dataset in which i wants to create multiple variables which are blank.
  15. noway320

    Creating new variables without any data

    How can i create new variables but no data, like absolutely blank, no zero, no periods in SAS?
See more

Part and Inventory Search

Back
Top