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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RinaGreen
  • Content: Threads
  • Order by date
  1. RinaGreen

    How to use Macro code?

    Dear Experts, I wrote code which looks pretty much the same in all three parts and differs just because of the different datasets. Data set names are the followings: Retire NoChoice Choice My code looks too long with 3 parts of it almost the same (actually other products(datasets) are coming...
  2. RinaGreen

    CAT and CARDS (?)

    Hi, Still being new in SAS, I am just wondering what CAT means in SAS? When it is needed? When to use it? Is it used just with CARDS? I inherited somebody’s code and struggle with it! For ex. CAT='ALL' CARDS; lines of data Thanks in advance, Rina
  3. RinaGreen

    proc SQL update?

    Hello everybody! I have two tables: 1st table name is substFormat: with two num fields: Policy and new1 2nd table name is Full: with Policy field I need to replace Policy field in FULL table with NEW1 if substFormat.policy=Full.policy I tried to do it in Proc SQL UPDATE STATEMENT proc...
  4. RinaGreen

    failure to convert from Numeric to Character

    I need to convert numbers to characters as I have quest1 values equal 1 or 2 or 3, or 4, or 5. I need quest1 field whch is numeric (length 8) into char Y or NO depending on criteria. However I failed to do it. Moreover log tells me: NOTE: Character values have been converted to numeric...
  5. RinaGreen

    Problem to output all fields using aggregate function

    Hi everybody I created the following SQL query and it does work except I need all other fields in the output. select id,Max(dt_day) FROM DenLab GROUP BY id; However I found out that whenever I add some of the other fields to select clause, it doesn't give me correct answer for example...
  6. RinaGreen

    Urgent help with PROC SQL DELETE query is needed

    Hi Everybody, I have a problem with SQL PROC DELETE query... After I successfully created table Denlab I need to eliminate partly duplicated records in order to leave just those ones with the same ID who are the most recent However those ones who have just one record shold not be touched...
  7. RinaGreen

    Proc SQL creates a table but does not populate it!

    Hi Everybody, I am in a trouble with a Proc SQL which I implemented as below: ************************************************************ libname DA 'C:\MYfolder\SAS Datasets'; proc sql; create table da.Den as select * FROM da.combineBothTbls mc join DA.LAB...
  8. RinaGreen

    How to treat data type memo in SAS?

    Hi! When I connected to Datawarehose (DB2) through ODBC to Access 2002 I got a comment field with data type memo . Now I am trying to write Proc SQL in SAS... Which datatype I should assign in the PROC SQL SAS code? Character? An with what size? Thank you! Rina
  9. RinaGreen

    IMPORT FROM EXCEL WITH COLUMN RENAMING

    Hi I need to import file from Excel to SAS and to rename all fields. Actually I already imported file from Access ones. I assume it should be like the following....I assume I just need to put FILE instead TABLE (in Access). Also I assume I need to specify a sheet.... I am not sure how to...
  10. RinaGreen

    import from Excel with renaming columns and adding some leading zeroes

    Hi I need to import file from Excel to SAS and to rename all fields. Actually I already imported file from Access ones. I assume it should be like the following....I assume I just need to put FILE instead TABLE (in Access). Also I assume I need to specify a sheet.... I am not sure how to...
  11. RinaGreen

    Using Tag in loop and in (drop=tag)

    Hi Being absolutely new in SAS I got confused with the TAG in the following construction. I assume that this is a conditional loop. However I wonder what is the role of TAG? I tried to find it in help-on-line …but failed. Could you please explain me? Thank you in advance Rina data data1...
  12. RinaGreen

    Proc Import from MS ACCESS table

    Hello, I am not sure how to import a table (orig) from MS ACCESS I assume it is something like the following: PROC IMPORT DATAFILE:"C:\myAccessDB.MDB ORIG" out=MyData DBMS=ACCESS2004; getnames=YES; run; I am confused how to specify a table named orig... Thank You Rina
  13. RinaGreen

    Run-time Error 424 :object required

    Thank you all who helped me to overcome my syntax errors. Now I modified my first VBA module code and it doesn't generate compile error anymore BUT it stucks on the following line: mID = orig_.[MEMBER ID] generatinG a run-time Error 424 saying :object required...
  14. RinaGreen

    Access Date format vs. VBA module

    Hello, I am confused with the difference in Access and VBA syntax I know that in Access it would be: dMyDate between 10/1/2001 AND 12/10/2002 However it generate a compile error in VBA module which I never used before. Could you please help me with that? THANKS A LOT! Rina
  15. RinaGreen

    Date Format comparison in VBA vs Access

    Hello, I am confused with difference in syntax... I know that in Access it would be dMyDate between 10/1/2001 AND 12/10/2004 but in VBA module it generates Compile Error So it is around Date Format. How can I express the same condition in VBA? Could you help me with it? Thanks a lot Rina

Part and Inventory Search

Back
Top