The DTDATE9. format display DDMMMYYYY when applied to a datetime variable. ... View more

what happens if you open a command window and run the command outside of sas? "C:\Program Files\WinZip\wzunzip.exe" -vb F:\myfolder\Test.zip test.txt ... View more

So that suggests either you can't use the X commands (unlikely if you didn't get an error) or the unzip syntax is incorrect.  If you just run the x command and then go look in the F folder, does the file exist? ... View more

If your system administrators allow...you might could perform the extract via the X command and then process the file: X '"C:\Program Files\WinZip\wzunzip.exe" -vb F:\myfolder\Test.zip test.txt'; filename testing "F:\myfolder\test.txt" LRECL = 5000; ... View more

sort of a brute force method...but..seems to work.. data have; input id measure1 measure2 measure3; cards; 1001 10 22 32 1001 11 . 33 1001 12 . . 1002 9 . 43 1002 . 20 33 1002 12 . 23 1003 . 22 30 1003 8 22 30 1003 . . 30 run; data want(drop=m1 m2 m3); set have; by id; retain m1 . m2 . m3 .; if measure1=. then measure1=m1; else m1=measure1; if measure2=. then measure2=m2; else m2=measure2; if measure3=. then measure3=m3; else m3=measure3; run; ... View more

The lag function is tricky about when it actually gets called and whats on the stack when it hasn't been called.  Here's a pretty good article on it:  http://changchung.com/download/retainLagLeadInterleave_draft.pdf Of course, to do what you are asking is trivial: data want; set table1; by subject; if first.subject then event=1; else event+1; run; ... View more

I think all you need to do is include a title statement in the proc means; ... View more

When I copy and paste your code then run it, I get this the report below.  I also get a warning that "WARNING 1-322: Assuming the symbol NONOBS was misspelled as noobs." ------------------------------------------------------------ Year=1999 -------------------------------------------------------------                                                         The MEANS Procedure                                                      Analysis Variable : Sales                                 Region               Qtr    State                Sum            Mean                                 --------------------------------------------------------------------                                 East                   1    MA              18038.00        18038.00                                                             NC              13611.00        13611.00                                                        2    MA              11084.00        11084.00                                                             NC              19660.00        19660.00                                                        3    MA              11084.00        11084.00                                 West                   1    CA              27272.00        13636.00                                                             OR              18988.00        18988.00                                                        2    CA              14523.00        14523.00                                                             OR              37976.00        18988.00                                 -------------------------------------------------------------------- ... View more