I made a test csv file and used your code and it worked fine with me. I usually use the datastep approach rather than proc import so I'm not sure why it isn't working for you. You could try using PROC IMPORT OUT= WORK.states DATAFILE= "C:\states.csv" DBMS=csv REPLACE; GETNAMES=YES; GUESSINGROWS=1000; RUN; state.csv ------------------------------------ State,City Massachusetts,Boston Message was edited by: RickM Message was edited by: RickM ... View more

Try using a length statement before you input the data. Good luck! ... View more

Try using an ods output statement: ods output ParameterEstimates=estimates; ... View more

The forum doesn't like the symbols for "less than or equal to" etc. so it is best to use SAS's abbreviation's (lt, le, gt, ge, eq, ne). Only you can edit your own posts. ... View more

If the data is already sorted the way you presented it then you could use the notsorted option in a by statement. [pre] data one; input Visitno Room Bed InDate $ 10-21; cards; 1234 1 1 JAN 1, 2011 1234 1 1 JAN 2, 2011 1234 5 2 JAN 3, 2011 1234 5 2 JAN 4, 2011 1234 5 2 JAN 5, 2011 1234 5 2 JAN 10, 2011 1234 1 1 JAN 11, 2011 1234 1 1 JAN 12, 2011 ;;; run; data two; set one; retain indt outdt; by room notsorted; if first.room then indt=InDate; else if last.room then do; outdt=InDate; output; end; run; [/pre] ... View more

I think the "zoom off" is if you have the editor maximazed SAS will first restore the window and then submit the program. ... View more

CTRT+G is already a shortcut for goto line (I don't know why it isn't listed in the dmkeys section but it is in Enhanced Editor Keys). Try using CTRL+J instead. ... View more

Submit on windows is F8 ... View more

sbb, From the OP: "eg: I have two datasets containing the same information, downloaded a month apart. The latest dataset contains all the observations which appear in the earlier set plus a few dozen new observations. " So the problem, as I interpreted it, is that they are starting out with two data sets. The other solutions assume the data is already combined and removing duplicates within one dataset is the only way to solve the problem. Why not find the new values before the two datasets are put together. ... View more

I haven't used UNIX in years (and never for SAS) but I thought UNIX uses the forward slash '/' for pathnames while the default in windows is the backslash( though it will accept the forward slash as valid) so try switching it in your program. ... View more

I think people might be overthinking this. How about: [pre] proc sql; select * from new except select * from old; [/pre] ... View more

It would be helpful to see the error message as well as the code that came before it in the SAS log. ... View more

I think you might need a period after &Prog but before the _ in the line that generates the error. SAS thinks you are trying to use the macrovariable &Prog_ which doesn't exist. The period tells SAS that the macro token has ended(as do spaces, ampersands, and some others). ... View more

Go to the online doc and search "sum statement syntax" ... View more

I would use something like: call symput(catx('CNT',A),B); in a data step. Good luck! ... View more