Agree with chang_y_chung: just try without CATS. Your code: %SYSFUNC(cats(&number,_,'>',%SYSFUNC(Intnx(year, &dvar, -1, end), DDMMYYP10.))) Edited code: &number_>%SYSFUNC(Intnx(year, &dvar, -1, end), DDMMYYP10.)
... View more
Tech Support did indeed help solve this issue for me. For anyone else looking for a solution to this problem, I needed to upgrade from SAS 9.1.3 Service Pack 3 to SAS 9.2 or SAS 9.3 to get all of the variables and labels to import from the SPSS file. Short of that, since someone else at my company is in charge of upgrading our SAS version, I was able to download Service Pack 4 for SAS 9.1.3 http://ftp.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#h0 followed by a hot fix to the SAS/ACCESS issue: http://ftp.sas.com/techsup/download/hotfix/e9_win_sbcs.html#pf Thanks again for your help, Reeza and, in SAS Tech Support, Peter Ruzsa.
... View more
Okay, thanks, Reeza. I will contact SAS tech support; I was just throwing this out to the community first since I couldn't find anything online about limits.
... View more
It's a funny thing, some of the official SAS documentation online specifies using DBMS=SPSS but others specify using DBMS=SAV. I get an error when I specify DBMS=SPSS over DBMS=SAV: ERROR: DBMS type SPSS not valid for import.
... View more
Howdy. I currently import SPSS data using LIBNAME statements with POR files. This has been a perfectly usable method for my work as it pulls in all of the data for all of the records/observations, the variable names and labels, and the values. Example: LIBNAME data1 SPSS "C:\data\example.por"; DATA impdatatest; SET data1._FIRST_; RUN; However, I'd like to import the value labels as well without going through a long PROC FORMAT / PROC DATASETS method. PROC IMPORT can import SAV files pulling in the data for all of the records/observations, variable names and labels, and value names and labels, but I can't get the procedure to register all of the variables from the SPSS file. My example SAV file includes 402 variables, but only the first 146 are being imported. PROC IMPORT DATAFILE="C:\data\example.sav" OUT=impdatatest DBMS=SAV REPLACE; RUN; Are there limits to the number of variables that PROC IMPORT can import from SPSS files or does anyone know of a workaround to this issue? Thank you in advance for your help. Regards, Drew
... View more
I think the only caveat is if hdg wants the previous Friday even when the date given is a Friday. Then the code would just need a -0.5 added to the date: Code: %LET startdate = "27apr2012"d; %LET myfriday="%SYSFUNC(INTNX(WEEK.6,&startdate.-0.5,0),DATE9.)"d; %PUT myfriday= &myfriday.; Log: 15 %LET startdate = "27apr2012"d; 16 %LET myfriday="%SYSFUNC(INTNX(WEEK.6,&startdate.-0.5,0),DATE9.)"d; 17 %PUT myfriday= &myfriday.; myfriday= "20APR2012"d
... View more
Have you tried removing the commas from the section where you assign values in the array? i.e: array wrhse{21:22,0:2,0:1} (2100 2101 2110 2111 2120 2121 2200 2201 2210 2211 2220 2221); Don't know if that'll work, but I could see how the former would suggest more values than the dimensions of your array allow.
... View more
