Try adding the comma modifier (',') to the scan functions like this:
data want; set have; fullname=catx(', ',scan(fullname,1,','), scan(fullname,2,',')); run;
... View more
data have; input fullname $40.; datalines; Smith, Tim Howard, Matthew L. Jones, Sarah H. Charles, Andrew N. Doe, John ;;;; data want; set have; fullname=catx(', ',scan(fullname,1), scan(fullname,2)); run;
... View more
How about the proc compare part of this?
data work.carsOrig work.carsNew; set sashelp.cars; primary_account_no+1; run;
data work.carsNew; set work.carsNew; if primary_account_no= 3 then make='xxxxxxx'; run;
proc compare base=work.carsorig compare=work.carsnew out=differences outnoequal outall noprint ; by primary_account_no; run;
... View more
Instead of the CAT_ functions try this. For either character ZIP or numeric ZIP.
data new;
/* ZIP here is a number */
zipNum=4321;
zipNumCode=put(zipNum,z5.);
/* ZIP here is a character */
zipChar='5432';
zipCharCode=put(input(zipChar,5.),z5.);
run;
... View more
Check out sasbatch.sh in your <ConfigDir>\Lev1\SASApp\BatchServer directory.
You can use that and pass in -sysin <mySASProgram> -log <writeMyLogHere>
... View more
You're on the right track. You're missing:
infile inf;
before your input statement.
You will also have some data arranging to do once you call execute your %path macro. Like where and how are you going to store user, date, filename ....
Keep going. 🙂 You really don't want me to provide the answer do you?
... View more
A couple of different options.
1) Before going into SAS, run your ls -l command (1>myNewInput.txt) for all input rows. Then input myNewInput.txt
2) if xcmd is available in your SAS Session. (EG usually is not). Use the FILENAME statement with the PIPE engine and the 'ls -l' command for all of your datarows.
3.) Use a combination of the foptname and finfo functions on each of your input rows.
... View more
What happens if you try exporting using a metadata user that has access to view and execute the query? If the query accesses an RDBMS I recall some issue using a metadata unrestricted user and RDBMS passwords.
... View more
/* creating data */
data a; price_1=0.95; price_2=0.96; price_3=0.94; price_4=0.93; price_5=0.92; price_6=0.91; price_7=0.88;
price_8=0.91 ; price_9=0.89; price_10=0.88; price_11=0.93; run;
/* finding price_: variable with first value less than .9
saving value
saving variable name
and stopping
*/
data a;
set a;
length vNameOf_firstPriceLTPoint9 $32 ;
array prices {*} price_:;
n=dim(prices);
do i = 1 to n;
if prices{i}<0.9 then do ;
first_price_less_than_point9=prices{i};
vNameOf_firstPriceLTPoint9=vname(prices{i});
leave;
end;
end;
run;
This code stops looping after finding, and gives you the name of the variable who's value is less than 0.9.
... View more
